Export incidents records to PDF, Excel or CSV from portal

[MalikB]

Hello everyone i need to solve a defect about exporting records incidents who doesnt work in portal while the task export works, someone to help? 

[GlideFather]

Hi @MalikB,

could you possibly provide some context? This is not so clear..

Tell us what you want to happen and what happened instead, also if you have some logs, error messages or any details... you mentioned "defect" but how do you understand it? you exported it and nothing happened, or was it exported to undesired format, or it got frozen, ... please describe your issue ;)) the better question, the better answer.

[SIVASANKARIS]

Hi @MalikB ,

What message you are getting when you clicks export

please share the Screenshot if possible...

[MalikB]

Well there in the portal like in the capture there is two tabs one with RITM records the other incidents records when i export csv file of RITM i have all the records i have in the portal in the file while for incident i export an empty file

when i open the widget in editor i have this server script 

(function() {
	if (!input) // asynch load list
		return;

	data.instance_url = gs.getProperty('glide.servlet.uri');

	var perimeter = gs.action.getGlideURI().getMap().get('perimeter') ; 

	data.msg = {};
	data.msg.sortingByAsc = gs.getMessage("Sorting by ascending");
	data.msg.sortingByDesc = gs.getMessage("Sorting by descending");


	/*
	 * data.table = the table
	 * data.p = the current page starting at 1
	 * data.o = the order by column
	 * data.d = the order by direction
	 * data.keywords = the keyword search term
	 * data.list = the table data as an array
	 * data.invalid_table = true if table is invalid or if data was not succesfully fetched
	 * data.table_label = the table's display name. e.g. Incident
	 * data.table_plural = the table's plural display name. e.g. Incidents
	 * data.fields = a comma delimited list of field names to show in the data table
	 * data.column_labels = a map of field name -> display name
	 * data.window_size = the number of rows to show
	 * data.filter = the encoded query
	 */
	// copy to data[name] from input[name] || option[name]
	optCopy(['table', 'p', 'o', 'd', 'filter', 'filterACLs', 'fields', 'keywords', 'view']);
	optCopy(['relationship_id', 'apply_to', 'apply_to_sys_id', 'window_size']);
	if (!data.table) {
		data.invalid_table = true;
		data.table_label = "";
		return;
	}

	/*	
	if(input.active_tab == "request_is_active"  || perimeter == "" || perimeter == "csie_requests" ){
		 data.table = "task" ;  
	}
*/
	if(input.active_tab == "incident_is_active" ||  perimeter == "csie_incidents" ){
		data.table = "incident" ; 
		data.view = "csie_portail" ;  
	}else /*if( input.active_tab == "request_is_active" ||  perimeter == "csie_requests" ) */{
		data.table = "task" ; 
		data.view = "csie_portail_task" ; 
	}



	//	if (!data.fields) {
	if (data.view)
		data.fields = $sp.getListColumns(data.table, data.view);
	else
		data.fields = $sp.getListColumns(data.table);
	//}


	data.title = "header title " ; //input.headerTitle;
	//data.view = data.view || 'mobile';
	data.table = data.table || $sp.getValue('table');
	data.filter = data.filter || $sp.getValue('filter');


	data.keywords = data.keywords || $sp.getValue('keywords');


	//---------------------------------------
	if( data.table == "task") {
		data.fields = "number,short_description,opened_by.user_name,opened_by,opened_by.cost_center.code,u_requested_for.user_name,u_requested_for,u_requested_for.cost_center.code,state,sys_created_on,sys_updated_on" ;
		data.filter = "sys_class_name=sc_request^ORsys_class_name=sc_req_item^closed_atONLast 3 months@javascript:gs.beginningOfLast3Months()@javascript:gs.endOfLast3Months()^ORactive=true^u_perimeter_csieDYNAMICd6435e965f510100a9ad2572f2b47744" ;  
	} 
	else if (  data.table == "incident" ){ 
		data.fields = "number,short_description,caller_id.user_name,caller_id,caller_id.cost_center.code,u_requested_for.user_name,u_requested_for,u_requested_for.cost_center.code,state,sys_created_on,sys_updated_on" ; 
		data.filter = "closed_atONLast 3 months@javascript:gs.beginningOfLast3Months()@javascript:gs.endOfLast3Months()^ORactive=true^u_perimeter_csieDYNAMICd6435e965f510100a9ad2572f2b47744" ;  

	}
	//--------------------------------------	

	data.active_task = data.active_task || $sp.getValue('active_task');
	data.p = data.p || $sp.getValue('p') || 1;
	data.p = parseInt(data.p);
	data.page_index = data.p - 1;//AJOU NES
	data.o = data.o || $sp.getValue('o') || $sp.getValue('order_by');
	data.d = data.d || $sp.getValue('d') || $sp.getValue('order_direction');
	data.page_index = data.p - 1;
	data.show_new = data.show_new || options.show_new;
	var windowSize = data.window_size || $sp.getValue('maximum_entries') || 20;
	windowSize = parseInt(windowSize);
	if (isNaN(windowSize) || windowSize < 1)
		windowSize = 20;
	data.window_size = windowSize;

	data.window_start = data.page_index * data.window_size;//AJOU NES
	data.window_end = (data.page_index + 1) * data.window_size;// AJOU NES 



	var gr;
	//-------------------------------------------------
	//gr = new GlideRecord(data.table) ; 
	//gr.addEncodedQuery( data.filter ) ; 
	gr = new GlideRecord(data.table);
	gr.addEncodedQuery(data.filter);
	gr.orderBy(data.o || 'sys_created_on'); // Remplacez 'sys_created_on' par la colonne souhaitée
	gr.chooseWindow(data.window_start, data.window_end);
	gr.query();

	//-------------------------------------------------

	/*
	if (gs.getProperty("glide.security.ui.filter") == "true" || GlideTableDescriptor.get(data.table).getED().hasAttribute("glide.security.ui.filter")) {
		gr = new FilteredGlideRecord(data.table);
		gr.applyRowSecurity();
	} else
		gr = new GlideRecordSecure(data.table, data.filter);
	if (!gr.isValid()) {
		data.invalid_table = true;
		data.table_label = data.table;
		return;
	}
*/
	data.canCreate = gr.canCreate();
	data.newButtonUnsupported = data.table == "sys_attachment";
	data.table_label = gr.getLabel();
	data.table_plural = gr.getPlural();
	data.hasTextIndex = $sp.hasTextIndex(data.table);
	/*if (data.filter) {
		if (data.filterACLs)
			gr = $sp.addQueryString(gr, data.filter);
		//else
			//gr.addEncodedQuery(data.filter);
	}*/


	data.getFamily = $sp.getParameter("sys_id");
	//gr.addEncodedQuery("u_family="+ data.getFamily);


	var task_key_word ; 
	if (data.keywords){
		// gr.addQuery('123TEXTQUERY321', data.keywords);

		if(data.table == "task"){


			task_key_word = 
				"numberLIKE"+  data.keywords +
				"^ORshort_descriptionLIKE"+  data.keywords +
				"^ORopened_by.user_nameLIKE"+  data.keywords +
				"^ORopened_byLIKE"+  data.keywords +
				"^ORopened_by.cost_center.codeLIKE"+  data.keywords +
				"^ORu_requested_for.user_nameLIKE"+  data.keywords +
				"^ORu_requested_forLIKE"+  data.keywords +
				"^ORu_requested_for.cost_center.codeLIKE"+  data.keywords +
				"^ORstateLIKE"+  data.keywords ; 

		}else if( data.table == "incident" ) {


			task_key_word = 
				"numberLIKE"+  data.keywords +
				"^ORshort_descriptionLIKE"+  data.keywords +
				"^ORcaller_id.user_nameLIKE"+  data.keywords +
				"^ORcaller_idLIKE"+  data.keywords +
				"^ORcaller_id.cost_center.codeLIKE"+  data.keywords +
				"^ORu_requested_for.user_nameLIKE"+  data.keywords +
				"^ORu_requested_forLIKE"+  data.keywords +
				"^ORu_requested_for.cost_center.codeLIKE"+  data.keywords +
				"^ORstateLIKE"+  data.keywords ;
		}

		gr.addEncodedQuery( task_key_word ) ; 
		//data.keywords = null;
	}

	if(input.active_task == "true" || input.active_task == true || data.active_task == true) {
		data.active_task = true ; 
		gr.addActiveQuery();

		var temp_filter = data.filter  ; 
		data.filter = temp_filter + "^active=true"  ;       
	}else{
		data.active_task = false ; 
		var temp_filter = data.filter  ; 
		data.filter = temp_filter.toString().replace("^active=true" , "") ; 
	}


	//	data.filter = gr.getEncodedQuery();

	if (data.o){
		if (data.d == "asc")
			gr.orderBy(data.o);
		else
			gr.orderByDesc(data.o);
	}

	data.window_start = data.page_index * data.window_size;
	data.window_end = (data.page_index + 1) * data.window_size;
	gr.chooseWindow(data.window_start, data.window_end);
	gr._query();

	data.row_count = gr.getRowCount();
	data.num_pages = Math.ceil(data.row_count / data.window_size);
	data.column_labels = {};
	data.fields_array = data.fields.split(',');

	// use GlideRecord to get field labels vs. GlideRecordSecure
	var grForLabels = new GlideRecord(data.table);
	for (var i in data.fields_array) {
		var field = data.fields_array[i];
		var ge = grForLabels.getElement(field);
		if (ge == null)
			continue;

		data.column_labels[field] = ge.getLabel();	

	}

	if(data.table == "task"){
		data.column_labels['opened_by.user_name'] = "CP demandeur" ; 
		data.column_labels['opened_by.cost_center.code'] = "Code RG demandeur" ; 
		data.column_labels['u_requested_for.user_name'] = "CP bénéficiaire" ; 
		data.column_labels['u_requested_for.cost_center.code'] = "Code RG bénéficiaire" ;		
	}else if(data.table == "incident"){
		data.column_labels['caller_id.user_name'] = "CP déclarant" ; 
		data.column_labels['caller_id.cost_center.code'] = "Code RG déclarant" ;
		data.column_labels['u_requested_for.user_name'] = "CP bénéficiaire" ; 		
		data.column_labels['u_requested_for.cost_center.code'] = "Code RG bénéficiaire" ;	
	}



	data.list = [];
	while (gr._next()) {
		var record = {};
		$sp.getRecordElements(record, gr, data.fields);

		if (gr instanceof FilteredGlideRecord) {
			// FilteredGlideRecord doesn't do field-level
			// security, so take care of that here

			for (var f in data.fields_array) {
				var fld = data.fields_array[f];
				if (!gr.isValidField(fld))
					continue;

				if (!gr[fld].canRead()) {
					record[fld].value = null;
					record[fld].display_value = null;
				}
			}
		}
		record.day2 = gr.u_service_catalog.u_day2.toString();
		record.sys_id = gr.getValue('sys_id');
		record.targetTable = gr.getRecordClassName();
		if(record["ref_cmdb_ci_hardware.used_for"].value == ""){
			record["ref_cmdb_ci_hardware.used_for"].value = record["ref_cmdb_ci_appl.used_for"].value;
			record["ref_cmdb_ci_hardware.used_for"].display_value = record["ref_cmdb_ci_appl.used_for"].display_value;
		}
		data.list.push(record);
	}

	if(  gr.getRowCount() == 0  ) {
		data.list = [] ; 
	}

	data.row_count = gr.getRowCount();//AJOU NES
	data.num_pages = Math.ceil(data.row_count / data.window_size);// AJOU NES
	data.enable_filter = (input.enable_filter == true || input.enable_filter == "true" ||
												options.enable_filter == true || options.enable_filter == "true");
	var breadcrumbWidgetParams = {
		table: data.table,
		query: data.filter,
		enable_filter: data.enable_filter
	};
	data.filterBreadcrumbs = $sp.getWidget('widget-filter-breadcrumbs', breadcrumbWidgetParams);

	// copy to data from input or options
	function optCopy(names) {
		names.forEach(function(name) {
			data[name] = input[name] || options[name];
		})
	}

})();