Items_query complex filter (mix of AND/OR operators)

Hi Antonio,

You can use items_page and use the operator field in the query_params when setting the rules, as said in the documentation here.

You can insert the operator inside a specific rule:
query_params: {rules: {column_id: "timeline", compare_value: ["2023-06-30", "2023-07-01"], compare_attribute: "START_DATE", operator:between}

You can also use the operator for rules themselves:
query_params: {rules: [{column_id: "people", compare_value: ["Person 1", "Person 2"], operator:contains_text} {column_id: "status", compare_value: [1, 0]}]operator:and}

Hope this helps with your queries!

Best,
Joseph

Hi Joseph. Thanks for your response.

I’m still unclear as to how I can combine both logical operators (AND/OR) in an items_query.

For example, I can find projects that last less than 5 days OR more than 100 days (e.g. I’m looking for outliers) like so:

query_params:
{
rules: [
{
column_id: “duration__days_”,
compare_value: 5,
operator: lower_than
},
{
column_id: “duration__days_”,
compare_value: 100,
operator: greater_than
}
],
operator: or
}
)

How can I now add an extra criteria that says that the Status of the project is “Stuck”, i.e. find projects that are stuck, whose duration is either lower than 5 or higher than 100?

In pseudo-code this would be an expression like:

(DurationDays < 5 OR DurationDays > 100) AND Status = ‘Stuck’

Notice I’m combining the OR operator with the AND operator. In the UI I would do this using the “Add new group” button, but I don’t know the equivalent way to do this via the API.

Hi Antonio,

I think you can do something like this:

query_params:
{rules: [{[{column_id: “duration__days_”,compare_value: 5,operator: lower_than
},{column_id: “duration__days_”,compare_value: 100,operator: greater_than}],
operator: or}},
[{column_id:“status”,compare_value:“stuck”,operator:contains_text]operator: and}

Essentially, you can create the list of rules and use an operator between the list of rules.

Best,
Joseph

Hi Joseph,

Nesting an array of rules inside a parent rule makes sense to me, for this requirement, but it doesn’t appear to work. I keep getting parse error and red squiggles in the API playground.

Could you give it a try on your end? I might be messing something up with parentheses.

I’d very much appreciate a working example query.

Thanks,
Antonio

Hi Antonio,

Can you share the query_params you have ended up with? I am guessing you’ve been playing around with it more than just the example I provided. I will try on my end as well.

Best,
Joseph

Dear Antonio,

I’ve reviewed your question regarding filtering items on Monday.com via the API using “and” and “or” combination criteria, and I managed to find a solution that might be helpful to you.

After exploring different approaches, I was able to craft a query that utilizes nested rules within groups to combine “and” and “or” logic as follows:

{
  boards(ids: 1452653689) {
    groups(ids: ["new_group29179"]) {
      items_page(
        query_params: {
          groups: {
            rules: [
              { column_id: "numbers", compare_value: ["100"], operator: any_of }
            ],
            operator: and,
            groups: {
              rules: [
                { column_id: "name", compare_value: ["Task 1"], operator: any_of },
                { column_id: "name", compare_value: ["Task 3"], operator: any_of }
              ],
              operator: or
            }
          }
        }
      ) {
        cursor
        items {
          id
          name
          column_values(ids: ["name", "numbers"]) {
            id
            text
          }
        }
      }
    }
  }
}

Has anyone been able to make this query work? when I put it in the playground I get an error message saying the query_params object doesn’t contain a groups field.

Hello there @sgdev,

Would you be able to please share the exact query you are using? (you can omit sensitive data).