Hi,

We are currently develop a Calendar App (very much like the default calendar, with some extra features), I’m struggling how to overcome the performance issue for large amount of data (had reported in Advise for Performance Issue & Getting Timeout Error 504 as well).

Is that possible to filtered by multiple column_values with 1 column_id?

Something like:

query ($boardId: Int!) {

items_by_column_values (board_id:$boardId, column_id:“startDate”, column_value:“2021-01-01,2021-01-02,2021-01-03,2021-01-04,2021-01-05”) {

id

name

column_values { id title text value }

}

}

Since I can’t filtered by date range, so I tried to loop a bunch of dates and keep calling API to get the item within a certain date range:

    var queryCalendar = `query ($boardId: Int!, $startDateId: String!, $calendarStartDate: String!) {

                      items_by_column_values (board_id:$boardId, column_id:$startDateId, column_value:$calendarStartDate) { 

                        id

                        name

                        column_values { id title text value } 

                      } 

                    }`;

    Object.keys(dateArray).forEach(key => {

        monday.api(queryCalendar, { variables: {boardId: boardId, startDateId: startDateId, calendarStartDate: dateArrayekey]} })

          .then(res => {

            console.log(res);

          });

     });

But I keep getting this error when I go to Calendar Month View:

Any idea how can I solve this?

Thanks

Br, YH