Prev
Next
Forums Infor / Lawson Platforms S3 Security

LSF9: Conditional Rules

 4 Replies
 0 Subscribed to this topic
 15 Subscribed to this forum
Sort:
Author
Messages
macjelly
Basic Member
Posts: 4
Basic Member
1/9/2013 9:37 PM
    I have a conditional security class rule on GL95 and GL293 that I do a SUBSTR function on either the Acct Unit or the Acct Unit List.  But when I leave one of these fields blank (which I have to), I get a Java/IOS error window that pops up.  I am trying to do a SUBSTR(form.field, 6,4) on both fields and doing an AttribContains to search attribute list for that substring.

    Does anyone know how to deal with empty/null form fields when using the SUBSTR function?
    John Henley
    Posts: 3353
    1/10/2013 12:40 AM
      You need to preface it with an if(form.field.length>0 ....
      Thanks for using the LawsonGuru.com forums!
      John
      macjelly
      Basic Member
      Posts: 4
      Basic Member
      1/10/2013 3:23 PM
        Thanks for your reply.  When I typed in if(form.ACCT_UNIT_LIST.length>0..., it gave me the error "form.ACCT_UNIT_LIS is not in the scope".  It seems to truncate the last letter of the field name on any field I put in.
        John Henley
        Posts: 3353
        1/10/2013 5:51 PM
          Leave off the if( -- it is implied.
          This should work:
          trim(form.ACCT_UNIT_LIST).length>0 &&
          attributeContains(user.getRDId(),'TEST',subString(form.ACCT_UNIT_LIST,6,4))
          Thanks for using the LawsonGuru.com forums!
          John
          macjelly
          Basic Member
          Posts: 4
          Basic Member
          1/10/2013 7:09 PM
            Genius.  This works perfectly now.  Thank you so much for your help.