DonationCoder.com forum
 
Read-only archive. This is a static copy of the DonationCoder.com forum. Reading and searching work as before; logging in, posting and private messages do not.
Archive of 2026-10-21 · About this archive · Main site

Author Topic: Is there a way to set the ordering of clips case insensitive?  (Read 10,655 times)

MarcoPa

  • Supporting Member
  • Joined in 2022
  • **
  • Posts: 3
Is there a way to set the ordering of clips case insensitive?

I use favourites extensively and alphabetical sorting is still the best way for me to keep an overview. I was able to find out quite quickly that alphabetically descending sorting is possible by entering ‘ExcerptText DESC’ under ‘Custom Menu Sorting SQL’.

Unfortunately, the entries ‘ExcerptText DESC CI’ or ‘ExcerptText DESC CaseInsensitive’ only lead to error messages.

PS: And last but not least, thank you very much for this ‘little’ programme, which makes life so much easier for me as a neurodivergent person. I have tested dozens of comparable and less comparable programmes. In my opinion, CHS is still the undisputed leader, certainly for the way I use it.

MarcoPa

  • Supporting Member
  • Joined in 2022
  • **
  • Posts: 3
Re: Is there a way to set the ordering of clips case insensitive?
« Reply #1 on: April 18, 2025, 10:31 PM »
I have the solution: ExcerptText DESC NOCASE

Original address: https://www.donationcoder.com/forum/index.php?topic=54995.0