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: http://git.engineering.redhat.com/git/users/dwysocha/tools.git/tree/bin/seg-search-bz 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.
This bug has missed the BZ5 feature freeze and has been bumped to 5.x.
*** Bug 1956944 has been marked as a duplicate of this bug. ***
On QA sever: 1: Go to advanced search page, click menu ->Help->Page Help! 2: Click on '2.5.5. Sort Order' in docs menu Doc explains order drop down on advanced search page and how to manually craft the order.
This fix has been deployed to stage Bugzilla for a short public testing phase. https://bugzilla.stage.redhat.com
This change is now live. If there are any issues, do not reopen this bug. Instead, you should create a new bug and reference this bug.