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
------------------------------
Pipelines

1 Reply

Sort By
  • SeanConnaughto1's avatar
    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
    ------------------------------