Skip to main content

Hi,


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: dInt]) {
boards (ids:$boardIds) {
name
items {
id
name
group { color }
column_values { id title text value }
}
groups {
id
}
}

}



Br, YarHuoy

Hi


Is there any update??


Br, YH


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: aInt]) {
boards (ids:$boardIds) {
name
items (limit:100) {
id
name
group { color }
column_values (ids:e"date4"]) { id title text value }
}
groups {
id
}
}
}

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.