Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3288
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1348
Roger French	1311
mark.cook	1244

LSF9: Conditional Rules

Sort:

You are not authorized to post a reply.

Author

Messages

macjelly

Basic Member

Posts: 4

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

Senior Member

Posts: 3348

1/10/2013 12:40 AM

You need to preface it with an if(form.field.length>0 ....

macjelly

Basic Member

Posts: 4

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

Senior Member

Posts: 3348

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))

macjelly

Basic Member

Posts: 4

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.