Service Manager / Service Center Practitioners Forum
cancel

Including an array field in MACRO condition

Highlighted
Aroonkumaar
Respected Contributor.

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
Acclaimed 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.