Query Column Value by Range

monday Apps & Developers Feature Requests - API and Apps Framework
,
1

Hi,

Based on the following example from the documentation - Would it be possible to define a date range rather than an explicit date?

query {
items_by_column_values 
(board_id: 20178755,
 column_id: "date", 
column_value: "2019-02-06") {
id
name
}
}
Add operators to find items by date or number range in one request
2

Hi @JHoward :wave:

I’m afraid that you can’t currently search for a date range via the API. Instead, you’d need to search for a specific date value.

With that said, I’m more than happy to pass this along to our team as feedback for review and consideration as we continue to make improvements to the API :muscle:

-Scott

1 Like
Advise for Performance Issue & Getting Timeout Error 504
3

Hi @Scott-monday.com I have exactly the same requirement. Is there any update on this in the meantime? I couldn’t find it in the API documentation so am guessing it’s still not possible, but I’m hoping I’m wrong :slight_smile:

4

Would like to bring this up again…

It seems an obvious over sight that both the date range cannot be queried via the API nor a “person” column ( when there is more than one person assigned ).

This surely would be easily solved via a simple string search ?

Retrieving all items, and then filtering on the back end is a “bloat” on the graphql query response - that needs to be filtered at the back end.

Actually its very simple to filter on the back end, except that it is hamstrung by query complexity thresholds per account.

The API needs urgent modifications.

5

Is this still a limitation? Anyone have any recommended workarounds? I’d like to automatically query a board at the start of each month and return items that have due dates that fall in the following month.

6

Hello @max!

As of today you can not specify dates in the query itself as a parameter.

You can use items_by_multiple_column_values and use all the different possible dates as values like this:

{
  items_by_multiple_column_values(column_values: ["2022-10-20", "2022-10-19"], board_id: 1234567890, column_id: "date4") {
    id
  }
}

Or you could get all the items and then do the filtering on your end.

I hope that helps!

Cheers,
Matias

7

Hi @Matias.Monday or @CSG ,
Do you have any plans to implement a proper date range search and if so when?
Thanks,
Andras

8

Hi @atokesredk,

This is not in our plans for the near future but I’m happy to add your vote to this request to the development team. This team will take demand into consideration for future feature updates.

10

Well, it wasn’t in your known plans January 27th, 2023, but now coming up on January 15, 2024 - not only was this in the near future, the changes that enable it are mandatory.

This is possible with items_page on a boards in API 2023-10. So this request is actually live now.