JQL query not working by created and updated

essteffan January 18, 2018

Hi All.

I have an api jql query which is not working correctly 

 

$server/rest/api/2/search?startIndex=0&jql=assignee+=+usertest&created+>=+2018-01-01+&+updated+<+2018-01-31+&timespent>0&fields=key&maxResults=100

 

it gives me all tasks but not filtered by date and timespent

 

Can you help me?

Thanks!

1 answer

0 votes
Andy Heinzer
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
January 23, 2018

Your JQL query is not actually sorting the results at all.  If you want to do that, you will likely need to add in the 'ORDER BY' clause, select a field to sort by, and then a direction (ascending or descending).

If the JQL was in Jira it would look something like this:

assignee=admin AND created>=2018-01-01 AND updated<2018-01-31 AND timespent >0 ORDER BY updated desc

In your case, I'm not sure the exact syntax though since it seems like some of the characters are already getting replaced with + signs and other characters.

Suggest an answer

Log in or Sign up to answer