Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,641,230
Community Members
 
Community Events
196
Community Groups

Hi guys, how do i write a query to search for JIRAs i created as of a specific date?

I'm trying to only filter out JIRAs I created today going fwd, as a clean start as all my previous ones are no longer relevant.  I found the tag 'createdDate' and tried to assign it a date value, but it doesn't work.  (new to JIRA queries, so if some rock starts can help me with a quick formula, be greatly appreciated - thanks!)

This is what I have:
created >= -1w order by created DESC, createdDate > 20191017

This is the error:
Error in the JQL Query: Expecting either 'ASC' or 'DESC' but got '>'. (line 1, character 51). 

Even when i replaced the '>' with 'ASC', still getting an error.  And there is no page to show how to write queries in JIRA.

Thanks!

1 comment

Gikku
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Oct 17, 2019 • edited

Hi @Wilson Chau 

For all issues created by you for today, you can use below.

reporter = currentUser() and created >= startOfDay()

If you want to use a specific date, please use

created >= '2019/10/17'

Like Wilson Chau likes this

Thanks a lot Gikku - that worked!!  Is there a page where I can learn the correct syntax for these queries? 

Gikku
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Oct 17, 2019

Hi @Wilson Chau 

Please refer the Atlassian documentation for all the options available. You should be reading through the fields reference and functions pages.

Comment

Log in or Sign up to comment
TAGS
AUG Leaders

Atlassian Community Events