Filter Queries for Reports and Dashboard

Bizintel360 Visualization allows you to filter data across reports and dashboards effectively. This document outlines possible search filters available for different data types, enabling you to filter based on conditions like "is null," "is not null," "equals," "not equals," and ranges. These examples demonstrate query syntax for filtering string, date, number, and float fields.

Note: You can apply filters in the Global Search Engine, at the widget level, and within discovery reports.

Supported Filter Conditions and Syntax

Field Type	Condition	Query Syntax Example
String	Is Not Null	Field:[* TO *]
	Is Null	NOT Field:[* TO *]
	Equals	Field:"Value"
	Not Equals	NOT Field:"Value"
	Contains	Field:*substring*
	Does Not Contain	NOT Field:*substring*
	One Of	(Field:"Value1" OR Field:"Value2")
Date	Is Not Null	DateField:[* TO *]
	Is Null	NOT DateField:[* TO *]
	Equals	DateField:"yyyy-MM-dd"
	Not Equals	NOT DateField:"yyyy-MM-dd"
	Before	DateField:{* TO yyyy-MM-dd}
	After	DateField:{yyyy-MM-dd TO *}
	Between	DateField:[yyyy-MM-dd TO yyyy-MM-dd]
Number	Is Not Null	NumberField:[* TO *]
	Is Null	NOT NumberField:[* TO *]
	Equals	NumberField:Value
	Not Equals	NOT NumberField:Value
	Greater Than	NumberField:{Value TO *}
	Less Than	NumberField:{* TO Value}
	Between	NumberField:[MinValue TO MaxValue]
Float	Is Not Null	FloatField:[* TO *]
	Is Null	NOT FloatField:[* TO *]
	Equals	FloatField:Value
	Not Equals	NOT FloatField:Value
	Greater Than	FloatField:{Value TO *}
	Less Than	FloatField:{* TO Value}
	Between	FloatField:[MinValue TO MaxValue]

Example Queries in Goldfinch Visualization

Here are sample queries that demonstrate the filter syntax in various scenarios. Note that if there is a space within a column name, add a backslash \ between the words. If there is no space, a backslash is unnecessary.

1. Customer Code Is Not Null
   (Customer\ Code:[* TO *])
2. Order Status Not Equal to "Order Complete"
   (NOT Order\ Status:"Order complete")
3. Purchasing Amount Not Equal to 0
   (NOT Purchasing\ Amount:0)
4. Combining Conditions Using Brackets
   (Customer\ Code:[* TO *]) AND (NOT Order\ Status:"Order complete") AND (NOT Purchasing\ Amount:0)
5. Example with Logical Operators
   (NOT Current\ Employee:[* TO *]) OR (NOT Employee\ Type:[* TO *]) OR (NOT Function:[* TO *]) OR (NOT Reporting\ Manager:[* TO *])
6. Multiple Filters on the Same Field
   (Project:"Guided Navigation") AND (NOT percentComplete:"100") AND (Priority:"P0" OR Priority:"P1")

Best Practices for Filtering

• Use Parentheses ( ... ): Group different conditions to enhance readability and ensure the proper application of logical operators (AND, OR, NOT).

• Logical Operators: Apply these operators carefully to maintain the correctness of your queries.

This guide should serve as a reference for using filters across Goldfinch Visualization. Use these examples to build queries tailored to your specific reporting needs.