• 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
Posts: 87
Veteran Member
New Poster
New Poster
Congrats on posting!
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
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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
New Poster
New Poster
Congrats on posting!
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
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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