Page History

Return all rows where specified column is equal to the specified value.

The following is the list used:

Example returns all rows containing "Test Item 3" in "name" column.

Result:

Exclude all rows where specified column is equal to the specified value.

The following is the list used:

Example exclude all rows containing "Test Item 3" in "name" column.

Result:

Return all rows where value of specified column is greater than specified value 

The following is the list used:
Image RemovedImage Added

Example return rows where "price" column value is greater than 400.

Result:

Image RemovedImage Added

Return all rows where value of specified column is greater than or equal to specified value

The following is the list used:
Image RemovedImage Added
Example return rows where "price" column value is greater than or equal 400.

Result:

Image RemovedImage Added

Return all rows where value of specified column is lesser than specified value 

The following is the list used:
Image RemovedImage Added

Example return rows where "price" column value is lesser than 400.

Result:

Image RemovedImage Added

Return all rows where value of specified column is lesser than or equal to specified value 

The following is the list used:
Image RemovedImage Added

Example return rows where "price" column value is lesser than or equal 400.

Result:

Image RemovedImage Added

"Like" operator is used for pattern matching and have numerous use cases:

The following is the list used:

Wildcard at both ends

Return all rows where selected field column value contains the specified "words" anywhere within.

Following example return all rows where string of "description" column contains "50".

Result:

Wildcard at beginning

Return all rows where selected field column value ends with the specified characters.

Following example return all rows where "description" column ends with "0". 

Result:

Wildcard at ending 

Return all rows where selected field column value starts with the specified characters.

Example return all rows where "description" column starts with "D".

Result:

Single character wildcard

Returns all rows where selected field column value matches the specified rules

Example return all rows where "description" column contains "T__0" (3rd & 4th character can be anything).

Result:

"Not Like" operator is used for excluding patterns or any characters from rows.

The following is the list used:

Wildcard at both ends

Exclude all rows where selected field column value matches the specified value.

Example exclude all rows with its "description" column containing "50".

Border

Result:

Wildcard at beginning

Exclude all rows where selected field column value ends with the specified characters.

Example exclude all rows where "description" column ends with "0". 

Result:

Wildcard at ending 

Exclude all rows where selected field column value starts with the specified characters.

Example exclude all rows where "name" column starts with "D".

Result:

Single character wildcard

Exclude all rows where selected field column value matches the specified rules

Example exclude all rows where "description" column contains "T__0" (3rd & 4th character can be anything).

Result:

"In" can be used for category filter where a specified column value matches any value of the provided list of

values. The following is the list used:

"In" Operation can be used to filter result based on a list of specified values. For example, the following filters

for "Item Name" that belongs to "Test Item 1" and "Test Item 3". 

This will result in rows with type that matches the provided list of values. Resulting in the following:

"Not In" is the inverse of "In", it filters out values that does not match the provided list

of values.

The following is the list used:

In this example, item_name "Test Item 3" & "Test Item 1" are used.

Resulting in:

The following is the list used:

Example will return all row with specified column that is true

Result:

The following is the list used:

Example will return all row with specified column that is false

Result:

Return row of specified column value that is NULL

The following is the list used:

Example return rows with column "Description" value that is NULL

There are no NULL value in column "Description" resulting in:

Return row of specified column value that is not NULL

The following is the list used:

Example return rows with column "Description" value that is not NULL

Result: