Good morning,
is there a possible JQL that can allow a search of all the issues where two different date fields have the same dates?
For example: i usually use Target Start and Target End for my planning; I would search all those activities where Target Start = Target End (i.e. the milestones).
Is there a possible solution?
Thanks in advance.
Amedeo
@Amedeo This is not possible with the native JQL functionality. You will need a third party app to do this:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
FYI this is the open suggestion which you might want to consider upvoting:
I did a quick research and I believe these are the two apps which can do this:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Amedeo
Then you can try this filter
project = ABC AND due <= 1d AND "Start Date[Date]" >= -1d order by created DESC
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
it doesn't work anyway.
I don't know the [Date] you mentioned in the JQL because is a date planned by other colleagues.
Is there any other solution?
Thanks
Amedeo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Amedeo
can you use this filter
project = ABX AND "Start Date[Date]" = startOfDay() AND "End date/[Date]" = startOfDay()
Note: The start date and end date field should be there in the project.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thank you for the reply, but it seems not the real solution.
I try to explain it better:
- I have a list of issue where Target Start and Target End are equal within each issue, but different one from the other issue
- I would search all those issue where these two fields are equal to each other (into the issue)
I attached also a picture with an example.
Thanks
Amedeo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Join us June 26, 11am PT for a webinar with Atlassian Champion Robert Hean & Loom’s Brittany Soinski. Hear tips, stories, and get your burning questions answered. Learn how Loom makes training and enablement easier. Don’t miss it!
Register today
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.