Sorting [was: Polygrid sorting]

Mike Kerner MikeKerner at roadrunner.com
Thu Aug 25 10:21:00 EDT 2022


it will probably be faster and more flexible to have your database do your
soriting for you, though.

On Mon, Aug 15, 2022 at 7:47 PM Paul Dupuis via use-livecode <
use-livecode at lists.runrev.com> wrote:

> Perhaps some expansion of the column "pgContentTypeofColumn" property?
> The current possible values are:
> text|svg-lcname|imagedata|imagefile|color|boolean|autoincrement
> Allowing the addition of 'numeric' and 'datetime' would at least allow a
> mapping to sorts although sort support 'international' (perhaps should
> be the default for a polygrid column of type "text" and "binary". I am
> also not sure how svg-iconname, imagedata, imagefile, and color should
> sort. Perhaps svg-iconname should sort as "text". Bolean can sort as
> "text" since ascending puts "false" first and descending puts "true" first.
>
>
> On 8/15/2022 7:25 PM, Alex Tweedly via use-livecode wrote:
> > So it occurred to me, while playing with sorting by columns, that it
> > might be nice to have an additional "sortType" available.
> >
> > I'd like to be able to say
> >
> >  - if all the 'things' being sorted on are numbers, then sort numeric,
> > otherwise sort alphabetical.
> >
> > Would that be a reasonable enhancement request ?
> >
> > Would "natural" be a reasonable suggested name ?
> >
> > Alex.
> >
> >
> > _______________________________________________
> > use-livecode mailing list
> > use-livecode at lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> > subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
>
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>


-- 
On the first day, God created the heavens and the Earth
On the second day, God created the oceans.
On the third day, God put the animals on hold for a few hours,
   and did a little diving.
And God said, "This is good."


More information about the use-livecode mailing list