How to show the list view for a table, but ONLY load the filters (not show any records in the list)

[Tim Woodruff]

If you want to navigate to a table, just so you can filter it to find a specific subset of records, you might use the table_name.list filter-bar shortcut in the application navigator. However, if you want to show certain records in a very large table (such as sys_audit), simply navigating to the sys_audit table in order to filter it, can take a very, very long time as the table loads. In fact, in some instances (such as that of one of my clients), the sys_audit table is so large that you can't even load the list view! 

I know that there is some URI parameter that allows you to load a table with just the filter bar at the top - without loading any records in the list view. This allows you to filter the list before attempting to load it, which is EXCELLENT when you only want  a small, efficient filter on a very large table. 

I've searched high and low, but I cannot find the name of this URI parameter. Does anyone know the one I'm talking about? 

TLDR: What is the URI parameter that loads the list view of a table, but only shows the filter bar and doesn't load the records until after you've run the filter? 

[Tony DiRienzo · Accepted solution]

sysparm_filter_only=true

For example:

https://your-instance.service-now.com/sys_audit_list.do?sysparm_filter_only=true

[Tim Woodruff]

Thanks Tony, that did it! 
I think this doesn't work on List v3 though, right? Which is fine because List v3 annoys the hell out of me anyway so I'm happy to just eliminate it. 

[Tony DiRienzo]

You are correct.  The sysparm_filter_only parameter doesn't work in List v3.  There is a known error article here:

KB0620980 - In List v3, the url parameter sysparm_filter_only=true does not work properly

The recommended workaround is "disable List v3 when you need to use this parameter".  You can also disable List v3 only for problem tables, like sys_audit from the List Control settings for the table.

There is actually a lot that I like about List v3, but it's currently way too buggy to use in production.  I'm personally hoping that there is an improved version without the bugs planned for the near future.

[mrbenwhite]

hey this was helpful once i got my url edited correctly, thanks for sharing!! 

I used it for the Transaction Log today:-

https://XXXXXXXXXX.service-now.com/nav_to.do?uri=%2Fsyslog_transaction_list.do?sysparm_filter_only=true