Advertisement
Guest User

Untitled

a guest
Sep 13th, 2019
188
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. var uuidList = []
  2.  
  3. var ext = new GlideRecord('u_external_order');
  4. 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");
  5. ext.setLimit(20)
  6. ext.query();
  7. var hostnameList = '';
  8. while(ext.next()){
  9.     var ps = new GlideRecord('u_external_order_ps');
  10.     ps.addQuery('u_external_order', ext.sys_id.toString());
  11.     ps.addQuery('u_name', 'input_ps');
  12.     ps.query();
  13.     if(ps.next()){
  14.        
  15.         var uuid = JSON.parse(ps.u_json_content).uuidDCServer;
  16.         uuidList.push(uuid);
  17.  
  18.     }
  19. }
  20.  
  21. gs.print(uuidList);
  22.  
  23.  
  24. for(var i=0; i<30; i++){
  25.     var gr = new GlideRecord('u_external_order');
  26.     gr.addEncodedQuery("u_customer=Siemens^u_state=2^sys_created_on>javascript:gs.dateGenerate('2019-05-01','23:59:59')");
  27.     gr.addQuery('u_request_xml', 'CONTAINS', '<field name="uuidDCServer">' + uuidList[i]);
  28.     gr.query();
  29.     if(gr.next()){
  30.         gs.print(gr.u_ritm.toString())
  31.     }
  32. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement