Getting Started

 View Only

Using AND & OR in Quickbase API Pipeline Channel

  • 1.  Using AND & OR in Quickbase API Pipeline Channel

    Posted 12-17-2021 15:52
    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
    ------------------------------