Drilldown from dashboard reports opens a default view, I need to change it to a custom view.

dineshchall
Tera Contributor

I have created a dashboard and few reports, these reports are  score  and bar type, when clicked it opens a list view of records, but this list view opens in a default view and not on a specific view which I have created and enfored with a view rule. Is there a way I can open the reports list view in a specific view? am i missing any configuration here? every one see that specific view.

3 REPLIES 3

M Iftikhar
Tera Sage

Hi @dineshchall,

You can set the drilldown view on the report configuration page under style tab

 

MIftikhar_0-1761234445796.png

 

If my response helped, please mark it as the accepted solution so others can benefit as well.

 

Thanks & Regards,
Muhammad Iftikhar

If my response helped, please mark it as the accepted solution so others can benefit as well.

Yes , but after creating report i want to add that report in to data visualization then dashboard ??

MaxMixali
Giga Guru

ServiceNow – Opening Reports in a Specific List View

Issue:
When clicking on a report element (bar, score, pie segment, etc.), the resulting list view always opens in the default view instead of a custom view enforced by a View Rule.

Root Cause:
ServiceNow report drilldowns open lists via a URL like:
incident_list.do?sysparm_query=state=1
Because there is no ā€œsysparm_viewā€ parameter in the URL, the system defaults to either the user’s preferred view or the global ā€œDefaultā€ view. View Rules are not enforced for report drilldowns.

---

āœ… Solution Options

Option A: Add a View Parameter in the Report URL (Recommended)
1. Edit the report.
2. Scroll to the Drilldown section.
3. Change Drilldown Destination → ā€œDetailed URLā€.
4. Set the URL to include your desired view, for example:
incident_list.do?sysparm_query=active=true&sysparm_view=My_Custom_View

This ensures all users who click the report element will see the same custom view.

Example:
task_list.do?sysparm_query=assignment_group=Hardware&sysparm_view=Custom_View

---

Option B: Use a Client Script or UI Policy (Conditional Redirect)
If you can’t modify the report, create a list-level client script to redirect users to your desired view:

function onLoad() {
var currentView = g_list.getViewName();
if (currentView != 'my_custom_view') {
var url = new GlideURL(window.location.href);
url.addParam('sysparm_view', 'my_custom_view');
window.location.href = url.getURL();
}
}

Note: This approach is more complex and should be tested carefully.

---

Option C: Combine with View Rule
If you already have a View Rule in place, you can still add ā€œsysparm_viewā€ in the report’s drilldown URL to ensure the rule is applied consistently.

---

Option 😧 Modify Default View (System-Wide)
If your custom view should always be the default view for all users:
1. Navigate to System UI → Views.
2. Update the table’s ā€œDefaultā€ view to your custom view.

Note: This change applies globally and affects all list views for that table.

---

āš ļø View Rule Limitations
- View Rules do not trigger when navigating from reports or dashboards.
- They only apply when opening a list or record directly.
- Adding sysparm_view explicitly in the URL ensures consistency.

---

Example Use Case
Dashboard with Score report for open incidents by priority:
Clicking on ā€œHigh Priorityā€ should open the list view ā€œHigh_Priority_View.ā€

Drilldown URL:
incident_list.do?sysparm_query=priority=1^active=true&sysparm_view=High_Priority_View

---

āœ… Summary of Methods

| Method | Works for Reports | Enforced for All | Notes |
|--------|-------------------|-----------------|-------|
| Add sysparm_view in Drilldown URL | āœ… Yes | āœ… Yes | Best & simplest |
| View Rule | āŒ No | āœ… Yes (for direct navigation only) | Not triggered by reports |
| Change Default View | āœ… Yes | āœ… Yes | Global impact |
| Client Script Redirect | āœ… Yes | āš ļø Possible | Use only if report cannot be modified |

---

āœ… Final Recommendation
Reports and dashboards always open the default list view unless explicitly overridden. To enforce a specific view for everyone:

**Add ā€œ&sysparm_view=YourViewNameā€ to the report’s Drilldown URL.**

This is the cleanest, most maintainable way to control report drilldown views across all users.