How to get jira project tickets using order by clause (Rest API)

Venusaikumar Chelluboina

I am trying to get the jira project tickets using Rest API POST method search. I am unable to include the order by clause in JQL json request body.

Request body:
{
jql: "project = PISS",
startAt: 0,
maxResults: 15,
orderby:{created:"ASC"},
fields: {
"summary",
"status",
"assignee"
}
}

 

Response:

The external system did not understand the request

error-result-guidance

The request was missing required details or was improperly formatted HTTP/1.1 400 Bad Request

unknown

Hello @Venusaikumar Chelluboina 

The sorting is done by the JQL, so the ORDER BY goes within the JQL statement, not as a request parameter:

{
  jql: "project = PISS ORDER BY created ASC",
  startAt: 0,
  maxResults: 15,
  fields: {
    "summary",
    "status",
    "assignee"
  }
}