logo

NJP

ServiceNow get a list of item_option_new sysids based on question_answer sysids from records

ServiceNow Blog · May 28, 2026 · article

 ServiceNow get a list of item_option_new sysids based on question_answer sysids from records

var endUserContainerSYSID = 'b902aa3ac3058b505c97bdac05013142';

var endUserReqSYSID = '2122627ac3058b505c97bdac0501310c';

var entitlementACRSYSID = '9f22a27ac3058b505c97bdac050131d1';

var roleACRSYSID = '6712ee3ac3058b505c97bdac0501313a';

var sEncQuery = 'table_sys_id=' + endUserContainerSYSID + 'ORtable_sys_id=' + endUserReqSYSID + 'ORtable_sys_id=' + entitlementACRSYSID + 'ORtable_sys_id=' + roleACRSYSID;

var grQA = new GlideRecord('question_answer');

grQA.addEncodedQuery(sEncQuery);

grQA.query();

while (grQA.next()) {

  getItemOptionNewSYSIDs(grQA.question + '');

}

function getItemOptionNewSYSIDs(questionSYSID) {

  var grION = new GlideRecord('item_option_new');

  grION.addQuery('sys_id', questionSYSID);

  grION.query();

  if (grION.next()) {

      gs.info(grION.question_text + ';' + grION.name+ ';' + grION.sys_id);

     

  }

}

View original source

http://www.cloudminus89.com/2026/05/servicenow-get-list-of-itemoptionnew.html