--- title: "Adding Query Filters to Grid Columns" slug: "adding-filters-to-grid-column" description: "Filter a grid on one column using a query: open the query screen from the column header, set the criteria, and run or save the filter." status: "update" updated: 2026-11-12T15:34:10Z published: 2026-11-12T15:34:10Z canonical: "ims-handbook.cenosco.com/adding-filters-to-grid-column" --- > ## Documentation Index > Fetch the complete documentation index at: https://ims-handbook.cenosco.com/llms.txt > Use this file to discover all available pages before exploring further. # Adding Query Filters to Grid Columns A column filter lets you filter a grid on one column by using a query, which gives you more filtering options than the standard grid filters. When you click the *Filter* button in a column header, IMS opens a query screen that is already set up for that column. You choose how to compare the column's values, and the grid is filtered accordingly. You can run the filter once or save it as a query to reuse later. This article explains how to set up a column filter. For background on queries, see [Queries - Overview](/v414/docs/queries-overview). To build a query from scratch, see [Custom Queries Editor](/v414/docs/custom-queries-editor). ## Create a Column Filter 1. Hover over the header of the column you want to filter on. The *Filter* button appears. ![The Description column header with the Filter button highlighted.](https://cdn.document360.io/e492a0e0-a4ba-4aca-8fc6-76b95f91fdf3/Images/Documentation/filter_button.png?sv=2026-02-06&spr=https&st=2026-11-13T00%3A19%3A05Z&se=2026-11-13T01%3A19%3A05Z&sr=c&sp=r&sig=VgNqjnlGeII9dUk2MjejTvFk7LmQHRLU%2F1GsRR57stQ%3D) 1. Click the *Filter* button. The query screen opens, and the column name is filled in automatically in the Criteria section. ![The New query screen with the Name and Visibility fields highlighted in yellow and a Description criterion.](https://cdn.document360.io/e492a0e0-a4ba-4aca-8fc6-76b95f91fdf3/Images/Documentation/query_screen.png?sv=2026-02-06&spr=https&st=2026-11-13T00%3A19%3A05Z&se=2026-11-13T01%3A19%3A05Z&sr=c&sp=r&sig=VgNqjnlGeII9dUk2MjejTvFk7LmQHRLU%2F1GsRR57stQ%3D) 1. To save the query for reuse, complete the top section of the query screen. The fields highlighted in yellow are required. To only run the filter, skip this step. See [Complete the Query Details](/v414/docs/adding-filters-to-grid-column#complete-the-query-details). 2. In the **Criteria** section, select how to compare the column's values, and then enter the value. See [Set the Criteria](/v414/docs/adding-filters-to-grid-column#set-the-criteria). 3. Click one of the following buttons: - **Save** to save the query for reuse. The query is saved in the folder you selected. See [Listing All Queries](/v414/docs/listing-queries). - **Run without saving** to filter the grid without saving the query. - **Cancel** to close the query screen without filtering the grid. The grid is filtered according to your criteria. > [!NOTE] > Note > > If the FLOC grid layout is set to *Hierarchical View* instead of *Flat List*, grid column filters are not available. To use a column filter on the FLOC grid, first set the view to *Flat List*. ## Complete the Query Details The top section of the query screen defines the query itself. You can leave it empty when you only run the filter. To save the query, complete at least the fields highlighted in yellow. | Field | What to enter | | --- | --- | | **Name** (required) | Enter a name for the query. | | **Folder name** | Select the folder to store the query in. The default is **My queries**. To create your own folder, see [Custom Queries Editor](/v414/docs/custom-queries-editor#create-a-personal-folder). | | **Visibility** (required) | Select **Private & visible only to you** (the default) or **Public & visible to everyone**. | | **Base view** | Shows the view the query is based on, for example "Equipment Main". It is filled in automatically. | | **GridActionBarTemplate** | Optional. Enter the name of an additional template to show after the standard grid action bar of the query. | | **Percent Base Query** | Select this check box to make the query usable as the base count for showing percentages on dashboards. | | **Query Description** | Enter a short description of the data the query returns. | | **Send report** | Select this check box to send the query results as a report. | ## Set the Criteria The **Criteria** section defines which rows the filter keeps. It starts with the column you clicked. Select an operator from the second drop-down, for example "equals", "starts with", or "contains", and then enter the value to compare against. The image below shows all available operators. ![The Criteria section with the operator drop-down open, listing all operators.](https://cdn.document360.io/e492a0e0-a4ba-4aca-8fc6-76b95f91fdf3/Images/Documentation/query_criteria.png?sv=2026-02-06&spr=https&st=2026-11-13T00%3A19%3A05Z&se=2026-11-13T01%3A19%3A05Z&sr=c&sp=r&sig=VgNqjnlGeII9dUk2MjejTvFk7LmQHRLU%2F1GsRR57stQ%3D) To match more than one value, select **in (; separated)**, and then separate the values with semicolons. To add another criterion, click the *Plus* button below the first one. For additional information on how to set criteria, see [Custom Queries Editor](/v414/docs/custom-queries-editor#filter-the-dataset). ## FLOC Grids in Hierarchical View In *Hierarchical View*, the column headers don't show the *Filter* button, as in the first image below. The list is sorted by the subordinate FLOCs in the next FLOC level, as in the second image. ![FLOC grid in Hierarchical View with no Filter button in the column headers.](https://cdn.document360.io/e492a0e0-a4ba-4aca-8fc6-76b95f91fdf3/Images/Documentation/Hierarchical%20list.png?sv=2026-02-06&spr=https&st=2026-11-13T00%3A19%3A05Z&se=2026-11-13T01%3A19%3A05Z&sr=c&sp=r&sig=VgNqjnlGeII9dUk2MjejTvFk7LmQHRLU%2F1GsRR57stQ%3D) ![FLOC grid in Hierarchical View with the list sorted by the subordinate FLOCs in the next FLOC level.](https://cdn.document360.io/e492a0e0-a4ba-4aca-8fc6-76b95f91fdf3/Images/Documentation/Hierarchical%20list%202.png?sv=2026-02-06&spr=https&st=2026-11-13T00%3A19%3A05Z&se=2026-11-13T01%3A19%3A05Z&sr=c&sp=r&sig=VgNqjnlGeII9dUk2MjejTvFk7LmQHRLU%2F1GsRR57stQ%3D) ## Related Articles For more information, see: - [Queries - Overview](/v414/docs/queries-overview), for an introduction to queries. - [Listing all Queries](/v414/docs/listing-queries), to see the queries available to you. - [Custom Queries Editor](/v414/docs/custom-queries-editor), to build a query from scratch. - [Understanding Query Data and Relations](/v414/docs/understanding-query-data-and-relations), for more theoretical information on queries. - [IMS Main Screen (Grid List)](/v414/docs/basic-navigation-other-main-menu-options#filters), to learn more about the standard grid filters. Integrity Management System Functional Location ## Related - [Queries - Overview](/queries-overview.md) - [Custom Queries Editor](/custom-queries-editor.md) - [Understanding Query Data and Relations](/understanding-query-data-and-relations.md) - [Listing All Queries](/listing-queries.md)