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; } } }

Using Between operator in JQL query

Zaki Ögmundsson

Hi all,

I've got two JQL queries:

createdDate > startOfMonth() and createdDate < endOfMonth()

createdDate between startOfMonth() and endOfMonth()

Can someone explain to me why the former JQL query will run while the latter will not?

Thanks,

Zaki

Accepted answers

Filipi Lima

Hello, Zaki,

The way Jira implements the between is through the use of the dual notation, showing both the start and end threshold as you did on 1.

For example, if you apply this on Basic Search:

It gets translated into:

created >= 2022-05-01 AND created <= 2022-05-02

All comments

Filipi Lima

Hello, Zaki,

The way Jira implements the between is through the use of the dual notation, showing both the start and end threshold as you did on 1.

For example, if you apply this on Basic Search:

It gets translated into:

created >= 2022-05-01 AND created <= 2022-05-02

Zaki Ögmundsson

Hi Filipi,

I see. Does that mean that the Between operator can only be used for dates and not functions like startOfMonth()?

Filipi Lima

HI, Zaki,

Even though "between" is considered a keyword (this list is hardcoded) I could not find any implementation of it which means it won't work for date values either.

We have to stick to the implementation provided above - using a lower and an upper threshold separately.

I'll look a bit more if there's any application for "between" and will reply back if I find anything.

Zaki Ögmundsson

Hi Filipi,

Thank you for your help. I really appreciate it

I'll just keep in mind to use Between for dates and not for functions.

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

jql