Reporting from LBI Tables

Author
Messages
Robby
Veteran Member
Posts: 87
Veteran Member
    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
    Veteran Member
    Posts: 1498
    Veteran Member
      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
      Veteran Member
      Posts: 87
      Veteran Member
        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
        Veteran Member
        Posts: 1498
        Veteran Member
          Have you looked at the ERD's for LBI? There may be clues there...
          http://lawsonguru.com/Tech/DatabaseERDs.aspx
          ---