Versions Compared

Old Version 12

changes.mady.by.user Mohamed Elorbany

Saved on

compared with

New Version 13

changes.mady.by.user Mohamed Elorbany

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

NameDescription
Filter Conditions

Filter Conditions

NameDescription
Join Type
  • And
  • Or
Field

Field ID. (e.g. titleusername)

Image RemovedImage Added

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
ValueFilter value
Extra Conditions

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

Info
titleSyntax Query
Start your filter name with e.customProperties. followed by the field id (i.e. titleusername)
Image RemovedImage Added
Info
titleHQL is accepted

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

Code Block
titleSample
e.customProperties.title = 'Trip'

A hash variable is accepted here.

Code Block
titleSample
e.customProperties.submitted_by = '#currentUser.id#'

Userview Key can be used as part of the condition.

Code Block
languagesql
titleSample
e.customProperties.category_id = '#userviewKey#'

...