Red Hat Bugzilla – Bug 1264787
Document the 'order' parameter of Bug.search
Last modified: 2016-06-29 22:43:45 EDT
Description of problem:
After the recent BZ upgrade that included migration form MySQL to PostgreSQL, the order in which Bug.search returns its results changed. Before the upgrade, results were (afaics) effectively sorted by bug id. After the upgrade, returned bugs do not seem to be sorted in any way.
Any scripts that previously relied on / benefited from the automatic sorting need to be adjusted.
I was just about to file this bug! I agree this probably is due to the upgrade this past weekend.
I have this dumb little cmdline script I use to search bugzilla:
After the upgrade, I no longer get sorted bug numbers but they seem to come out in random order. This is significant since I usually look at the latest bug numbers to determine if the issue I'm investigating for a customer is one which has already been fixed in the RHEL component or not. And I can't just search open bugs since the bug may be fixed but in a recent version. I could make the search more sophisticated but for now it's a very simple too.
I use this on a weekly basis and I can't recall the output having unsorted bug numbers until this week when I noticed it.
Ok I figured out what I needed now. I just needed to add '&order=bug_id' to the query and I get sorted by bug_id output.
On further investigation, the 'order' parameter can be passed to Bug.search also. The value is a comma separated list of field names. Using 'bug_id' works but 'id' does not.
The 'order' parameter seems to be completely undocumented. We should rectify that.