Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var uuidList = []
- var ext = new GlideRecord('u_external_order');
- ext.addEncodedQuery("sys_updated_by=grzegorz.chwalek@engage-esm.com^sys_updated_onONYesterday@javascript:gs.beginningOfYesterday()@javascript:gs.endOfYesterday()^ORsys_updated_onON2019-07-30@javascript:gs.dateGenerate('2019-07-30','start')@javascript:gs.dateGenerate('2019-07-30','end')^u_transactionid!=DC-0153_RequestStorage_v1^ORu_transactionid=NULL");
- ext.setLimit(20)
- ext.query();
- var hostnameList = '';
- while(ext.next()){
- var ps = new GlideRecord('u_external_order_ps');
- ps.addQuery('u_external_order', ext.sys_id.toString());
- ps.addQuery('u_name', 'input_ps');
- ps.query();
- if(ps.next()){
- var uuid = JSON.parse(ps.u_json_content).uuidDCServer;
- uuidList.push(uuid);
- }
- }
- gs.print(uuidList);
- for(var i=0; i<30; i++){
- var gr = new GlideRecord('u_external_order');
- gr.addEncodedQuery("u_customer=Siemens^u_state=2^sys_created_on>javascript:gs.dateGenerate('2019-05-01','23:59:59')");
- gr.addQuery('u_request_xml', 'CONTAINS', '<field name="uuidDCServer">' + uuidList[i]);
- gr.query();
- if(gr.next()){
- gs.print(gr.u_ritm.toString())
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement