Who's On?

	Membership:
	Latest: DaptonConsultancyServices
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5206

	People Online:
	Visitors: 467
	Members: 0
	Total: 467

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chesca	1042

LSF9: Conditional Rules

4 Replies

0 Subscribed to this topic

18 Subscribed to this forum

Sort:

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

Posts: 3363

New Poster

Engaged Reader

Avid Reader

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

Posts: 3363

New Poster

Engaged Reader

Avid Reader

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.