Multiple Incidents visible in My Requsts

[jbasa]

How can I have one My Request page list for 5 different departments' Incidents?

So I have 5 groups each with their table. for example we have IT using INC#######, Account AR using AR#######, AP with AP#######, and two other groups

I want a caller to go to one My Request page see active across those incident tables and then change to closed or watched ones as well.  Of course, searchable would be nice.

Can it be done?

[Dr Atul G- LNG]

Hi @jbasa 

A caller can go and close incident one by one.

[jbasa]

I think you misunderstood.  I am looking for a way to allow a caller to all the incident records from 5 different tables on that page.  With the ability to filer them, delete them, change views etc.

I have tables/producers (forms) for my IT Incidents, AR Incidents, AP Incidents, and two others. I dont want a My requests page for each of them

[saurabh_dubey]

Hi @jbasa,

I guess you are talking about the My request page widget in that the widget is been used My requests, you have to do major configurations in that.

So as per my experience there are two widgets "My Requests (my-requests-v2)" and "My Requests (legacy)", here (my-requests-v2) has a enhanced features as depicted in @Dr Atul G- LNG response in the thread that uses cart js api.

There is another widget My Requests (legacy) here it is a simple list which queries the (sc_request table) now may be you have to configure this widget to achieve your desired result, but you won't get the enhanced ui 

let me paste which code : for My Request legacy will have to work.

	var gr = new GlideRecordSecure('sc_request'); // does ACL checking for us... you migh have to use the table here 
	gr.addActiveQuery();
	options.title = options.title || gr.getPlural();
	data.display_field = 'sys_created_on';
	data.secondary_fields = ['number','sys_updated_on'];
	data.filterMsg = gs.getMessage("Filter...");

	gr.addEncodedQuery('requested_for=javascript:gs.getUserID()');// Modifications needs to done here
	gr.orderByDesc('sys_created_on');
	gr.query();
	data.count = gr.getRowCount();
	data.list = [];
	var recordIdx = 0;
	while (gr.next()) {
		if (recordIdx == options.maximum_entries)
			break;

		var record = {};
		record.sys_id = gr.getValue('sys_id');
		var ritm = new GlideRecord("sc_req_item"); // I don't think this is needed
		ritm.addQuery("request", gr.getUniqueValue());
		ritm.query();
		if (ritm.getRowCount() == 0)
			continue;

		if (ritm.getRowCount() > 1)
			record.display_field = gs.getMessage("{0} requested items", ritm.getRowCount());
		else {
			ritm.next();
			record.display_field = ritm.cat_item.getDisplayValue() || ritm.getDisplayValue("short_description");
		}

		record.secondary_fields = [];
		data.secondary_fields.forEach(function(f) {
			record.secondary_fields.push(getField(gr, f));
		});

		record.url = {id: 'sc_request', table: 'sc_request', sys_id: record.sys_id};
		data.list.push(record);
		recordIdx++;
	}

Now for more enhance version of UI Uffff "Ahhhhhhh" more coding but more interesting but wait hell lot of debugging no worries. "my-requests-v2" do search for this widget FYI the My Requests page uses my-requests-v2 widget which @Dr Atul G- LNG had mentioned in his comment.

Also, my suggestion do check out the Employee center pro plugin because there also we have my-requests-v2 version of request.

If my response helps you do mark it as helpful and hit the solved button.

Thanks and regards,

Saurabh Dubey

[James Chun]

Hi @jbasa,

It's rather weird that you have all these different tables for storing Incidents..

If you want to include all these Task extended tables in the 'My Request' page, you can create/update the 'My Request Filters'.

1. Navigate to Service Catalog > Catalog Administration > My Request Filter
2. Create or edit existing filters to incorporate different departments' incident tables

Thanks