Need Help on how to use IndexOf in below query.

Alok21 · ‎02-27-2019

Hi Team,

Need your assistance on below query.

I am trying to set a condition for notification to get triggered. I am now got stuck on how to use indexOf in below gliderecord query. So what i am trying to compare is, When the catalog is "Technical Catalog", notification should not be sent. Below is the script i have and it is triggering even for "Technical Catalog" which it should not.

Can anyone please help on this, what am i doing wrong?

answer = true;
var gr = new GlideRecord("sc_req_item");
gr.addQuery("request", current.sys_id);
gr.query();
if (gr.next()) {
if (gr.cat_item.sc_catalogs == indexOf(gs.getProperty("tc.item.catalogs.type")));
answer = false;
}

Regards,

Alok kumar sahu

Ashutosh Munot1 · ‎02-27-2019

HI,

If the value exist then it will return its position and if it does not then it will return -1.

So we have to compare that as well. Use below code:

if(gr.cat_item.sc_catalogs.indexOf(gs.getProperty("tc.item.catalogs.type")) >-1)

//THis means if the value in gr.cat_item.sc_catalogs is present in ur property then it will enter if loop.

Thanks,
Ashutosh

View solution in original post

prasannaposetty · ‎02-27-2019

Hi Alok,

Try creating the notification on Requested Item table (sc_req_item) and in the conditions you can directly mention, Catalog is not Technical Catalog.

Regards,

Prasanna