Page History

...

Name

Description

Filter Conditions

Name

Description

Join Type

And
Or

Field

Field ID. (e.g. title)

Operator

Equal
Not Equal
Greater Than
Greater Than Or Equal
Less Than
Less Than Or Equal
Like
Not Like
In
Not In
Is True
Is False
Is Null

Is Not Null

Info

title	In & Not In examples

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

Image Added

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

for "Type" that belongs to "Powdered" and "Glazed".

Warning

title	Attention

A ";" must be added in between items in specified value for it to work. (Item1;Item2;Item3)

Image Added

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

Image Added

"Not In" on the other hand works the opposite to "In", it filters out values that does not match the provided

list of values . In this example, type of "Powdered" and "Glazed"

Image Added

Resulting in:
Image Added

Value

Filter value

Extra Conditions

Additional condition(s) for filtering the data set. HQL is expected here.

Info

title	Syntax Query

Start your filter name with e.customProperties. followed by the field id (i.e. title)

Info

title	HQL is accepted

You may even use an operator such as "LIKE" to narrow down your data set.

Code Block

title	Sample

e.customProperties.title = 'Trip'

A hash variable is accepted here.

Code Block

title	Sample

e.customProperties.submitted_by = '#currentUser.id#'

Userview Key can be used as part of the condition.

Code Block

language	sql
title	Sample

e.customProperties.category_id = '#userviewKey#'

...

Space shortcuts

Page tree

Versions Compared

Old Version 6

New Version 7

Key