PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 1/10/2013 7:09 PM by  macjelly
LSF9: Conditional Rules
 4 Replies
Sort:
You are not authorized to post a reply.
Author Messages
macjelly
Private
Private
Basic Member
(10 points)
Basic Member
Posts:4


Send Message:

--
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
    Private
    Private
    Senior Member
    (9899 points)
    Senior Member
    Posts:3317


    Send Message:

    --
    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
    Private
    Private
    Basic Member
    (10 points)
    Basic Member
    Posts:4


    Send Message:

    --
    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
    Private
    Private
    Senior Member
    (9899 points)
    Senior Member
    Posts:3317


    Send Message:

    --
    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
    Private
    Private
    Basic Member
    (10 points)
    Basic Member
    Posts:4


    Send Message:

    --
    1/10/2013 7:09 PM
    Genius.  This works perfectly now.  Thank you so much for your help.
    You are not authorized to post a reply.