• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Infor / Lawson Platforms S3 Security

AP90 Security

 1 Replies
 0 Subscribed to this topic
 16 Subscribed to this forum
Sort:
Author
Messages
Sandra Badini
New Member Send Private Message
Posts: 3
New Member
1/14/2013 8:08 PM
I am trying to limit AP90 security to PO Vendors only.  I tried the following rule on the AP tables used by AP90 without success.  Has anyone tried to create this type of security rule before?

table.VENDOR == getDBField('POVENDOR','VENDOR',table.VENDOR_GROUP, table.VENDOR)
Georgette
Veteran Member Send Private Message
Posts: 52
Veteran Member
2/19/2013 3:55 PM
I am new, but I was told to use the trim function when accessing tables. Trim is for alpha numeric and lztrim for leading zeroes. So check what the data type is.

trim(getDBField(.....)) == trim(table. ____)