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

getdbfield syntax

 2 Replies
 0 Subscribed to this topic
 16 Subscribed to this forum
Sort:
Author
Messages
JackNoody
New Member Send Private Message
Posts: 3
New Member
8/10/2012 2:53 PM
Can someone please reply with the correct syntax for the getdbfield function?
We are trying to get the process level from the employee table. 
Here is what we are trying and it is not working on the EMDEPEND table:

trim(getDBField('EMPLOYEE','PROCESS_LEVEL',table.COMPANY,table.EMPLOYEE))=='1'
Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
8/14/2012 8:43 PM
I have: trim(getDBField('EMPLOYEE','PROCESS-LEVEL',table.COMPANY,table.EMPLOYEE))=='900' which is true if PROCESS-LEVEL = 900. Is 1 one of your process levels?
JackNoody
New Member Send Private Message
Posts: 3
New Member
8/23/2012 8:12 PM
Thank you that was it. We had an underscore instead of a dash for the process level variable.