Versions Compared

Old Version 40

changes.mady.by.user Technische Redaktion

Saved on

compared with

New Version Current

changes.mady.by.user Technische Redaktion

Saved on

Key

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

...

Operator nameDescriptionExample
eqReturns objects with values that are equal to v1.

"f": "appPersonalfile:name",   
"o": "eq",
"v1": "idpic"

in

Returns objects that match at least one of the provided values (value has to be an array), i.e., list of terms combined by OR.

An array of values to compare must be specified.

"f": "appPersonalfile:employee", 
"o": "in",
"v1":["Applicant",                       
      "Manager"
           ]

gtReturns objects with values greater than v1.

"f": "system:creationDate",    
"o": "gt",
"v1": "2016-01-01T00:00:00.000Z"

gteReturns objects with values greater than or equal to v1. similar to gt
ltReturns objects with values less than v1. similar to gt
lteReturns objects with values less than or equal to v1. similar to gt
gtltReturns objects with values within the specified interval: greater than v1 and less than v2.

"f": "system:creationDate",          
"o": "gtelte",
"v1": "2016-01-01T00:00:00.000Z",
"v2": "2016-01-10T00:00:00.000Z

gtelteReturns objects with values within the specified interval: greater than or equal to v1 and less than or equal to v2.similar to gtlt
gtlteReturns objects with values within the specified interval: greater than v1 and less than or equal to v2.similar to gtlt
gteltReturns objects with values within the specified interval: greater than or equal to v1 and less than v2.similar to gtlt
like

Used to search for a specific pattern with wildcards.

The ? character represents a single character, the * character represents multiple characters.

A maximum number of 10 * and ? characters are allowed in one like expression.

"f": "system:tenant",
"v1": "??Tenant",
"o": "like"
containsAs of 2023 Autumn. Performs full-text search for the specified field.


Code Block
{
  "f": "appClient:clientdescription",
  "v1": "test",
  "o": "contains"
}


Filters Structure

Code Block
languageyml
firstline1
"filters": 
 [  {
    "lo": "<logical operator>",
    "filters": 
	[
       {
       "f": "<field1>",
       "v1": <comparing value1>,
       "o": "<comparison operator1>",
       "useNot": <"true" or "false">
       },
       {
       "f": "<field2>",
       "v2": <comparing value2>,
       "o": "<comparison operator2>"
       }
       ...
    ]
    }
 ]

...