JQL start and end date

[Vreni Wechsler]

Hello everyone

I would like to create a query in which the tickets in two projects create the cause as a selection field and the date from to.
When I use this query, tickets that are not in this period are displayed. I need to have from 01.01.2023 to 31. 03.2023.

What is the correct query for this?

Thank you for your support.

JQL:
project in (X, XL) AND issuetype in (xxx, xx) AND "Ursache (intern)[Select List (cascading)]"=Funktionsfehler OR "Ursache (intern)[Select List (cascading)]"="Beschädigtes Bauteil (z.B. verkratzt, verbogen)" or "Ursache (intern)[Select List (cascading)]"="Qualität Bauteil (mechanisch/optisch/dimension)" or "Ursache (intern)[Select List (cascading)]"= Verschleiss AND created >= 2023-01-01 AND created <= 2023-03-31

[Marc Koppelaar - Devoteam · Accepted solution]

Hi @Vreni Wechsler 

I see multiple or statements in the clause,  put the all in one bracket related clause (See bold brackets ())

project in (X, XL) AND issuetype in (xxx, xx) AND ("Ursache (intern)[Select List (cascading)]"=Funktionsfehler OR "Ursache (intern)[Select List (cascading)]"="Beschädigtes Bauteil (z.B. verkratzt, verbogen)" or "Ursache (intern)[Select List (cascading)]"="Qualität Bauteil (mechanisch/optisch/dimension)" or "Ursache (intern)[Select List (cascading)]"= Verschleiss) AND created >= 2023-01-01 AND created <= 2023-03-31

Or you would need to provide the date range in all or clauses.

[Vreni Wechsler]

Hello @Marc Koppelaar - Devoteam 

Perfect. It fits like this. Many thanks for your support.

Now I have my JQL as it should be.

BR Vreni