Crystal Report on Smart Notifications

JeanneS

Veteran Member

Posts: 49

3/4/2010 11:58 PM

I am trying to create a crystal report based on the LBI database that lists the names of all Smart Notifications along with owner and date created. Can anyone tell me what table I should use?

Thanks in advance!

Chris Martin

Veteran Member

Posts: 277

3/5/2010 2:58 PM

Try ENPBATREE joined to ENPUSERMAP (for the name of the owner) on USERID.

JeanneS

Veteran Member

Posts: 49

3/16/2010 1:06 AM

Chris - Thank you for your help!

JeanneS

Veteran Member

Posts: 49

3/16/2010 1:37 PM

Do you know which table the actual e-mail address is on? I can't find any documentation on the LBI tables. Thanks.

Chris Martin

Veteran Member

Posts: 277

3/16/2010 2:26 PM

Are you referring to the email associated with each user's device?

FYI - This site does have ERD's for LBI.

JeanneS

Veteran Member

Posts: 49

3/16/2010 11:46 PM

Yes, I am looking for e-mail addresses associated with user devices. I will take a look at the ERDs. I didn't notice they were on this site. Thanks for your help.

Chris Martin

Veteran Member

Posts: 277

3/16/2010 11:52 PM

https://www.lawsonguru.com/Portals/0/images/tips/lbi/LBI-LSN-ERD.gif

JeanneS

Veteran Member

Posts: 49

3/20/2010 1:55 AM

Chris - thanks for the ERDs. They were helpful. I still can't locate the actual field where the Smart Note e-mail address is stored. I found the device name in the ENTRYSTRING field on the ENPBATREE table. Do you know what field houses the e-mail address?

Chris Martin

Veteran Member

Posts: 277

3/22/2010 5:54 AM

Not 100% sure, but thinking it be in a blob field in one of the SN tables. I'll have a chance to look a bit more later this week and will let you know what I find.