Service Manager / Service Center Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Including an array field in MACRO condition

Highlighted
Aroonkumaar
Super Collector

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?

1 REPLY
Piku
Honored Contributor

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,
____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.
//Add this to "OnDomLoad" event