PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 05/03/2016 2:59 PM by  Lance Kelley
List of bursting rights, elements and users
 6 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Donna
Private
Private
Veteran Member
(256 points)
Veteran Member
Posts:106


Send Message:

--
03/03/2016 3:02 PM
    What tables have the bursting information fields?

    Thank you.
    Donna
    Donna
    Private
    Private
    Veteran Member
    (256 points)
    Veteran Member
    Posts:106


    Send Message:

    --
    03/03/2016 3:55 PM
    Well, I answered my own question with a little help from the guru archives.

    The tables are ERS_RULEMASTER, ERS_RULE DETAIL, ERS_ELEMENTS, ERS_STRUCTURE. There are additional tables in ERS but the ones listed solved my requirements.
    Kelly H
    Private
    Gordon Food Service
    Veteran Member
    (361 points)
    Veteran Member
    Posts:163


    Send Message:

    --
    03/29/2016 1:26 PM
    Are these tables listed with your other Lawson tables? Or did you have to go to a different location?
    Greg Moeller
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    Send Message:

    --
    04/25/2016 7:22 PM
    They are actually under the LBI schema (if you are running Oracle) They default to LawsonFS, LawsonRS, LawsonSN.. but your DBA could have named them anything.
    MSSQL treats them a little bit differently... and they could really be anywhere.
    Joan Herzfeldt
    System Analyst
    Genesis Health System
    Veteran Member
    (134 points)
    Veteran Member
    Posts:50


    Send Message:

    --
    04/26/2016 8:03 AM
    This might help. I prefer to create views and use crystal to format the data. Here is the view I created to pull our rights.
    select
    M.RULEID
    , U.CONSUMERID AS USERORROLE
    , M.RULENAME
    , M.RULEOWNER
    , M.STARTDATE --datetime field for CR
    , M.ENDDATE --datetime field for CR
    , D.STRUCTUREID, S.STRUCTURENAME
    , D.ELEMENTID, E.ELEMENTNAME
    , D.ELEMENTORDER
    , V.SEQUENCEID
    , D.OPERAND
    , V.ELEMENTVALUE1
    , D.ELEMENTVALUE2
    , V.RULEGROUPING

    FROM ERS_RULEMASTER M
    JOIN ERS_RULEMAPPINGS U ON M.RULEID = U.RULEID
    JOIN ERS_RULEDETAIL D ON M.RULEID = D.RULEID
    JOIN ERS_RULEVALUES V ON D.RULEID = V.RULEID and D.STRUCTUREID = V.STRUCTUREID and D.ELEMENTID = V.ELEMENTID
    JOIN ERS_STRUCTURE S ON D.STRUCTUREID = S.STRUCTUREID AND S.STATUS = 'A'
    JOIN ERS_ELEMENTS E ON D.ELEMENTID = E.ELEMENTID
    where M.STATUS = 'A' --active records

    Joan
    Donna
    Private
    Private
    Veteran Member
    (256 points)
    Veteran Member
    Posts:106


    Send Message:

    --
    04/26/2016 4:41 PM
    Nice
    Lance Kelley
    Private
    Private
    Advanced Member
    (57 points)
    Advanced Member
    Posts:24


    Send Message:

    --
    05/03/2016 2:59 PM
    Thank you Joan.
    You are not authorized to post a reply.