PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 5/3/2016 6: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
(266 points)
Veteran Member
Posts:110


Send Message:

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

    Thank you.
    Donna
    Donna
    Private
    Private
    Veteran Member
    (266 points)
    Veteran Member
    Posts:110


    Send Message:

    --
    3/3/2016 8: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
    (369 points)
    Veteran Member
    Posts:167


    Send Message:

    --
    3/29/2016 5: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
    (4163 points)
    Veteran Member
    Posts:1487


    Send Message:

    --
    4/25/2016 11: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
    Private
    Private
    Veteran Member
    (186 points)
    Veteran Member
    Posts:74


    Send Message:

    --
    4/26/2016 12:03 PM
    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
    (266 points)
    Veteran Member
    Posts:110


    Send Message:

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


    Send Message:

    --
    5/3/2016 6:59 PM
    Thank you Joan.
    You are not authorized to post a reply.