How to list all the views used in an explore in system activity?

Knowledge Drop

Last tested: Jun 9, 2020

Use this link changing the domain name to your instance one.

There are a few caveats though, if you have fields: [] then it won't list this view since there are no fields to list.

 

[DOMAIN_NAME]/explore/system__activity/field_usage?fields=view_name_list,field_usage.explore&pivots=field_usage.explore&f[view_name]=-EMPTY&sorts=field_usage.explore,calculation_2+desc+0&limit=500&query_timezone=Europe%2FDublin&vis=%7B%7D&filter_config=%7B%22view_name%22%3A%5B%7B%22type%22%3A%22%21empty%22%2C%22values%22%3A%5B%7B%22constant%22%3A%22%22%7D%2C%7B%7D%5D%2C%22id%22%3A0%2C%22error%22%3Afalse%7D%5D%7D&dynamic_fields=%5B%7B%22dimension%22%3A%22view_name%22%2C%22label%22%3A%22View+name%22%2C%22expression%22%3A%22+substring%28%24%7Bfield_usage.field%7D%2C+1%2Cposition%28%24%7Bfield_usage.field%7D%2C%5C%22.%5C%22%29-1%29%22%2C%22value_format%22%3Anull%2C%22value_format_name%22%3Anull%2C%22_kind_hint%22%3A%22dimension%22%2C%22_type_hint%22%3A%22string%22%7D%2C%7B%22measure%22%3A%22view_name_list%22%2C%22based_on%22%3A%22view_name%22%2C%22type%22%3A%22list%22%2C%22label%22%3A%22View_name_list%22%2C%22expression%22%3Anull%2C%22value_format%22%3Anull%2C%22value_format_name%22%3Anull%2C%22_kind_hint%22%3A%22measure%22%2C%22_type_hint%22%3A%22list%22%7D%5D&origin=share-expanded

This content is subject to limited support.                

Version history
Last update:
‎07-07-2021 01:13 PM
Updated by: