Polygrid sorting (problems)

[Paul Dupuis]

So there is an example of sorting in the PolyGrid documentation under 
the entry for the MESSAGE "headerClick" and under the entry to the 
PROPERTY "text" (and in 'the text of me')

The example code only sort the visible rows as "the text of widget X" 
returns the data of PolyGrid X as tab delimited, WITHOUT the column 
headers, but ONLY the visible rows.

So, what to use for sorting all the data in a PolyGrid by a particular 
column?

The tsvData of widget X (and csvData, and Text) doesn't seem to work. 
The all seems to only get the visible data (rows). Only the pgData of 
widget return the whole dataset of the PolyGrid. Is this the way these 
properties are supposed to work?

If that is how text, csvData, and tsvData are supposed to work 
(returning only the visible rows), then the sort example in the PolyGrid 
documentation require updating otherwise these properties require updating!



On 8/15/2022 2:29 PM, Paul Dupuis via use-livecode wrote:
> So, I bought the Summer Bundle. Yes, it is a good deal.
>
> In my case it was primarily for the Polygrid widget. Our application 
> uses a Datagrid to display customer research data. The columns headers 
> are text and the left most column ROWs are test and all other cells 
> are numbers. Some customers can have quite large data sets and I have 
> been running into the number of columns (ad a default width of 100px 
> per column) exceeding a GROUPs 32,767px width maximum (about 327-328 
> columns). At this point the Datagrid just fails - no data is displayed.
>
> I can now attest that a Polygrid (under LC 9.6.8) does not have this 
> limit. I have a "test" stack (for Datagrid testing) I converted to the 
> Polygrid and can easily generate 1000 columns x 1000 rows of data and 
> it works.
>
> So I guess the answer to bug 
> https://quality.livecode.com/show_bug.cgi?id=23875 is "Use the PolyGrid"
>
> On that note, the Datagrid has 2 features I use in this specific case, 
> user column resizing (built into the Polygrid - Yea!) and column 
> sorting (NOT built into the Polygrid - Boo!). So, does anyone have 
> some column sort code for the Polygrid they have written that they 
> might be willing to share?
>
> Also, I have filled a Polygrid enhancement request to allow the left 
> column (or the left N columns) to be locked/frozen, so they remain 
> visible when the Polygrid is scrolled horizontally. See 
> https://quality.livecode.com/show_bug.cgi?id=23880. If you might 
> benefit from this enhancement, please follow the bug or add a comment 
> to that effect.
>
>
> _______________________________________________
> 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