Bram van Oosterhout

How can I sort topics in a search without case sensitivity? At this point, when a topic has an upper case letter, it is treated different from a lower case letter.

I'm using Klingon words in my wiki, and the search result shows baS before bach instead of alphabetically correct first bach then baS.

-- LieVen - 30 Sep 2019

Hi LieVen,

Are you sorting the results of a SEARCH { order="on" ...}? If so, then the sort order is as you see it can be changed by some clever manipulation of the format="..." parameter. SEARCH sorts the formatted output.

If you are sorting a TABLE, the answer is different.

A very simple implementation can be achieved by using the DBCachePlugin and the DBQUERY macro. The result you want is produced by

DBQUERY{ ... format="$lc($topic) ..." sort="on" ...}

I can give you a full example if you provide me about some additional information about your topics and the output required..

-- BramVanOosterhout - 10 Jan 2020