Prev
Next
Forums Performance Management Smart Notification

Reporting from LBI Tables

 3 Replies
 0 Subscribed to this topic
 14 Subscribed to this forum
Sort:
Author
Messages
Robby
Veteran Member
Posts: 87
Veteran Member
3/21/2016 1:53 PM
    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
    3/21/2016 3:15 PM
      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
      3/21/2016 3:54 PM
        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
        4/25/2016 11:25 PM
          Have you looked at the ERD's for LBI? There may be clues there...
          http://lawsonguru.com/Tech/DatabaseERDs.aspx