Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    It doesn’t have an option directly. But you could try making a temporary field will everything uppercase then sort by that.

    If you are sorting by field “last_name”, create last_name_uc field and sort by that.

    [cfdb-table form="myform" trans="last_name_uc=strtoupper(last_name)&& SortByField(last_name_uc)"]

    Thread Starter Theo

    (@dubeux)

    Mr. Simpson, thank you very much for your usual amazingly fast and kind support.
    It did work perfectly. Let me just point out that I tried something similar, after reading the filter docs, but it didn’t work because of (I think) an error on this code (“Filter Functions vs. Transforms Functions” paragraph):
    trans=”first_name=strtoupper(first_name)”

    Not being a coder, I did not realize at first, but I suppose it’s a variable attributing a value to itself.

    All the best.

    Plugin Author Michael Simpson

    (@msimpson)

    Be careful not to have curly-quotes in the shortcode.

    Thread Starter Theo

    (@dubeux)

    Yep, thank you.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Does sorting must be case-sensitive ?’ is closed to new replies.