AW: Polygrid sorting (problems)

[Paul Dupuis]

BTW the problem of:
the text of widget X
the csvData of widget X
the tsvData of widget X
AND (not in the Livecode 9.6.8 Dictionary for PolyGrid 1.1.1)
the pgText of widget X
ALL not returning the full data for a PolyGrid widget is a confirmed bug:

See https://quality.livecode.com/show_bug.cgi?id=23886



On 8/15/2022 3:34 PM, Paul Dupuis via use-livecode wrote:
> 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
>
>
> _______________________________________________
> 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