Sorting [was: Polygrid sorting]

[Bob Sneidar]

+1 if the source is a dabs, sort during query.

Bob S


On Aug 25, 2022, at 07:21 , Mike Kerner via use-livecode <use-livecode at lists.runrev.com<mailto:use-livecode at lists.runrev.com>> wrote:

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<mailto: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.