Core API

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]
    }]
}]