Skip to main content
Question

Using AND & OR in Quickbase API Pipeline Channel

  • December 17, 2021
  • 0 replies
  • 36 views
Forum|alt.badge.img+8
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
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+4
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
------------------------------
Terms & ConditionsAccessibility statement