Advanced Search Bar

Advanced Search Bar allows you to filter your data in complex ways, depending on your Data Type. These filters can include IS, IS NOT, IS LESS THAN, IS LESS THAN OR EQUAL TO, IS GREATER THAN, IS GREATER THAN OR EQUAL TO, IS BETWEEN, and IS NOT BETWEEN, giving users more flexibility to drill down into data in a meaningful way.

Using Advanced Search

1. Click on the search bar. A list of all searchable columns will immediately appear. If you are looking for a specific value, start typing it to narrow down the column list. 

2. Click on the column name you wish to search by.

3. Choose the appropriate operator (IS, IS NOT, etc) for the filter you would like to apply (Note - you will not always be prompted to select the operator, when selecting text fields, the operator will automatically be set to “=”).

4. Choose from the available values in the filter bar listed. If fewer than 24 values are listed in the dropdown, you will be able to select multiple values for your filter.

5. If a multi-select filter is available, you will need to click outside the filter box to apply the filters. If no multi-select is available, the filter will be selected and automatically applied.
​

6. To remove a single filter, click on the X button next to it. To remove all filters, click on the X button on the far right side of the filter bar. 

Each Data Type, along with the associated search capabilities and examples of how to use them are provided below:

Filter by IS and IS NOT.

Example: Country is Spain. City is not Madrid.

Filter by IS, IS NOT, IS LESS THAN, IS LESS THAN OR EQUAL TO, IS GREATER THAN, IS GREATER THAN OR EQUAL TO, IS BETWEEN, IS NOT BETWEEN.

Example: Order Number is between 1005 and 1010.

Filter by IS LESS THAN OR EQUAL TO, IS GREATER THAN OR EQUAL TO, IS BETWEEN, IS NOT BETWEEN.

Day & Time fields also allow you to search by Hour of Day, Day or Week, and Month of Year.

Example: Order Date between 11/18/2018 - 11/30/2018.

Example: Order Dates on Wednesdays.

Filter by IS and IS NOT.

Example: “Is Shipped Order” column is 1 (True).

Filter crashes by lat/long boundary coordinates.

Example: Only show Crashes within defined City limits.

Currently only available for Transportation applications.