PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 04/25/2016 7:25 PM by  Greg Moeller
Reporting from LBI Tables
 3 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Robby
Sr. Technology Consultant
Avaap
Veteran Member
(209 points)
Veteran Member
Posts:87


Send Message:

--
03/21/2016 9:53 AM
    I've created 2 listings reports, one lists all our InfoSets and the other lists all our Notifications (Alerts). I've looked everywhere in the LBI tables and can't seem to find where I can link these 2 lists? I would have thought there would be some data (such as "metadata id") in the notification data fields that would tell me which InfoSet is being used by a Notification (Alert).

    Has anyone figured this out?
    Greg Moeller
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    Send Message:

    --
    03/21/2016 11:15 AM
    Robby: I haven't figured this out, yet.. but when you do, I'd like a copy of your report, if you are willing and able to share.
    Robby
    Sr. Technology Consultant
    Avaap
    Veteran Member
    (209 points)
    Veteran Member
    Posts:87


    Send Message:

    --
    03/21/2016 11:54 AM
    Greg, Will do. If no one has a solution, I'm probably just going to put my own data in the description field of both the InfoSet and the Notification and join on that! I am the work-around king!!
    Greg Moeller
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    Send Message:

    --
    04/25/2016 7:25 PM
    Have you looked at the ERD's for LBI? There may be clues there...
    http://lawsonguru.com/Tech/DatabaseERDs.aspx
    You are not authorized to post a reply.