Prev
Next
Forums Infor / Lawson Platforms S3 Security

getdbfield syntax

 2 Replies
 0 Subscribed to this topic
 15 Subscribed to this forum
Sort:
Author
Messages
JackNoody
New Member
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
    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
      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.