Hi Ashley,
As per my understanding sc_item_option_mtom table is a relation between sc_req_item and sc_item_option tables which allows you to get the list of RITMS being updated for any particular variable with any specific value.
sc_req_item: Contains the record of RITMS
sc_item_option: contains the variables being updated with what values.
Now the below code.
var gr = new GlideRecord('sc_item_option_mtom'); // We are doing the GlideRecord on sc_item_option_mtom which is having a relationship between sc_req_item and sc_item_option tables
gr.addQuery('sc_item_option.item_option_new.name','item_name'); // Here we are providing the name of the variable. sc_item_option is a reference field which holds the the updated variables records, so we are passing the name of the variable which was updated
gr.addQuery('sc_item_option.value','item_value'); // Here we are providing the value of the variable which was updated
gr.query();
while(gr.next())
{ gs.addInfoMessage(gr.request_item.number); } // this will give you name of the RITMS which meets the above Query criteria
I ran the below script in background script and got the result.
var gr = new GlideRecord('sc_item_option_mtom');
gr.addQuery('sc_item_option.item_option_new.name','Client'); //variable name is Client
gr.addQuery('sc_item_option.value','AT&T'); //Variable value is AT&T
gr.query();
while(gr.next())
{ gs.log(gr.request_item.number); }
Result:
List of RITMs in which Client variable was updated with value AT&T
Hope this helps.
