Forum Discussion

Qrew Trainee

3 years ago

Using AND & OR in Quickbase API Pipeline Channel

I am trying to build a table report in an email and I need to use both AND & OR to filter so finding the related records and if the status is "Received" or "Stored" or "Client Hold". What is the synt...

Pipelines

SeanConnaughto1

Qrew Cadet

3 years ago

If you put parentheses around {127.EX.'{{a.id|int}}'} does that work?

{"from": "brce2frp8",
"select": [33,89,117,11,70,63,27,28,29,72],
"where": "({127.EX.'{{a.id}}'})AND
({71.EX.'Received'}OR{71.EX.'Stored'}OR{71.EX.'Client Hold'})",
"sortBy": [
{
"fieldId": 33,
"order": "ASC"
},
{
"fieldId": 117,
"order": "ASC"
}
]
}

------------------------------
Sean Connaughton
------------------------------