Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL for dates fields

Amedeo
Contributor
August 24, 2023

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

3 answers

0 votes
Sayed Bares _ServiceRocket_
Community Champion
August 24, 2023 edited

@Amedeo This is not possible with the native JQL functionality. You will need a third party app to do this:

Amedeo
Contributor
August 24, 2023

ok, thank you @Sayed Bares _ServiceRocket_ 

 

Amedeo

Like • Sayed Bares _ServiceRocket_ likes this
Sayed Bares _ServiceRocket_
Community Champion
August 24, 2023 edited

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:

  1. JQL Search Extensions for Jira
  2. Enhanced Search (JQL & Subqueries)
Like • Amedeo likes this
0 votes
Pasam Venkateshwarrao
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 24, 2023

Hi @Amedeo 

 

Then you can try this filter

project = ABC AND due <= 1d AND "Start Date[Date]" >= -1d order by created DESC

Amedeo
Contributor
August 24, 2023

Hi @Pasam Venkateshwarrao ,

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

0 votes
Pasam Venkateshwarrao
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 24, 2023

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.

Amedeo
Contributor
August 24, 2023

hi @Pasam Venkateshwarrao ,

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

AmedeoTarget start.PNG

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, loom, loom for training, loom for teaching, video training, async learning, online education, screen recording, loom tutorials, loom use cases, atlassian learning, team training tools, instructional video, virtual training tools

🛗 Elevate Your Training and Enablement with Loom

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
AUG Leaders

Atlassian Community Events