Page MenuHomePhabricator

sort order for inline queries is case sensitive
Closed, DeclinedPublic

Description

Author: M8R-1omeu9

Description:
It would be really nice if one could have as a default (or specify) that |sort=someProperty sorts results in case insensitive order.

This clears up any confusion when there are many results and GIMP comes before Gdb, and CPPI comes before Clisp, for example.


Version: unspecified
Severity: enhancement
OS: Linux
Platform: PC

Details

Reference
bz33134

Event Timeline

bzimport raised the priority of this task from to Low.Nov 22 2014, 12:03 AM
bzimport set Reference to bz33134.
bzimport added a subscriber: Unknown Object (MLST).

SMW will respect the sort key that is set in MediaWiki, so it is possible to manually defined a lower-case sort key as a workaround.

In general, the sort mode depends on the setting in the database and cannot easily be changed from query to query based on parameters. It might be possible for you to manually change the collation setting of the database table (for SMW sortkeys, the respective table is smw_ids, column smw_sortkey) so that it is not case sensitive.

How about MediaWiki's sorting behaviour on Category pages? Ideally, SMW should behave in the same way.

Aklapper added a subscriber: Aklapper.

The Semantic MediaWiki developers requested in https://phabricator.wikimedia.org/T64114 to move their task tracking to https://github.com/SemanticMediaWiki/SemanticMediaWiki/issues and to close remaining tasks in Wikimedia Phabricator. If you still face the problem reported in this task in a supported version of SMW, please feel free to transfer your report to https://github.com/SemanticMediaWiki/SemanticMediaWiki/issues . We are sorry for the inconvenience.