nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL for dates fields

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

Accepted answers

All comments

Pasam Venkateshwarrao

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.

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 Target start.PNG

Pasam Venkateshwarrao

Then you can try this filter

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

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

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

ok, thank you @Sayed Bares [ServiceRocket]

Amedeo

Sayed Bares [ServiceRocket]

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:

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server