[prev in list] [next in list] [prev in thread] [next in thread] 

List:       tellico-users
Subject:    Re: Case insensitive sorting
From:       Robby Stephenson <robby () periapsis ! org>
Date:       2023-05-03 1:59:17
Message-ID: CACFDV64uP8Tc9JpgkYRN2rcsQv7RYqGPJsxcWGN1OUoy-gntyA () mail ! gmail ! com
[Download RAW message or body]

On Tue, May 2, 2023 at 4:57 PM Bill Gee <bgee@campercaver.net> wrote:

> Is there a way to produce reports where the sorting is case INsensitive?
>

The sorting uses XSL which is language dependent, and for english, at
least, seems to default to what you note, that lower-case is sorted after
upper-case. https://www.w3schools.com/xml/ref_xsl_el_sort.asp

I'll see if I can find some sort of solution or option. In the mean-time,
if you make a copy of the Group_View.xsl file in the report-templates
folder, and edit line 153 or thereabouts to change
    <xsl:sort lang="$lang" select="@title"/>
to
    <xsl:sort lang="$lang" select="translate(@title,
                                             'abcdefghijklmnopqrstuvwxyz',

 'ABCDEFGHIJKLMNOPQRSTUVWXYZ')"/>
that will convert all the lower-case characters to upper-case before
sorting. Obviously, that only works for the 26 ascii characters represented
there, but at least it's a workaround.

Robby

[Attachment #3 (text/html)]

<div dir="ltr"><div dir="ltr">On Tue, May 2, 2023 at 4:57 PM Bill Gee &lt;<a \
href="mailto:bgee@campercaver.net">bgee@campercaver.net</a>&gt; wrote:<br></div><div \
class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Is there a way to produce \
reports where the sorting is case INsensitive?<br></blockquote><div><br></div><div>The sorting \
uses XSL which is language dependent, and for english, at least, seems to default to what you \
note, that lower-case is sorted after upper-case. <a \
href="https://www.w3schools.com/xml/ref_xsl_el_sort.asp">https://www.w3schools.com/xml/ref_xsl_el_sort.asp</a></div><div><br></div><div>I&#39;ll \
see if I can find some sort of solution or option. In the mean-time, if you make a copy of the \
Group_View.xsl file in the report-templates folder, and edit line 153 or thereabouts to \
change</div><div>      &lt;xsl:sort lang=&quot;$lang&quot; \
select=&quot;@title&quot;/&gt;</div><div>to</div><div>      &lt;xsl:sort lang=&quot;$lang&quot; \
select=&quot;translate(@title,<br>                                                              \
&#39;abcdefghijklmnopqrstuvwxyz&#39;,<br>                                                       \
&#39;ABCDEFGHIJKLMNOPQRSTUVWXYZ&#39;)&quot;/&gt;<br></div><div>that will convert all the \
lower-case characters to upper-case before sorting. Obviously, that only works for the 26 ascii \
characters represented there, but at least it&#39;s a \
workaround.</div><div><br></div><div>Robby<br></div></div></div>



[prev in list] [next in list] [prev in thread] [next in thread]