Including an array field in MACRO condition (53 Views)
Reply
Advisor
Aroonkumaar
Posts: 40
Registered: ‎02-15-2012
Message 1 of 2 (53 Views)

Including an array field in MACRO condition

Experts,

 

I want to frame a MACRO condition with an array field, is there any rad function available to look for some particular sequence of string in the field.

 

For Example : update.action is an array field in incidents file and I want to look for a squence like "reassigned to MONITORING IND" and I see update.action is of type "clob" in DB.

 

Any Suggestions please?

Please use plain text.
Honored Contributor
Piku
Posts: 3,248
Registered: ‎06-17-2010
Message 2 of 2 (33 Views)

Re: Including an array field in MACRO condition

Hi,

May use indexof() function, but this will be heavy and generates lots of load.

indexof("reassigned to MONITORING IND",update.action in $L.new)>0

hth,
Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation