Edit documentation Edit document
Core API
Lib
Auth Core API
App Processor
Field Processor
Item Processor
Document Manager
File Manager
Pipe
Interpretation
Filter
Recurring Date
Value
Search
Range
Date
Distance
Phone
Equals
equal_or equal_and not_equal_or not_equal_and Examples
Contains
Bigger/Lower
Filter

Equal

This is the group of filters that determines fields with value equals to searching value:

They search a match even among multiple fields. They can be applied almost for all types of fields.

{
    "data_type": "number",
    "field_id": 625329,
    "search_type": "equal_or",
    "selected_search_option_variable": "Value",
    "valuesArray": []
}

Following tables are the examples of selection results for certain fields and arrays of values. They show whether the field value be selected and displayed in the table.

equal_or

This type allow to show all field that has at least one of the values from the searching field.

F \ S [1,2] [1,3] [3,4] [1] [3] [ ] [1,2,3]
[1,2] + + - + - + +
[1,3] + + + + + + +
[3,4] - + + - + + +
[1] + + - + - + +
[3] - + + - + + +
[ ] - - - - - + -
[6] - - - - - + -
[1,2,3] + + + + + + +

S - search values

F - column of field values

"+" - matched by filter

"-" - not matched by filter

You can see all tables appropriate each searching value in the end of the chapter.

equal_and

This type of search allows you to display a field whose values are equal to all the values you are looking for.

F \ S [1,2] [1,3] [3,4] [1] [3] [ ] [1,2,3]
[1,2] + - - + - + -
[1,3] - + - + + + -
[3,4] - - + - + + -
[1] - - - + - + -
[3] - - - - + + -
[ ] - - - - - + -
[6] - - - - - + -
[1,2,3] + + - + + + +

S - search values

F - column of field values

"+" - matched by filter

"-" - not matched by filter

You can see all tables appropriate each searching value in the end of the chapter.

not_equal_or

This type allows to gather fields which do not have at least one of search values.

F \ S [1,2] [1,3] [3,4] [1] [3] [ ] [1,2,3]
[1,2] - + - + + + -
[1,3] + - + + + + -
[3,4] + + - + + + +
[1] - - + - + + -
[3] + - - + - + -
[ ] + + + + + + +
[6] + + + + + + +
[1,2,3] + + + + + + -

S - search values

F - column of field values

"+" - matched by filter

"-" - not matched by filter

You can see all tables appropriate each searching value in the end of the chapter.

not_equal_and

This search type allow you to see all field without entered values.

F \ S [1,2] [1,3] [3,4] [1] [3] [ ] [1,2,3]
[1,2] - - + - + + -
[1,3] - - - - - + -
[3,4] + - - + - + -
[1] - - + - + + -
[3] + - - + - + -
[ ] + + + + + + +
[6] + + + + + + +
[1,2,3] - - - - - + -

S - search values

F - column of field values

"+" - matched by filter

"-" - not matched by filter

You can see all tables appropriate each searching value in the end of the chapter.

Examples

It does not matter, what type the values will have. For example we will take a table of numbers:

[{
    "item_id": 2979065,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2]
    }]
    },
    {
    "item_id": 2979066,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,3]
    }]
    },
    {
    "item_id": 2979067,
    "fields": [{
        "field_id": 629160,
        "field_value": [3,4]
    }]
    },
    {
    "item_id": 2979068,
    "fields": [{
        "field_id": 629160,
        "field_value": [1]
    }]
    },
    {
    "item_id": 2979069,
    "fields": [{
        "field_id": 629160,
        "field_value": [3]
    }]
    },
    {
    "item_id": 2979070,
    "fields": [{
        "field_id": 629160,
        "field_value": []
    }]
    },
    {
    "item_id": 2979071,
    "fields": [{
        "field_id": 629160,
        "field_value": [6]
    }]
    },
    {
    "item_id": 2979072,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2,3]
    }]
}]

Examples Equal(or)

  • Search value: [1,2]
[{
    "item_id": 2979065,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2]
    }]
    },
    {
    "item_id": 2979066,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,3]
    }]
    },
    {
    "item_id": 2979068,
    "fields": [{
        "field_id": 629160,
        "field_value": [1]
    }]
    },
    {
    "item_id": 2979072,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2,3]
    }]
}]
  • Search value: [1,3]
[{
    "item_id": 2979065,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2]
    }]
    },
    {
    "item_id": 2979066,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,3]
    }]
    },
    {
    "item_id": 2979067,
    "fields": [{
        "field_id": 629160,
        "field_value": [3,4]
    }]
    },
    {
    "item_id": 2979068,
    "fields": [{
        "field_id": 629160,
        "field_value": [1]
    }]
    },
    {
    "item_id": 2979069,
    "fields": [{
        "field_id": 629160,
        "field_value": [3]
    }]
    },
    {
    "item_id": 2979072,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2,3]
    }]
}]
  • Search value: [3,4]
[{
    
    "item_id": 2979066,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,3]
    }]
    },
    {
    "item_id": 2979067,
    "fields": [{
        "field_id": 629160,
        "field_value": [3,4]
    }]
    },
    {
    "item_id": 2979069,
    "fields": [{
        "field_id": 629160,
        "field_value": [3]
    }]
    },
    {
    "item_id": 2979072,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2,3]
    }]
}]
  • Search value: [1]
[{
    "item_id": 2979065,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2]
    }]
    },
    {
    "item_id": 2979066,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,3]
    }]
    },
    {
    "item_id": 2979068,
    "fields": [{
        "field_id": 629160,
        "field_value": [1]
    }]
    },
    {
    "item_id": 2979072,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2,3]
    }]
}]
  • Search value: [3]
[{
    "item_id": 2979066,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,3]
    }]
    },
    {
    "item_id": 2979067,
    "fields": [{
        "field_id": 629160,
        "field_value": [3,4]
    }]
    },
    {
    "item_id": 2979069,
    "fields": [{
        "field_id": 629160,
        "field_value": [3]
    }]
    },
    {
    "item_id": 2979072,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2,3]
    }]
}]
  • Search value: [ ]
[[{
    "item_id": 2979065,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2]
    }]
    },
    {
    "item_id": 2979066,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,3]
    }]
    },
    {
    "item_id": 2979067,
    "fields": [{
        "field_id": 629160,
        "field_value": [3,4]
    }]
    },
    {
    "item_id": 2979068,
    "fields": [{
        "field_id": 629160,
        "field_value": [1]
    }]
    },
    {
    "item_id": 2979069,
    "fields": [{
        "field_id": 629160,
        "field_value": [3]
    }]
    },
    {
    "item_id": 2979070,
    "fields": [{
        "field_id": 629160,
        "field_value": []
    }]
    },
    {
    "item_id": 2979071,
    "fields": [{
        "field_id": 629160,
        "field_value": [6]
    }]
    },
    {
    "item_id": 2979072,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2,3]
    }]
}]
  • Search value: [1,2,3]
[[{
    "item_id": 2979065,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2]
    }]
    },
    {
    "item_id": 2979066,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,3]
    }]
    },
    {
    "item_id": 2979067,
    "fields": [{
        "field_id": 629160,
        "field_value": [3,4]
    }]
    },
    {
    "item_id": 2979068,
    "fields": [{
        "field_id": 629160,
        "field_value": [1]
    }]
    },
    {
    "item_id": 2979069,
    "fields": [{
        "field_id": 629160,
        "field_value": [3]
    }]
    },
    {
    "item_id": 2979072,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2,3]
    }]
}]

Examples Equal(and)

  • Search value: [1,2]
[{
    "item_id": 2979065,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2]
    }]
    },
    {
    "item_id": 2979072,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2,3]
    }]
}]
  • Search value: [1,3]
[{
    "item_id": 2979066,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,3]
    }]
    },
    {
    "item_id": 2979072,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2,3]
    }]
}]
  • Search value: [3,4]
[{
    
    "item_id": 2979067,
    "fields": [{
        "field_id": 629160,
        "field_value": [3,4]
    }]
}]
  • Search value: [1]
[{
    "item_id": 2979065,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2]
    }]
    },
    {
    "item_id": 2979066,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,3]
    }]
    },
    {
    "item_id": 2979068,
    "fields": [{
        "field_id": 629160,
        "field_value": [1]
    }]
    },
    {
    "item_id": 2979072,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2,3]
    }]
}]
  • Search value: [3]
[{
    "item_id": 2979066,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,3]
    }]
    },
    {
    "item_id": 2979067,
    "fields": [{
        "field_id": 629160,
        "field_value": [3,4]
    }]
    },
    {
    "item_id": 2979069,
    "fields": [{
        "field_id": 629160,
        "field_value": [3]
    }]
    },
    {
    "item_id": 2979072,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2,3]
    }]
}]
  • Search value: [ ]
[{
    "item_id": 2979065,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2]
    }]
    },
    {
    "item_id": 2979066,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,3]
    }]
    },
    {
    "item_id": 2979067,
    "fields": [{
        "field_id": 629160,
        "field_value": [3,4]
    }]
    },
    {
    "item_id": 2979068,
    "fields": [{
        "field_id": 629160,
        "field_value": [1]
    }]
    },
    {
    "item_id": 2979069,
    "fields": [{
        "field_id": 629160,
        "field_value": [3]
    }]
    },
    {
    "item_id": 2979070,
    "fields": [{
        "field_id": 629160,
        "field_value": []
    }]
    },
    {
    "item_id": 2979071,
    "fields": [{
        "field_id": 629160,
        "field_value": [6]
    }]
    },
    {
    "item_id": 2979072,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2,3]
    }]
}]
  • Search value: [1,2,3]
[{
    "item_id": 2979072,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2,3]
    }]
}]

Examples Not Equal(or)

  • Search value: [1,2]
[{
    "item_id": 2979066,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,3]
    }]
    },
    {
    "item_id": 2979067,
    "fields": [{
        "field_id": 629160,
        "field_value": [3,4]
    }]
    },
    {
    "item_id": 2979069,
    "fields": [{
        "field_id": 629160,
        "field_value": [3]
    }]
    },
    {
    "item_id": 2979070,
    "fields": [{
        "field_id": 629160,
        "field_value": []
    }]
    },
    {
    "item_id": 2979071,
    "fields": [{
        "field_id": 629160,
        "field_value": [6]
    }]
    },
    {
    "item_id": 2979072,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2,3]
    }]
}]
  • Search value: [1,3]
[{
    "item_id": 2979065,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2]
    }]
    },
    {
    "item_id": 2979067,
    "fields": [{
        "field_id": 629160,
        "field_value": [3,4]
    }]
    },
    {
    "item_id": 2979070,
    "fields": [{
        "field_id": 629160,
        "field_value": []
    }]
    },
    {
    "item_id": 2979071,
    "fields": [{
        "field_id": 629160,
        "field_value": [6]
    }]
    },
    {
    "item_id": 2979072,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2,3]
    }]
}]
  • Search value: [3,4]
[{
    "item_id": 2979065,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2]
    }]
    },
    {
    "item_id": 2979066,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,3]
    }]
    },
    {
    "item_id": 2979068,
    "fields": [{
        "field_id": 629160,
        "field_value": [1]
    }]
    },
    {
    "item_id": 2979070,
    "fields": [{
        "field_id": 629160,
        "field_value": []
    }]
    },
    {
    "item_id": 2979071,
    "fields": [{
        "field_id": 629160,
        "field_value": [6]
    }]
    },
    {
    "item_id": 2979072,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2,3]
    }]
}]
  • Search value: [1]
[{
    "item_id": 2979065,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2]
    }]
    },
    {
    "item_id": 2979066,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,3]
    }]
    },
    {
    "item_id": 2979067,
    "fields": [{
        "field_id": 629160,
        "field_value": [3,4]
    }]
    },
    {
    "item_id": 2979069,
    "fields": [{
        "field_id": 629160,
        "field_value": [3]
    }]
    },
    {
    "item_id": 2979070,
    "fields": [{
        "field_id": 629160,
        "field_value": []
    }]
    },
    {
    "item_id": 2979071,
    "fields": [{
        "field_id": 629160,
        "field_value": [6]
    }]
    },
    {
    "item_id": 2979072,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2,3]
    }]
}]
  • Search value: [3]
[{
    "item_id": 2979065,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2]
    }]
    },
    {
    "item_id": 2979066,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,3]
    }]
    },
    {
    "item_id": 2979067,
    "fields": [{
        "field_id": 629160,
        "field_value": [3,4]
    }]
    },
    {
    "item_id": 2979068,
    "fields": [{
        "field_id": 629160,
        "field_value": [1]
    }]
    },
    {
    "item_id": 2979070,
    "fields": [{
        "field_id": 629160,
        "field_value": []
    }]
    },
    {
    "item_id": 2979071,
    "fields": [{
        "field_id": 629160,
        "field_value": [6]
    }]
    },
    {
    "item_id": 2979072,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2,3]
    }]
}]
  • Search value: [ ]
[{
    "item_id": 2979065,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2]
    }]
    },
    {
    "item_id": 2979066,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,3]
    }]
    },
    {
    "item_id": 2979067,
    "fields": [{
        "field_id": 629160,
        "field_value": [3,4]
    }]
    },
    {
    "item_id": 2979068,
    "fields": [{
        "field_id": 629160,
        "field_value": [1]
    }]
    },
    {
    "item_id": 2979069,
    "fields": [{
        "field_id": 629160,
        "field_value": [3]
    }]
    },
    {
    "item_id": 2979070,
    "fields": [{
        "field_id": 629160,
        "field_value": []
    }]
    },
    {
    "item_id": 2979071,
    "fields": [{
        "field_id": 629160,
        "field_value": [6]
    }]
    },
    {
    "item_id": 2979072,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2,3]
    }]
}]
  • Search value: [1,2,3]
    "item_id": 2979067,
    "fields": [{
        "field_id": 629160,
        "field_value": [3,4]
    }]
    },
    {
    "item_id": 2979070,
    "fields": [{
        "field_id": 629160,
        "field_value": []
    }]
    },
    {
    "item_id": 2979071,
    "fields": [{
        "field_id": 629160,
        "field_value": [6]
    }]
}]

Examples Not Equal(and)

  • Search value: [1,2]
[{
    "item_id": 2979067,
    "fields": [{
        "field_id": 629160,
        "field_value": [3,4]
    }]
    },
    {
    "item_id": 2979069,
    "fields": [{
        "field_id": 629160,
        "field_value": [3]
    }]
    },
    {
    "item_id": 2979070,
    "fields": [{
        "field_id": 629160,
        "field_value": []
    }]
    },
    {
    "item_id": 2979071,
    "fields": [{
        "field_id": 629160,
        "field_value": [6]
    }]
}]
  • Search value: [1,3]
[{
    "item_id": 2979070,
    "fields": [{
        "field_id": 629160,
        "field_value": []
    }]
    },
    {
    "item_id": 2979071,
    "fields": [{
        "field_id": 629160,
        "field_value": [6]
    }]
}]
  • Search value: [3,4]
[{
    "item_id": 2979065,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2]
    }]
    },
    {
    "item_id": 2979068,
    "fields": [{
        "field_id": 629160,
        "field_value": [1]
    }]
    },
    {
    "item_id": 2979070,
    "fields": [{
        "field_id": 629160,
        "field_value": []
    }]
    },
    {
    "item_id": 2979071,
    "fields": [{
        "field_id": 629160,
        "field_value": [6]
    }]
}]
  • Search value: [1]
[{
    "item_id": 2979067,
    "fields": [{
        "field_id": 629160,
        "field_value": [3,4]
    }]
    },
    {
    "item_id": 2979069,
    "fields": [{
        "field_id": 629160,
        "field_value": [3]
    }]
    },
    {
    "item_id": 2979070,
    "fields": [{
        "field_id": 629160,
        "field_value": []
    }]
    },
    {
    "item_id": 2979071,
    "fields": [{
        "field_id": 629160,
        "field_value": [6]
    }]
}]
  • Search value: [3]
[{
    "item_id": 2979065,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2]
    }]
    },
    {
    "item_id": 2979068,
    "fields": [{
        "field_id": 629160,
        "field_value": [1]
    }]
    },
    {
    "item_id": 2979070,
    "fields": [{
        "field_id": 629160,
        "field_value": []
    }]
    },
    {
    "item_id": 2979071,
    "fields": [{
        "field_id": 629160,
        "field_value": [6]
    }]
}]
  • Search value: [ ]
[{
    "item_id": 2979065,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2]
    }]
    },
    {
    "item_id": 2979066,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,3]
    }]
    },
    {
    "item_id": 2979067,
    "fields": [{
        "field_id": 629160,
        "field_value": [3,4]
    }]
    },
    {
    "item_id": 2979068,
    "fields": [{
        "field_id": 629160,
        "field_value": [1]
    }]
    },
    {
    "item_id": 2979069,
    "fields": [{
        "field_id": 629160,
        "field_value": [3]
    }]
    },
    {
    "item_id": 2979070,
    "fields": [{
        "field_id": 629160,
        "field_value": []
    }]
    },
    {
    "item_id": 2979071,
    "fields": [{
        "field_id": 629160,
        "field_value": [6]
    }]
    },
    {
    "item_id": 2979072,
    "fields": [{
        "field_id": 629160,
        "field_value": [1,2,3]
    }]
}]
  • Search value: [1,2,3]
[{
    "item_id": 2979070,
    "fields": [{
        "field_id": 629160,
        "field_value": []
    }]
    },
    {
    "item_id": 2979071,
    "fields": [{
        "field_id": 629160,
        "field_value": [6]
    }]
}]