We are currently develop a Calendar App (very much like the default calendar, with some extra features) and I’m facing serious performance issue because I’m getting ALL the data without any filtering. I would like to filter the data based on specific date range (only display the data of current month / week) but it seems not possible based on this ticket Query Column Value by Range - #2 by Scott-monday.com
Is there any other advise / work around for this issue?
This is my query:
query ($boardIds: [Int]) {
boards (ids:$boardIds) {
name
items {
id
name
group { color }
column_values { id title text value }
}
groups {
id
}
}
If you’re returning a large amount of data, you may see the request time out.
Instead, I’d recommend using the limit and page parameters to page through the results. This will let you split the items into multiple API calls.
If you’re only interested in the date information, you can make your query more lightweight by filtering to just a specific column ID. Here’s an example:
query ($boardIds: [Int]) {
boards (ids:$boardIds) {
name
items (limit:100) {
id
name
group { color }
column_values (ids:["date4"]) { id title text value }
}
groups {
id
}
}
}