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

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

Wilson Chau October 17, 2019

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

Comment

Log in or Sign up to comment
Gikku
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 17, 2019

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
Wilson Chau October 17, 2019

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

Gikku
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 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.

Wilson Chau October 17, 2019

Thanks again!

TAGS
AUG Leaders

Atlassian Community Events