You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
Using this query to get tickets created in last month, but am seeing different numbers when using JQL vs Basic.
project in (###) AND issuetype in (Bug, Story) AND reporter in (###) AND created < endOfMonth(-1) and created >= startOfMonth(-1)
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.
Something is different, either in how you are building the queries or in your issue data changing. Please try this:
What I do not know is does startOfMonth() use date/time or just date. I suspect it is date/time, and so you could try this:
created < startOfMonth(-1m)
That should remove 1 minute, and so move into the prior day. If that does not work, start walking back until 1 November drops off.
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.