You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
Good morning, I would like to filter my Kanban Issues by the date an issue was placed into "Completed," "Closed," or "Cancelled". I am trying to only display and export data that started on 01 October 2023. Any ideas? Thank you,
Assuming your workflows are properly setting the "resolution" field when ticket transitions to "completed/closed/cancelled" status ... then you can use "resolved" to query against dates ...
If you're only after those resolved on 01-Oct ...
resolved >= "2023-10-01" and resolved < "2023-10-02"
If you're only after those created on 01-Oct ...
created >= "2023-10-01" and created < "2023-10-02"
If you want those created and closed on 01-Oct ...
created >= "2023-10-01" and created < "2023-10-02" and resolved >= "2023-10-01" and resolved < "2023-10-02"
I hope this helps?