Using RITM Variables value in GlideRecord.

[Mohan Mallapu]

HI All,,

Appreciate your help..!
My Requirement : i have the catalog item sysid, Requested for, and variable value. Here i have to Query sc_req_item  with these details need to find the RITM number .
Simple Query :

var Item = new GlideRecord('sc_req_item');

requestItem.addQuery('requested_for', 'user sysid');

requestItem.addQuery('cat_item', 'catalog item sys id')
requestItem.addQuery('variables.variablename','IN','variable Value');

requestItem.query();

if(requestItem.next()){

//if RITM exist need to something here

}

this is how i want to find the RITM number. but this logic is not working .. Could anyone please help me on this ..

[MrMuhammad]

Try something like below

var requestItem = new GlideRecord('sc_req_item');
requestItem.addQuery('requested_for', 'user sysid');
requestItem.addQuery('cat_item', 'catalog item sys id')
requestItem.query();

if(requestItem.next()){
   if(requestItem.variables.variablename = "variable Value"){
      //DO SOMETHING HERE.....
   }
}

[MrMuhammad]

Just for explanation, variables doesn't exist on RITM table instead variables are stored in a separate table so you cannot apply query on variables while your glide record is on requested item table.

These are the tables that hold variables and variable values.

M2M table to request item
sc_item_option_mtom.request_item

M2M table to variable
sc_item_option_mtom.sc_item_option

[Mohan Mallapu]

@Muhammad  Thanks for the Quick reply.

I have followed your query.. But here my variable is a list collector and holding two sysid values.
from these 2 sys id's i want to fetch the record for specific sysid.

[MrMuhammad]

Hey @Mohan Mallapu,

You can update the if condition within the while loop as below

var ritmVariableValue = requestItem.variables.variablename;
ritmVariableValue = ritmVariableValue.toString(); 
if(ritmVariableValue.indexOf("variable Value") > -1){
  //DO SOMETHING HERE
}