How to Ignore the WHERE Filter Query for Dashboard Parameter Fields

This document provides instructions on how to ignore the WHERE filter query when a dashboard parameter is configured. To achieve this, set the DisableWhereForSelectAll property to true in the config.json file. By default, this property is set to false.

Steps to Ignore the WHERE Filter Query for Dashboard Parameter Configurations

1. Access Configuration Settings: Navigate to the following URL: http://{your_domain}/ums/administration/config-editor
   This will direct you to the configuration settings page of the UMS.
2. Select the Configuration File: In the “Search your files” drop-down menu, select the config.json file.
3. Modify the DisableWhereForSelectAll: Locate the DisableWhereForSelectAll key within the file, set its value to true and save the file.
   
   
4. Restart the Application: For the changes to take effect, restart the application.
5. Parameter Configuration: Configure the dashboard parameter in List mode, set the format to Table, and set the default value to All.
   
   
6. Data Filters Configuration: Add the created parameter field to the data filters. Refer this link for guidance.

7. ‘Where’ Clause Behavior in Dashboard: Configure the widget in the dashboard and publish it. While the data is being fetched, you can view the query.

   • If DisableWhereForSelectAll is set to true, the WHERE clause is ignored.
     

   • If DisableWhereForSelectAll is set to false, the WHERE clause is included.