jql "ORDER BY created ASC" + "AND .. "

[Halif]

I am using api/2/search 

jql="(project=Test OR project=Test1) ORDER BY created ASC"  <- this jql working;

jql="(project=Test OR project=Test1) AND created <= now()"   <- this jql also working ;

jql="((project=Test OR project=Test1) ORDER BY created ASC) AND created <= now()"  <- NOT working.

How put this two parametres "ORDER BY created DESC" + "AND .. " together?

[Brant Schroeder · Accepted solution]

The order by has to come at the end of the JQL statement.  https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-764478330.html

You would have to do:

jql="(project=Test OR project=Test1) AND created <= now() ORDER BY created ASC"

[Warren]

Hi @Halif 

I agree with Brant's answer above.

To simplify your JQL, you can also change

(project=Test OR project=Test1)

to

project in (Test, Test1)