Versions Compared

Old Version 7

changes.mady.by.user Maxson Chen

Saved on

compared with

New Version 8

changes.mady.by.user Maxson Chen

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

Operator

  • Equal

    Info
    titleEqual

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

    The following is the list used:
    Image Added

    Example returns all rows containing "flying donut" in "name" column.

    Image Added

    Result:

    Image Added

  • Not Equal

    Info
    titleNot Equal

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

    The following is the list used:
    Image Added

    Example exclude all rows containing "flying donut" in "name" column.

    Result:

    Image Added

  • Greater Than

    Info
    titleGreater Than

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

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

    Image Added

    Result:

    Image Added

  • Greater Than Or Equal

    Info
    titleGreater Than Or Equal

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

    Result:

    Image Added

  • Less Than

    Info
    titleLess Than

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


    Result:

    Image Added

  • Less Than Or Equal

    Info
    titleLess Than Or Equal

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



    Result:

    Image Added

  • Like

    Info
    titleLike

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

    Warning

    "%" will be used as a wildcard to represent any sequence of characters, and the "_" represents

    a single character.

    The following is the list used:
    Image Added

    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 "name" column contains "vcd".

    Image Added

    Result:

    Image Added

    Wildcard at beginning

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

    Following example return all rows where "name" column ends with "n". 

    Image Added

    Result:

    Image Added

    Wildcard at ending 

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

    Example return all rows where "name" column starts with "Jo".

    Image Added

    Result:
    Image Added

    Single character wildcard

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

    Image Added

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

    Image Added

  • Not Like

  • In
  • Not In
  • Is True
  • Is False
  • Is Null

  • Info
    titleNot Like

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

    Warning

    "%" will be used as a wildcard to represent any sequence of characters, and the "_" represents

    a single character.

    The following is the list used:
    Image Added

    Wildcard at both ends

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

    Example exclude all rows with its "name" column containing "vcd".

    Image Added

    Result:

    Image Added

    Wildcard at beginning

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

    Example exclude all rows where "name" column ends with "n". 

    Image Added

    Result:

    Image Added

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

    Image Added

    Result:
    Image Added

    Single character wildcard

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

    Image Added

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

    Image Added

  • In

    Info
    titleIn

    Is Not Null

    Info
    titleIn & 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:

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

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




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


    "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

  • Not In

    Info
    titleNot In

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

    In this example, type of "Powdered" and "Glazed" are used.

    Warning
    titleAttention

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

    Resulting 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. title)
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#'

...