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 relational operator (IS, IS NOT, etc) for the filter you would like to apply.

4.  Choose from the available Values listed.

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

Relational Operators

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

Text

Filter by IS and IS NOT.

Example: Country is Spain. City is not Madrid.


Integer & Decimal & Currency

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.


Date & Time

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.


True/False (Boolean)

Filter by IS and IS NOT.

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


Geo Shape (Geocoordinate Boundaries)

Filter crashes by lat/long boundary coordinates.

Example: Only show Crashes within defined City limits.

Currently only available for Transportation applications.

Did this answer your question?