Service Manager / Service Center Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

Including an array field in MACRO condition

Advisor

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
Honored Contributor 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.