PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 03/22/2010 1:54 AM by  Chris Martin
Crystal Report on Smart Notifications
 8 Replies
Sort:
You are not authorized to post a reply.
Author Messages
JeanneS
Private
Private
Veteran Member
(123 points)
Veteran Member
Posts:49


Send Message:

--
03/04/2010 6: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
    Private
    Private
    Veteran Member
    (825 points)
    Veteran Member
    Posts:277


    Send Message:

    --
    03/05/2010 9:58 AM
    Try ENPBATREE joined to ENPUSERMAP (for the name of the owner) on USERID.
    JeanneS
    Private
    Private
    Veteran Member
    (123 points)
    Veteran Member
    Posts:49


    Send Message:

    --
    03/15/2010 9:06 PM

    Chris - Thank you for your help!

    JeanneS
    Private
    Private
    Veteran Member
    (123 points)
    Veteran Member
    Posts:49


    Send Message:

    --
    03/16/2010 9:37 AM

    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
    Private
    Private
    Veteran Member
    (825 points)
    Veteran Member
    Posts:277


    Send Message:

    --
    03/16/2010 10:26 AM
    Are you referring to the email associated with each user's device?

    FYI - This site does have ERD's for LBI.
    JeanneS
    Private
    Private
    Veteran Member
    (123 points)
    Veteran Member
    Posts:49


    Send Message:

    --
    03/16/2010 7: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
    Private
    Private
    Veteran Member
    (825 points)
    Veteran Member
    Posts:277


    Send Message:

    --
    03/16/2010 7:52 PM
    https://www.lawsonguru.com/Portals/0/images/tips/lbi/LBI-LSN-ERD.gif
    JeanneS
    Private
    Private
    Veteran Member
    (123 points)
    Veteran Member
    Posts:49


    Send Message:

    --
    03/19/2010 9:55 PM
    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
    Private
    Private
    Veteran Member
    (825 points)
    Veteran Member
    Posts:277


    Send Message:

    --
    03/22/2010 1: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.
    You are not authorized to post a reply.