SQL - Search Items by column values - by Range of dates

Hello there,

Matias here!

You can not add a parameter to your query to filter using dates.

In this case you would have to retrieve all of the items in the board, and the value of that date column and then do the filtering on your end, using those values.

Hope this helps 🙂

Cheers,
Matias

Thanks Matias !
I have more than 7,000 items in the board. It takes lot of time to process.
In addition, what is the Max limit of items to be retrieved with API?

Thanks!

Hello again,

As a workaround you could build a flow in which the items get sorted into different groups by date.

You could then specify the group/s you want to retrieve.

As for the limit, you can retrieve as many items as you want via API, but you will probably need to use pagination for this.

Let me know if you have more questions!

Cheers,
Matias

Thanks. I made couple of scenarios to get the items each time by different filter.
Works.

Thanks!