RSS and restrictions

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?

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?

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

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.

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?