JQL for dates fields

[Amedeo]

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

[Sayed Bares _ServiceRocket_]

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

• https://marketplace.atlassian.com/search?hosting=cloud&query=jql

[Amedeo]

ok, thank you @Sayed Bares _ServiceRocket_ 

Amedeo

[Sayed Bares _ServiceRocket_]

FYI this is the open suggestion which you might want to consider upvoting:

• JRASERVER-20727
• JRACLOUD-20727

I did a quick research and I believe these are the two apps which can do this:

1. JQL Search Extensions for Jira
   • DateCompare()  and DateCompareIgnoreTime()
2. Enhanced Search (JQL & Subqueries)
   • dateCompare

[Pasam Venkateshwarrao]

Hi @Amedeo 

Then you can try this filter

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

[Amedeo]

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

[Pasam Venkateshwarrao]

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]

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

Amedeo