- Get link
- X
- Other Apps
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 sysIDs = ''; var grQA = new GlideRecord('question_answer'); grQA.addEncodedQuery(sEncQuery); grQA.query(); while (grQA.next()) { var ret = getItemOptionNewSYSIDs(grQA.question + ''); sysIDs = sysIDs + ret + ','; } var sListViewURL = 'https://dev183654.service-now.com/item_option_new_list.do?sysparm_query=sys_idIN' + sysIDs; gs.info ('FINAL URL: ' + sListViewURL); functi...