RSS and restrictions

 29 Replies
 1 Subscribed to this topic
 15 Subscribed to this forum
Sort:
Page 2 of 2 << < 12
Author
Messages
Greg Moeller
Veteran Member
Posts: 1498
Veteran Member
    Then I guess I'm back to using trim(getDBField('POLINESRC','REQUESTER', ...... , ......))
    What's some of the ways to finding what to pass in for the key fields?
    Greg Moeller
    Veteran Member
    Posts: 1498
    Veteran Member
      Shifting gears again... I'd like to limit on the LINE-NBR field in POLINE table so that only the requester ID that is logged in is able to see the line... Since there is no requester value in POLINE table, I'm assuming that I still need to go to the POLINESRC table.

      I'm down to passing in the key fields for POLINESRC table. Question: Is there an easy way to determine what the key fields are? Do I need to pass them in order? Do I need to pass all of them in?
      John Henley
      Posts: 3353
        https://www.lawsonguru.co...ables/polinesrc.html :)

        PLSSET1

        COMPANY
        PO-CODE
        PO-NUMBER
        PO-RELEASE
        LINE-NBR
        ORIGIN-CD
        OPER-COMPANY
        SOURCE-DOC-N
        SOURCE-DOC-A
        SRC-LINE-NBR
        Thanks for using the LawsonGuru.com forums!
        John
        Greg Moeller
        Veteran Member
        Posts: 1498
        Veteran Member
          Thank you very much, John!!!

          I got it working!! Here's how:
          On the POLINE table I've written a conditional rule on the LINE-NBR field
          trim(getDBField('POLINESRC','REQUESTER',table.COMPANY,table.PO_CODE,table.PO_NUMBER,table.PO_RELEASE,table.LINE_NBR))==trim(user.getRequesterId())

          Also, on PO30.1 I've written a conditional rule against the actual form PO30.1:
          trim(getDBField('POLINESRC','REQUESTER',form.POR_COMPANY,form.POR_PO_CODE,form.POR_PO_NUMBER,form.POR_PO_RELEASE,form.PT_LINE_NBR))==trim(user.getRequesterId())

          I've tested (very limited) with a PO with multiple requesters on it --- Since our system is set to combine items if they are the same vendor and ship-to location -- and going through RQC's receiving module, I only see the lines that belong to the specific requester.
          thanef
          Veteran Member
          Posts: 47
          Veteran Member

            Greg,

                To verify....were you just able to secure by constructing a security rule on POLINE --> LINE-NBR to retrieve the requester ID from polinesrc?  This secures the RQC --> Receiving Self Service bookmark page?
            Page 2 of 2 << < 12