HPE Service Manager / Service Center Support and News 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 REPLIES
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.