Name

global.QueryBuilderReports

Description

No description available

Script

var QueryBuilderReports = Class.create();
QueryBuilderReports.prototype = {
  initialize: function() {},

  getQueryLatestExecutionId: function(savedQueryId) {
  	var executionId = '';
  	var resultTable = '';
  	var status = ['COMPLETE', 'MAX_LIMIT'];
  	
  	var glideSavedQuery = new GlideRecord('qb_saved_query');
  	glideSavedQuery.addQuery('sys_id', savedQueryId);
  	glideSavedQuery.query();
  	
  	if(glideSavedQuery.next() && glideSavedQuery.canRead()){
  		resultTable = glideSavedQuery.getValue('result_table');
  	}
  	
  	if (JSUtil.notNil(resultTable)) {
          var glideQbStatus = new GlideRecord('qb_query_status');
          glideQbStatus.addQuery('table_name', resultTable);
  		glideQbStatus.addQuery('status', 'IN', status);
          glideQbStatus.orderByDesc('sys_updated_on');
          glideQbStatus.setLimit(1);
          glideQbStatus.query();
          
          if (glideQbStatus.next() && glideQbStatus.canRead()) {
              executionId = glideQbStatus.getValue('sys_id');
          }
      }
      return executionId;
  },

  type: 'QueryBuilderReports'
};

Sys ID

a4b2fce47753330033b5270bba106184

Offical Documentation

Official Docs: