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

Difference in JQL vs Basic searching

David Cleveland_1lfbgv

Using this query to get tickets created in last month, but am seeing different numbers when using JQL vs Basic.

JQL:

project in (###) AND issuetype in (Bug, Story) AND reporter in (###) AND created < endOfMonth(-1) and created >= startOfMonth(-1)

basic

screenshot jira.PNG

Accepted answers

Bill Sheboy

Hi @David Cleveland -- Welcome to the Atlassian Community!

Did you notice your basic search is checking all projects and the View All Issues (advanced JQL) is searching for specific ones?

Did you notice your basic search is including the last day of October and your advanced JQL is using created < endOfMonth(-1) and not <= for the value? I wonder if you have any issues on 31 October which are excluded as a result of that.

Kind regards,
Bill

All comments

Bill Sheboy

Hi @David Cleveland -- Welcome to the Atlassian Community!

Did you notice your basic search is checking all projects and the View All Issues (advanced JQL) is searching for specific ones?

Kind regards,
Bill

Sanjen Bariki_rtm841

Hi @David Cleveland ,

Welcome to atlassian community!

You are correct @Bill Sheboy .

As per the shared screen, JQL and basic are too difference.

In JQL you have mentioned for a specific project and added the duration for a specific once.

In Basic you have mentioned for all the projects and it will include all the duration as you added manually.

Regards,

Sanjen

David Cleveland_1lfbgv

What if i had the JQL reporter in (##) AND created > startOfMonth(-1M) AND created < startOfMonth() ORDER BY created DESC

the JQL is returning more results than the basic search. Basic search would be the same as above.

Bill Sheboy

Something is different, either in how you are building the queries or in your issue data changing. Please try this:

Create your basic search, and test it to return what you want
Then select "Switch to JQL" on the right-side of the page
Compare that generated JQL to what you were using as stand-alone JQL to observe the differences

David Cleveland_1lfbgv

Looks like in the JQL it is pulling November 1st where as in the basic, it is stopping at October 31st. Any thoughts on how to change the JQL to remove the first day of the current month?

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud