How is "OVERDUE", "DONE_ON_TIME", "DONE_OVERDUE" used? The date column does not seem to have this information.
If you use a filter like “TODAY”, how is the comparison done? Like does it find all date values within the “today range” for the user’s specific timezone or all “today” values in UTC?
Is there any way to filter with a specific date or date and time. Like query_params:{rules:[{column_id:"date1",compare_value:["2023-11-16 05:00:00"],operator:any_of}]
If a date column is configured using “set as deadline” it ties it to a status column which has an “is_done” property. My guess is that the data is not exposed in the API (yet - feature request time!), my guess is there are hidden deadline fields that are searchable.
Thanks @codyfrisch , the additional information helps.
Anyone can answer the other questions over “$$blank$$” and how comparisons work?
I’m not sure how Monday even expects users to use any of these filters if they don’t provide any technical details on the filter’s exact data range. I greatly hope there is some way to filter by exact values instead of these arbitrary tags.
Apologies for the delay. I just heard back with some answers to your questions
To start, are you trying to retrieve specific data? If so, let me know what you’re looking for and we can find a query that works for you!
On to your specific questions:
$$blank$$ = blank values. If you want to return columns with blank values, you would use this compare value.
These are only relevant if the date column is combined with status (i.e., deadline mode).
overdue: status is not done and today is after the specified date
done on time: status was marked as done before the specified date
done overdue: status was marked as done after the specified date
Today is based on the user’s time zone defined on their profile.
You can filter a specific date by entering that date as the compare value (see here). I am still waiting to confirm whether or not you can use a time as well.
We are working on documentation that outlines what each compare value does, so this should help with future questions. Please let us know if you have any other questions in the mean time.
Hi @rachelatmonday ,
Thank you very much for looking into this. That helps clear up a lot of details.
Today is based on the user’s time zone defined on their profile.
Somewhat related question, is this also true for the Hour ColumnValue? For example, based on the above provided details, I assume Early morning is also a time range in the user’s time zone? If not, can you provide the specific time ranges for the following labels:
