Forum Discussion

JulieMeeker's avatar
JulieMeeker
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 syntax to nest the OR statements.  Here's what I have, but it's not working. 

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

------------------------------
Julie Meeker
------------------------------
No RepliesBe the first to reply