Hi @NathanielB, welcome to our community!
Sounds like you’re looking to only return the items with a certain status label, start date, end date, and due date right?
If so, I’m afraid that our
items_by_column_values() method currently only allows filtering by a single value from a single column at this time. However, this is something that our developers are looking to implement soon! I’m happy to keep you in the loop and update here once the feature has been released.
For now, I would recommend querying all of the items by a single attribute (i.e. the status label, then the due date, etc) and then looking for overlaps in your own code backend.
Regarding your second question, you are able to query the
column_values of your items to return a JSON string that contains the start and end date data of your dates. However, the parsing of this data will need to be done by you in your own code.
For instance, this string is what would be returned should you query data from one of your timeline columns:
You would then need to parse through this returned data to separate the “from” and the “to” dates. Hope this helps!