using multiple sys_id in one system property value field and need to call that in Business Rule

[Abhilasha G T]

Hi team,

I have around 43 different sys_id's , for those need to trigger one Business Rule.

i have created one system property and given the sys_id in the value . and written one BR its working fine.

But i have around 43 different sys_id's  need to execute the same BR, if i put more than one sys_id in the value of system property, its not working, please suggest how can i proceed.

[ursnani]

Hi @Abhilasha G T

You can keep all the sys_id's in the property, but when you try to read the Property value it will get all the sys_id with comma separated.

So you need to wrtie a for loop and iterate through those sys_id's and achieve your requirement.

Please Mark my answer helpful if it helps you.

Thank you.

[Ashutosh C J · Accepted solution]

Hi @Abhilasha G T 
Please try this

In the property, put the SysId values with comma separator, something like this b7d2659197b5311025e49fa00153afce,b7d2659197b5311025e49fa00153afce

In the script, please use this in line 7:   wo.addQuery('template', 'IN', gs.getProperty(" your property name"));

[Abhilasha G T]

Thanks a lot its working now.

[Abhilasha G T]

Hi if i keep 43 different sys_id's in value field  in one system property, will it impact to performance, since the type is string.