• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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