637642 - Web-service (XML-RPC, JSON-RPC) Bug.search method has no "order_by" parameter

Status: RESOLVED FIXED

(Bugzilla :: WebService, enhancement)

Description

[Petr Dvorak]

User-Agent:       Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_6_6; en-US) AppleWebKit/534.13 (KHTML, like Gecko) Chrome/9.0.597.107 Safari/534.13
Build Identifier: 

When asking for bug list using the XML-RPC interface, I am able to specify "limit" and "offset". However, these are not very useful without being able to specify "order_by" too - I need to get all issues in order to sort them on my side anyway.

It would be nice if the WS allowed me to specify how to sort the bug list, for example in this fashion:

{"order_by":
  [
  {"first_field": "ASC"},
  {"second_field": "DESC"}
  ]
}

Reproducible: Always

Comment 1

[Koosha KM]

What fields should be accepted to do the sort on? Are all of the returned fields acceptable?

Comment 2

[David Lawrence [:dkl]]

(In reply to Koosha Khajeh Moogahi [:koosha] from comment #1)
> What fields should be accepted to do the sort on? Are all of the returned
> fields acceptable?

They should be valid column names returned by Bugzilla::Search::COLUMNS with the allowance of ASC or DESC after the column name. Just mimic how Bugzilla::Search does it at lines 907-922 in _validate_order_columns.

dkl

Comment 3

[Frédéric Buclin]

'order' is available since Bugzilla 5.0, see bug 477601.