Question type | Operator | Examples |
---|
Pick one or other (only pick one part) | IN | Get responses where for question Q1 answers A1 or A2 selected: { "items":[ { "operator":"IN", "sourceItemKey":"Q8376240", "operand":{ "selected":[ "Q8376240.A36449728", "Q8376240.A36449729" ] } } ] } |
Pick one or other (only pick one part) | NOT_IN | Get responses where for question Q1 answers A1 or A2 not selected: { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8376240", "operand":{ "selected":[ "Q8376240.A36449728", "Q8376240.A36449729" ] } } ] } |
Pick one with comment (only pick one part) | IN | Get responses where for question Q1 answers A1 or A2 selected: { "items":[ { "operator":"IN", "sourceItemKey":"Q8376240", "operand":{ "selected":[ "Q8376240.A36449728", "Q8376240.A36449729" ] } } ] } |
Pick one with comment (only pick one part) | NOT_IN | Get responses where for question Q1 answers A1 or A2 not selected: { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8376240", "operand":{ "selected":[ "Q8376240.A36449728", "Q8376240.A36449729" ] } } ] } |
Check all that apply (only check all part) | IN | Get responses where for question Q1 answers A1 or A2 selected: { "items":[ { "operator":"IN", "sourceItemKey":"Q8376240", "operand":{ "selected":[ "Q8376240.A36449728", "Q8376240.A36449729" ] } } ] } |
Check all that apply (only check all part) | NOT_IN | Get responses where for question Q1 answers A1 or A2 not selected: { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8376240", "operand":{ "selected":[ "Q8376240.A36449728", "Q8376240.A36449729" ] } } ] } |
Dropdown box | IN | Get responses where for question Q1 answers A1 or A2 selected: { "items":[ { "operator":"IN", "sourceItemKey":"Q8376240", "operand":{ "selected":[ "Q8376240.A36449728", "Q8376240.A36449729" ] } } ] } |
Dropdown box | NOT_IN | Get responses where for question Q1 answers A1 or A2 not selected: { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8376240", "operand":{ "selected":[ "Q8376240.A36449728", "Q8376240.A36449729" ] } } ] } |
List box | IN | Get responses where for question Q1 answers A1 or A2 selected: { "items":[ { "operator":"IN", "sourceItemKey":"Q8376240", "operand":{ "selected":[ "Q8376240.A36449728", "Q8376240.A36449729" ] } } ] } |
List box | NOT_IN | Get responses where for question Q1 answers A1 or A2 not selected: { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8376240", "operand":{ "selected":[ "Q8376240.A36449728", "Q8376240.A36449729" ] } } ] } |
Single Line | EQUAL | Get responses where Q1.A1 (general format) has value "qwe" { "items": [ { "sourceItemKey": "Q8370850.A36431975", "operator":"EQUAL", "operand":{ "value":"qwe" } } ] } |
Single Line | EQUAL | Get responses where Q1.A1 (numeric format) has value "5" { "items": [ { "sourceItemKey": "Q8370850.A36431975", "operator":"EQUAL", "operand":{ "value":"5" } } ] } |
Single Line | EQUAL | Get responses where Q1.A1 (date format)has value "01/02/2022" { "items": [ { "sourceItemKey": "Q8370850.A36431975", "operator":"EQUAL", "operand":{ "value":"01/02/2022" } } ] } |
Single Line | NOT_EQUAL | Get responses where Q8370850.A36431975 (general format) does not have value "qwe" { "items": [ { "sourceItemKey": "Q8370850.A36431975", "operator":"NOT_EQUAL", "operand":{ "value":"qwe" } } ] } |
Single Line | NOT_EQUAL | Get responses where Q1.A1 (numeric format) does not have value "5" { "items": [ { "sourceItemKey": "Q8370850.A36431975", "operator":"NOT_EQUAL", "operand":{ "value":"5" } } ] } |
Single Line | NOT_EQUAL | Get responses where Q1.A1 (date format) does not have value "01/02/2022" { "items": [ { "sourceItemKey": "Q8370850.A36431975", "operator":"NOT_EQUAL", "operand":{ "value":"01/02/2022" } } ] } |
Single Line | CONTAINS | Get responses where Q1.A1 (general format) contains value "qwe" { "items": [ { "sourceItemKey": "Q8370850.A36431975", "operator":"CONTAINS", "operand":{ "value":"qwe" } } ] } |
Single Line | DOES_NOT_CONTAIN | Get responses where Q1.A1 (general format) does not contain value "qwe" { "items": [ { "sourceItemKey": "Q8370850.A36431975", "operator":"DOES_NOT_CONTAIN", "operand":{ "value":"qwe" } } ] } |
Single Line | IN | Get all responses where Q2.A2 (general format) has one of the value in the list ("qwe", "abc") { "items":[ { "sourceItemKey":"Q8370850.A36431975", "operator":"IN", "operand":{ "selected":[ "qwe", "abc" ] } } ] }
|
Single Line | IN | Get all responses where Q2.A2 (numeric format) has one of the value in the list (42, 43) { "items":[ { "sourceItemKey":"Q8370850.A36431976", "operator":"IN", "operand":{ "selected":[ "42", "43" ] } } ] }
|
Single Line | IN | Get all responses where Q2.A2 (date format) has one of the value in the list (03-09-2022, 11-11-2022) { "items":[ { "sourceItemKey":"Q8370850.A36431976", "operator":"IN", "operand":{ "selected":[ "03-09-2022", "11-11-2022" ] } } ] } |
Single Line | NOT_IN | Get all responses where Q2.A2 (general format) does not have one of the value in the list ("qwe", "abc") { "items":[ { "sourceItemKey":"Q8370850.A36431975", "operator":"NOT_IN", "operand":{ "selected":[ "qwe", "abc" ] } } ] }
|
Single Line | NOT_IN | Get all responses where Q2.A2 (numeric format) does not have one of the value in the list (42, 43) { "items":[ { "sourceItemKey":"Q8370850.A36431976", "operator":"NOT_IN", "operand":{ "selected":[ "42", "43" ] } } ] }
|
Single Line | NOT_IN | Get all responses where Q2.A2 (date format) does not have one of the value in the list (03-09-2022, 11-11-2022) { "items":[ { "sourceItemKey":"Q8370850.A36431976", "operator":"NOT_IN", "operand":{ "selected":[ "03-09-2022", "11-11-2022" ] } } ] } |
Single Line | BETWEEN | Get responses where Q1.A1 (numeric format) has values between 15 and 30: { "items": [ { "sourceItemKey": "Q8370850.A36431976", "operator":"BETWEEN", "operand":{ "from":"15", "to": "30" } } ] }
|
Single Line | BETWEEN | Get responses where Q1.A1 (date format) has values between 15-02-2021 and 30-07-2022: { "items": [ { "sourceItemKey": "Q8370850.A36431976", "operator":"BETWEEN", "operand":{ "from":"15-02-2021", "to": "30-07-2022" } } ] } |
Single Line | NOT_BETWEEN | Get responses where Q1.A1 (numeric format) has values before 15 and after 30: { "items": [ { "sourceItemKey": "Q8370850.A36431976", "operator":"NOT_BETWEEN", "operand":{ "from":"15", "to": "30" } } ] }
|
Single Line | NOT_BETWEEN | Get responses where Q1.A1 (date format) has values before 15-02-2021 and after 30-07-2022: { "items": [ { "sourceItemKey": "Q8370850.A36431976", "operator":"NOT_BETWEEN", "operand":{ "from":"15-02-2021", "to": "30-07-2022" } } ] } |
Single Line | GREATER_THAN_OR_EQUAL | Get responses where Q1.A1 (numeric format) value >= "67" { "items": [ { "sourceItemKey": "Q8370850.A36431976", "operator":"GREATER_THAN_OR_EQUAL", "operand": { "value":"67" } } ] } |
Single Line | GREATER_THAN_OR_EQUAL | Get responses where Q1.A1 (date format MM/dd/yyyy) value >= "11/18/2022" { "items": [ { "sourceItemKey": "Q8370850.A36431977", "operator":"GREATER_THAN_OR_EQUAL", "operand":{ "value":"11/18/2022" } } ] } |
Single Line | LESS_THAN_OR_EQUAL | Get responses where Q1.A1 (numeric format) value <= "35" { "items": [ { "sourceItemKey": "Q8370850.A36431976", "operator":"LESS_THAN_OR_EQUAL", "operand":{ "value":"35" } } ] } |
Single Line | LESS_THAN_OR_EQUAL | Get responses where Q1.A1 (date format MM/dd/yyyy) value <= "11/18/2022" { "items": [ { "sourceItemKey": "Q8370850.A36431977", "operator":"LESS_THAN_OR_EQUAL", "operand":{ "value":"11/18/2022" } } ] } |
Single Line | GREATER_THAN | Get responses where Q1.A1 (numeric format) value > "59" { "items": [ { "sourceItemKey": "Q8370850.A36431976", "operator":"GREATER_THAN", "operand":{ "value":"59" } } ] } |
Single Line | GREATER_THAN | Get responses where Q1.A1 (date format MM/dd/yyyy) value > "11/18/2022" { "items": [ { "sourceItemKey": "Q8370850.A36431977", "operator":"GREATER_THAN", "operand":{ "value":"11/18/2022" } } ] } |
Single Line | LESS_THAN | Get responses where Q1.A1 (numeric format) value < "54" { "items": [ { "sourceItemKey": "Q8370850.A36431976", "operator":"LESS_THAN", "operand":{ "value":"54" } } ] } |
Single Line | LESS_THAN | Get responses where Q1.A1 (date format MM/dd/yyyy) value < "11/18/2022" { "items": [ { "sourceItemKey": "Q8370850.A36431977", "operator":"LESS_THAN", "operand":{ "value":"11/18/2022" } } ] } |
Numeric Allocation | EQUAL | Get responses where Q1.A1has value "123" { "items": [ { "sourceItemKey": "Q8370850.A36431975", "operator":"EQUAL", "operand":{ "value":"123" } } ] } |
Numeric Allocation | NOT_EQUAL | Get responses where Q8370850.A36431975 does not have value "345" { "items": [ { "sourceItemKey": "Q8370850.A36431975", "operator":"NOT_EQUAL", "operand":{ "value":"345" } } ] } |
Numeric Allocation | IN | Get all responses where Q2.A2 has one of the value in the list (42, 43) { "items":[ { "sourceItemKey":"Q8370850.A36431976", "operator":"IN", "operand":{ "selected":[ "42", "43" ] } } ] }
|
Numeric Allocation | NOT_IN | Get all responses where Q2.A2 does not have one of the value in the list (42, 43) { "items":[ { "sourceItemKey":"Q8370850.A36431976", "operator":"NOT_IN", "operand":{ "selected":[ "42", "43" ] } } ] }
|
Numeric Allocation | BETWEEN | Get responses where Q1.A1 has values between 15 and 30: { "items": [ { "sourceItemKey": "Q8370850.A36431976", "operator":"BETWEEN", "operand":{ "from":"15", "to": "30" } } ] }
|
Numeric Allocation | NOT_BETWEEN | Get responses where Q1.A1 has values before 15 and after 30: { "items": [ { "sourceItemKey": "Q8370850.A36431976", "operator":"NOT_BETWEEN", "operand":{ "from":"15", "to": "30" } } ] }
|
Numeric Allocation | GREATER_THAN_OR_EQUAL | Get responses where Q1.A1 value >= "67" { "items": [ { "sourceItemKey": "Q8370850.A36431977", "operator":"GREATER_THAN_OR_EQUAL", "operand": { "value":"67" } } ] } |
Numeric Allocation | LESS_THAN_OR_EQUAL | Get responses where Q1.A1 value <= "35" { "items": [ { "sourceItemKey": "Q8370850.A36431977", "operator":"LESS_THAN_OR_EQUAL", "operand": { "value":"35" } } ] } |
Numeric Allocation | GREATER_THAN | Get responses where Q1.A1 value > "59" { "items": [ { "sourceItemKey": "Q8370850.A36431977", "operator":"GREATER_THAN", "operand":{ "value":"59" } } ] } |
Numeric Allocation | LESS_THAN | Get responses where Q1.A1 value < "54" { "items": [ { "sourceItemKey": "Q8370850.A36431977", "operator":"LESS_THAN", "operand":{ "value":"54" } } ] } |
Multi Line | EQUAL | Get responses where Q1.A1 (general format) has value "qwe" { "items": [ { "sourceItemKey": "Q8370850", "operator":"EQUAL", "operand":{ "value":"qwe" } } ] } |
Multi Line | NOT_EQUAL | Get responses where Q8370850.A36431975 does not have value "qwe" { "items": [ { "sourceItemKey": "Q8370850", "operator":"NOT_EQUAL", "operand":{ "value":"qwe" } } ] } |
Multi Line | CONTAINS | Get responses where Q1 value contains "qwe" { "items": [ { "sourceItemKey": "Q8370863", "operator":"CONTAINS", "operand":{ "value":"qwe" } } ] } |
Multi Line | DOES_NOT_CONTAIN | Get responses where Q1 value does not contain "qwe" { "items": [ { "sourceItemKey": "Q8370863", "operator":"DOES_NOT_CONTAIN", "operand":{ "value":"qwe" } } ] } |
Multi Line | IN | Get all responses where Q1 has one of the value in the list (text1, text2) { "items":[ { "sourceItemKey":"Q8370850", "operator":"IN", "operand":{ "selected":[ "text1", "text2" ] } } ] } |
Multi Line | NOT_IN | Get all responses where Q1 does not have one of the value in the list (text1, text2) { "items":[ { "sourceItemKey":"Q8370850", "operator":"NOT_IN", "operand":{ "selected":[ "text1", "text2" ] } } ] }
|
File Upload | EQUAL | Get responses where Q1.A1 has value "IMG1231241.PNG" { "items": [ { "sourceItemKey": "Q8370850.A36431975", "operator":"EQUAL", "operand":{ "value":"IMG1231241.PNG" } } ] } |
File Upload | NOT_EQUAL | Get responses where Q1.A1 does not have value "IMG1231241.PNG" { "items": [ { "sourceItemKey": "Q8370850.A36431975", "operator":"NOT_EQUAL", "operand":{ "value":"IMG1231241.PNG" } } ] } |
File Upload | CONTAINS | Get responses where Q1.A1 contains value ".xls" { "items": [ { "sourceItemKey": "Q8370850.A36431975", "operator":"CONTAINS", "operand":{ "value":".xls" } } ] } |
File Upload | DOES_NOT_CONTAIN | Get responses where Q1.A1 does not contain value ".doc" { "items": [ { "sourceItemKey": "Q8370850.A36431975", "operator":"DOES_NOT_CONTAIN", "operand":{ "value":".doc" } } ] } |
File Upload | IN | Get all responses where Q2.A2 has one of the value in the list (image1.png, image2.png) { "items":[ { "sourceItemKey":"Q8370850.A36431976", "operator":"IN", "operand":{ "selected":[ "image1.png", "image2.png" ] } } ] } |
File Upload | NOT_IN | Get all responses where Q2.A2 does not have one of the value in the list (image1.png, image2.png) { "items":[ { "sourceItemKey":"Q8370850.A36431976", "operator":"NOT_IN", "operand":{ "selected":[ "image1.png", "image2.png" ] } } ] }
|
Rate Different | IN | Get responses where for answer A1 columns C1, C3, or C4 selected: { "items":[ { "operator":"IN", "sourceItemKey":"Q8376240.A36449729", "operand":{ "selected":[ "Q8376240.A36449729.C304786", "Q8376240.A36449729.C304789", "Q8376240.A36449729.C304792" ] } } ] } |
Rate Different | IN | Get responses where answer A1 is voted (any column selected): { "items":[ { "operator":"IN", "sourceItemKey":"Q8376240.A", "operand":{ "selected":[ "Q8376240.A36449729" ] } } ] } |
Rate Different | IN | Get responses where columns C1 or C3 voted (any answer selected) { "items":[ { "operator":"IN", "sourceItemKey":"Q8376240.C", "operand":{ "selected":[ "Q8376240.C304786", "Q8376240.C304789" ] } } ] } |
Rate Different | NOT_IN | Get responses where for answer A1 columns C1, C3, or C4 not selected: { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8376240.A36449729", "operand":{ "selected":[ "Q8376240.A36449729.C304786", "Q8376240.A36449729.C304789", "Q8376240.A36449729.C304792" ] } } ] } |
Rate Different | NOT_IN | Get responses where answer A1 is not voted (any column not selected): { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8376240.A", "operand":{ "selected":[ "Q8376240.A36449729" ] } } ] } |
Rate Different | NOT_IN | Get responses where columns C1 or C3 not voted (any answer not selected) { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8376240.C", "operand":{ "selected":[ "Q8376240.C304786", "Q8376240.C304789" ] } } ] } |
3D Matrix | IN | Get responses where for answer A1 columns C1, C2 have some value { "items":[ { "operator":"IN", "sourceItemKey":"Q8376248.A36449754", "operand":{ "selected":[ "Q8376248.A36449754.C827055", "Q8376248.A36449754.C827056" ] } } ] } |
3D Matrix | NOT_IN | Get responses where for answer A1 columns C1, C2 not have some value { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8376248.A36449754", "operand":{ "selected":[ "Q8376248.A36449754.C827055", "Q8376248.A36449754.C827056" ] } } ] } |
3D Matrix | IN | Get responses where answers A1, A3 have some value (in any column) { "items":[ { "operator":"IN", "sourceItemKey":"Q8376248.A", "operand":{ "selected":[ "Q8376248.A36449754", "Q8376248.A36449756" ] } } ] } |
3D Matrix | NOT_IN | Get responses where answers A1, A3 no have some value (in any column) { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8376248.A", "operand":{ "selected":[ "Q8376248.A36449754", "Q8376248.A36449756" ] } } ] } |
3D Matrix | IN | Get responses where columns C1, C2 have some value (any answer) { "items":[ { "operator":"IN", "sourceItemKey":"Q8376248.C", "operand":{ "selected":[ "Q8376248.C827055", "Q8376248.C827056" ] } } ] } |
3D Matrix | NOT_IN | Get responses where columns C1, C2 have some value (any answer) { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8376248.C", "operand":{ "selected":[ "Q8376248.C827055", "Q8376248.C827056" ] } } ] } |
3D Matrix | IN | With Dropdown type of column: Get responses where dropdown options #1 or #2 selected for A1.C3 { "items":[ { "operator":"IN", "sourceItemKey":"Q8376248.A36449754.C827057", "operand":{ "selected":[ "Q8376248.A36449754.C827057.O0", "Q8376248.A36449754.C827057.O1" ] } } ] } |
3D Matrix | NOT_IN | With Dropdown type of column: Get responses where dropdown options #1 or #2 not selected for A1.C3 { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8376248.A36449754.C827057", "operand":{ "selected":[ "Q8376248.A36449754.C827057.O0", "Q8376248.A36449754.C827057.O1" ] } } ] } |
3D Matrix | EQUAL | Get responses where value in A1.C1 is equal to "qwe" (Column is formatted as text) { "items":[ { "operator":"EQUAL", "sourceItemKey":"Q8370888.A36432057.C826503", "operand":{ "value":"qwe" } } ] } |
3D Matrix | EQUAL | Get responses where value in A1.C2 is equal to "15" (Column is formatted as numeric) { "items":[ { "operator":"EQUAL", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "value":"15" } } ] } |
3D Matrix | EQUAL | Get responses where value in A1.C3 is equal to "10-15-2022" (Column is formatted as date MM-dd-yyyy) { "items":[ { "operator":"EQUAL", "sourceItemKey":"Q8370888.A36432057.C826505", "operand":{ "value":"10-15-2022" } } ] } |
3D Matrix | NOT_EQUAL | Get responses where value in A1.C1 is not equal to "qwe" (Column is formatted as text) { "items":[ { "operator":"NOT_EQUAL", "sourceItemKey":"Q8370888.A36432057.C826503", "operand":{ "value":"qwe" } } ] } |
3D Matrix | NOT_EQUAL | Get responses where value in A1.C2 is not equal to "15" (Column is formatted as numeric) { "items":[ { "operator":"NOT_EQUAL", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "value":"15" } } ] } |
3D Matrix | NOT_EQUAL | Get responses where value in A1.C3 is not equal to "10-15-2022" (Column is formatted as date MM-dd-yyyy) { "items":[ { "operator":"NOT_EQUAL", "sourceItemKey":"Q8370888.A36432057.C826505", "operand":{ "value":"10-15-2022" } } ] } |
3D Matrix | CONTAINS | Get responses where value in A1.C1 contains substring "qwe" (Column formatted as text) { "items":[ { "operator":"CONTAINS", "sourceItemKey":"Q8370888.A36432057.C826503", "operand":{ "value":"qwe" } } ] } |
3D Matrix | DOES_NOT_CONTAIN | Get responses where value in A1.C1 does not contain substring "qwe" (Column formatted as text) { "items":[ { "operator":"DOES_NOT_CONTAIN", "sourceItemKey":"Q8370888.A36432057.C826503", "operand":{ "value":"qwe" } } ] } |
3D Matrix | IN | Get responses where value in A1.C1 is one of in list ["qwe","rty"] (Column formatted as text) { "items":[ { "operator":"IN", "sourceItemKey":"Q8370888.A36432057.C826503", "operand":{ "selected": ["qwe","rty"] } } ] } |
3D Matrix | IN | Get responses where value in A1.C2 is one of in list ["42","43"] (Column formatted as numeric) { "items":[ { "operator":"IN", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "selected": ["42","43"] } } ] } |
3D Matrix | IN | Get responses where value in A1.C3 is one of in list ["03-09-2022", "11-11-2022"] (Column formatted as date) { "items":[ { "operator":"IN", "sourceItemKey":"Q8370888.A36432057.C826505", "operand":{ "selected": ["03-09-2022", "11-11-2022"] } } ] } |
3D Matrix | NOT_IN | Get responses where value in A1.C1 does not in ["qwe","rty"] (Column formatted as text, numeric and date) { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8370888.A36432057.C826503", "operand":{ "selected": ["qwe","rty"] } } ] } |
3D Matrix | NOT_IN | Get responses where value in A1.C2 is not in list ["42","43"] (Column formatted as numeric) { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "selected": ["42","43"] } } ] } |
3D Matrix | NOT_IN | Get responses where value in A1.C3 is not in list ["03-09-2022", "11-11-2022"] (Column formatted as date) { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8370888.A36432057.C826505", "operand":{ "selected": ["03-09-2022", "11-11-2022"] } } ] } |
3D Matrix | GREATER_THAN | Get responses where value in A1.C2 is greater than 42 (C2 is formatted as number) { "items":[ { "operator":"GREATER_THAN", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "value":"42" } } ] } |
3D Matrix | GREATER_THAN | Get responses where value in A1.C2 is greater than "10/25/2021" (C2 is formatted as date MM/dd/yyyy) { "items":[ { "operator":"GREATER_THAN", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "value":"10/25/2021" } } ] } |
3D Matrix | LESS_THAN | Get responses where value in A1.C2 is less than to 42 (C2 is formatted as number) { "items":[ { "operator":"LESS_THAN", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "value":"42" } } ] } |
3D Matrix | LESS_THAN | Get responses where value in A1.C2 is less than "08/13/2022" (C2 is formatted as date MM/dd/yyyy) { "items":[ { "operator":"GREATER_THAN", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "value":"08/13/2022" } } ] } |
3D Matrix | GREATER_THAN_OR_EQUAL | Get responses where value in A1.C2 is greater than or equal to 42 (C2 is formatted as number) { "items":[ { "operator":"GREATER_THAN_OR_EQUAL", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "value":"42" } } ] } |
3D Matrix | GREATER_THAN_OR_EQUAL | Get responses where value in A1.C2 is greater than or equal to "10/25/2021" (C2 is formatted as date MM/dd/yyyy) { "items":[ { "operator":"GREATER_THAN_OR_EQUAL", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "value":"10/25/2021" } } ] } |
3D Matrix | LESS_THAN_OR_EQUAL | Get responses where value in A1.C2 is less than or equal to 42 (C2 is formatted as number) { "items":[ { "operator":"LESS_THAN_OR_EQUAL", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "value":"42" } } ] } |
3D Matrix | LESS_THAN_OR_EQUAL | Get responses where value in A1.C2 is less than or equal to "08/13/2022" (C2 is formatted as date MM/dd/yyyy) { "items":[ { "operator":"GREATER_THAN_OR_EQUAL", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "value":"08/13/2022" } } ] } |
3D Matrix | BETWEEN | Get responses where value in A1.C2 is between 100 and 200 (C2 is formatted as number) { "items":[ { "operator":"BETWEEN", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "from":"100", "to": "200" } } ] } |
3D Matrix | BETWEEN | Get responses where value in A1.C2 is between "10/25/2021" and "08/13/2022" (C2 is formatted as date MM/dd/yyyy ) { "items":[ { "operator":"BETWEEN", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "from":"10/25/2021, "to": "08/13/2022" } } ] } |
3D Matrix | NOT_BETWEEN | Get responses where value in A1.C2 is not between 100 and 200 (C2 is formatted as number) { "items":[ { "operator":"NOT_BETWEEN", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "from":"100", "to": "200" } } ] } |
3D Matrix | NOT_BETWEEN | Get responses where value in A1.C2 is not between "10/25/2021" and "08/13/2022" (C2 is formatted as date MM/dd/yyyy ) { "items":[ { "operator":"NOT_BETWEEN", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "from":"10/25/2021, "to": "08/13/2022" } } ] } |
Object Lookup | EQUAL | Get responses where value is equal to "abc" (CM/DM column formatted as text) { "items":[ { "operator":"EQUAL", "sourceItemKey":"Q8370853.A36431966", "operand":{ "value":"abc" } } ] } |
Object Lookup | EQUAL | Get responses where value is equal to 42 (CM/DM column formatted as numeric) { "items":[ { "operator":"EQUAL", "sourceItemKey":"Q8370853.A36431966", "operand":{ "value":"42" } } ] } |
Object Lookup | EQUAL | Get responses where value is equal to"10/25/2021" (CM/DM column formatted as date MM/dd/yyyy) { "items":[ { "operator":"EQUAL", "sourceItemKey":"Q8370853.A36431966", "operand":{ "value":"10/25/2021" } } ] } |
Object Lookup | NOT_EQUAL | Get responses where value is not equal to "abc" (CM/DM column formatted as text) { "items":[ { "operator":"NOT_EQUAL", "sourceItemKey":"Q8370853.A36431966", "operand":{ "value":"abc" } } ] } |
Object Lookup | NOT_EQUAL | Get responses where value is not equal to 42 (CM/DM column formatted as numeric) { "items":[ { "operator":"NOT_EQUAL", "sourceItemKey":"Q8370853.A36431966", "operand":{ "value":"42" } } ] } |
Object Lookup | NOT_EQUAL | Get responses where value is not equal to"10/25/2021" (CM/DM column formatted as date MM/dd/yyyy) { "items":[ { "operator":"NOT_EQUAL", "sourceItemKey":"Q8370853.A36431966", "operand":{ "value":"10/25/2021" } } ] } |
Object Lookup | CONTAINS | CM/DM column formatted as text { "items":[ { "operator":"CONTAINS", "sourceItemKey":"Q8370853.A36431966", "operand":{ "value":"abc" } } ] } |
Object Lookup | DOES_NOT_CONTAIN | CM/DM column formatted as text { "items":[ { "operator":"DOES_NOT_CONTAIN", "sourceItemKey":"Q8370853.A36431966", "operand":{ "value":"abc" } } ] } |
Object Lookup | IN | Get responses where value is in list ["abc", "xyz"]. CM/DM column formatted as text { "items":[ { "operator":"IN", "sourceItemKey":"Q8370853.A36431966", "operand":{ "selected": ["abc", "xyz"] } } ] } |
Object Lookup | IN | Get responses where value is in list ["42", "43"]. CM/DM column formatted as numeric { "items":[ { "operator":"IN", "sourceItemKey":"Q8370853.A36431966", "operand":{ "selected": ["42", "43"] } } ] } |
Object Lookup | IN | Get responses where value is in list ["12/20/2022", "12/25/2022"]. CM/DM column formatted as date MM/dd/yyyy { "items":[ { "operator":"IN", "sourceItemKey":"Q8370853.A36431966", "operand":{ "selected": ["12/20/2022", "12/25/2022"] } } ] } |
Object Lookup | NOT_IN | Get responses where value is not in list ["abc", "xyz"]. CM/DM column formatted as text { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8370853.A36431966", "operand":{ "selected": ["abc", "xyz"] } } ] } |
Object Lookup | NOT_IN | Get responses where value is not in list ["42", "43"]. CM/DM column formatted as numeric { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8370853.A36431966", "operand":{ "selected": ["42", "43"] } } ] } |
Object Lookup | NOT_IN | Get responses where value is not in list ["12/20/2022", "12/25/2022"]. CM/DM column formatted as date MM/dd/yyyy { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8370853.A36431966", "operand":{ "selected": ["12/20/2022", "12/25/2022"] } } ] } |
Object Lookup | GREATER_THAN | CM/DM column formatted as numeric: { "items":[ { "operator":"GREATER_THAN", "sourceItemKey":"Q8370888.A36432057", "operand":{ "value":"42" } } ] } |
Object Lookup | GREATER_THAN | CM/DM column formatted as date (MM/dd/yyyy): { "items":[ { "operator":"GREATER_THAN", "sourceItemKey":"Q8370888.A36432057", "operand":{ "value":"12/25/2022" } } ] } |
Object Lookup | LESS_THAN | CM/DM column formatted as numeric: { "items":[ { "operator":"LESS_THAN", "sourceItemKey":"Q8370888.A36432057", "operand":{ "value":"42" } } ] } |
Object Lookup | LESS_THAN | CM/DM column formatted as date (MM/dd/yyyy): { "items":[ { "operator":"LESS_THAN", "sourceItemKey":"Q8370888.A36432057", "operand":{ "value":"12/25/2022" } } ] } |
Object Lookup | GREATER_THAN_OR_EQUAL | CM/DM column formatted as numeric: { "items":[ { "operator":"GREATER_THAN_OR_EQUAL", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "value":"42" } } ] } |
Object Lookup | GREATER_THAN_OR_EQUAL | CM/DM column formatted as date (MM/dd/yyyy): { "items":[ { "operator":"GREATER_THAN_OR_EQUAL", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "value":"12/25/2022" } } ] } |
Object Lookup | LESS_THAN_OR_EQUAL | CM/DM column formatted as numeric: { "items":[ { "operator":"LESS_THAN_OR_EQUAL", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "value":"42" } } ] } |
Object Lookup | LESS_THAN_OR_EQUAL | CM/DM column formatted as date (MM/dd/yyyy): { "items":[ { "operator":"LESS_THAN_OR_EQUAL", "sourceItemKey":"Q8370888.A36432057.C826504", "operand":{ "value":"12/25/2022" } } ] } |
Object Lookup | BETWEEN | CM/DM column formatted as numeric: { "items":[ { "operator":"BETWEEN", "sourceItemKey":"Q8370853.A36431967", "operand":{ "from":"100", "to": "200" } } ] } |
Object Lookup | BETWEEN | CM/DM column formatted as date (MM/dd/yyyy): { "items":[ { "operator":"BETWEEN", "sourceItemKey":"Q8370853.A36431967", "operand":{ "from":"02/24/2022", "to": "02/27/2022" } } ] } |
Object Lookup | NOT_BETWEEN | CM/DM column formatted as numeric: { "items":[ { "operator":"NOT_BETWEEN", "sourceItemKey":"Q8370853.A36431967", "operand":{ "from":"100", "to": "200" } } ] } |
Object Lookup | NOT_BETWEEN | CM/DM column formatted as numeric and date (MM/dd/yyyy): { "items":[ { "operator":"NOT_BETWEEN", "sourceItemKey":"Q8370853.A36431967", "operand":{ "from":"02/24/2022", "to": "02/27/2022" } } ] } |
Multiple Object Lookup | IN | CM/DM column formatted as text { "items":[ { "operator":"IN", "sourceItemKey":"Q8370858.A36431998", "operand":{ "selected": ["user1", "user2"] } } ] } |
Multiple Object Lookup | NOT_IN | CM/DM column formatted as text { "items":[ { "operator":"NOT_IN", "sourceItemKey":"Q8370858.A36431998", "operand":{ "selected": ["user1", "user2"] } } ] } |