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:

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

Result:

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

The following is the list used:

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

Result:

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

The following is the list used:

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

Result:

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

The following is the list used:

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

Result:

"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".

Image Modified

Result:

Image Modified

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". 

Image Modified

Result:

Image Modified

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".

Image Modified

Result:
Image Modified

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).

Image Modified

Result:

Image Modified

"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". 

Image Added

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

Image RemovedImage Added

"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:

Image RemovedImage Added

In this example, type of "Powdered" and "Glazeditem_name "Test Item 3" & "Test Item 1" are used.

Image RemovedImage Added

Resulting in:
Image RemovedImage Added

The following is the list used:

Image RemovedImage Added

Example will return all row with specified column that is true

Image RemovedImage Added

Result:

Image RemovedImage Added

The following is the list used:

Image RemovedImage Added

Example will return all row with specified column that is false

Image RemovedImage Added

Result:

Image RemovedImage Added

Return row of specified column value that is NULL

The following is the list used:
Image RemovedImage Added

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

Image Removed

Result:

Image Added

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

Image AddedImage Removed

Return row of specified column value that is not NULL

The following is the list used:
Image RemovedImage Added

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

Image RemovedImage Added

Result:
Image RemovedImage Added