Re: Polygrid sorting

2023-08-25 Thread Paul Dupuis via use-livecode
Thank you Panos! I must be going blind not to have seen the example when I clicked on the Dictionary entry for the message! On 8/25/2023 5:16 AM, panagiotis m via use-livecode wrote: Hello Paul, See the example in the dictionary for the "headerClick" message: local sDirection on headerClic

Re: Polygrid sorting

2023-08-25 Thread panagiotis m via use-livecode
Hello Paul, See the example in the dictionary for the "headerClick" message: local sDirection on headerClick pColumnNumber local tText put the text of me into tText put not sDirection[pColumnNumber] into sDirection[pColumnNumber] set the itemDel to tab # Sort data by this

Polygrid sorting

2023-08-24 Thread Paul Dupuis via use-livecode
The Polygrid, unlike the Datagrid, has no built in column sorting. You have to roll your own. Before I write my own, has anyone written a column sort (i.e click on a column header to sort by it) for a Poly grid they'd care to share? ___ use-livec

Re: Sorting [was: Polygrid sorting]

2022-08-25 Thread Mike Kerner via use-livecode
oh, i love this topic. this onion is so, so thick. since you are throwing in the curveball of on-demand column sorting, i have several suggestions (and these are just my suggestions): the obvious one is to use one of the bajillion ways that LC can sort, right? grab the data (if you don't already ha

Re: Sorting [was: Polygrid sorting]

2022-08-25 Thread Paul Dupuis via use-livecode
So what if you use the column headers on a PolyGrid (or whatever) to give the user a UI for sorting by column (adding, or not, sort arrows to the header labels). Is it still more efficient to re-query the database with the new, user chosen, sort order and repopulate the PolyGrid? Or more eff

Re: Sorting [was: Polygrid sorting]

2022-08-25 Thread Bob Sneidar via use-livecode
Not sure how that happened. If the source is a DATABASE... On Aug 25, 2022, at 08:02 , Bob Sneidar via use-livecode mailto:use-livecode@lists.runrev.com>> wrote: +1 if the source is a dabs, sort during query. Bob S ___ use-livecode mailing list use-l

Re: Sorting [was: Polygrid sorting]

2022-08-25 Thread Bob Sneidar via use-livecode
+1 if the source is a dabs, sort during query. Bob S On Aug 25, 2022, at 07:21 , Mike Kerner via use-livecode mailto:use-livecode@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

Re: Sorting [was: Polygrid sorting]

2022-08-25 Thread Mike Kerner via use-livecode
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@lists.runrev.com> wrote: > Perhaps some expansion of the column "pgContentTypeofColumn" property? > The current possible

Re: AW: Polygrid sorting (problems)

2022-08-18 Thread Paul Dupuis via use-livecode
Yes, Livecode enhancements bundle 1_0_21 (with PolyGrid 1.1.3) On 8/18/2022 8:31 PM, Mike Kerner via use-livecode wrote: which version is that? 21? On Thu, Aug 18, 2022 at 7:21 PM Paul Dupuis via use-livecode < use-livecode@lists.runrev.com> wrote: All, Bug 23886 has been fixed with the lat

Re: AW: Polygrid sorting (problems)

2022-08-18 Thread Mike Kerner via use-livecode
which version is that? 21? On Thu, Aug 18, 2022 at 7:21 PM Paul Dupuis via use-livecode < use-livecode@lists.runrev.com> wrote: > All, > > Bug 23886 has been fixed with the latest release of the Summer Bundle > widget sets. Download from the store. > > On 8/17/2022 3:51 PM, Paul Dupuis via use-li

Re: AW: Polygrid sorting (problems)

2022-08-18 Thread Paul Dupuis via use-livecode
All, Bug 23886 has been fixed with the latest release of the Summer Bundle widget sets. Download from the store. On 8/17/2022 3:51 PM, Paul Dupuis via use-livecode wrote: 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 Di

AW: Polygrid sorting (problems)

2022-08-17 Thread Paul Dupuis via use-livecode
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=

Re: Polygrid sorting

2022-08-16 Thread Mark Smith via use-livecode
I downloaded and installed the widget, it works (very well) now :) > On 15 Aug 2022, at 9:10 pm, Paul Dupuis via use-livecode > wrote: > > Okay, I built the stack and tested it under Windows 10. The 3 beeps are > intentional. It is to let me know when it is done as some test with 500+ > colu

Re: Polygrid sorting

2022-08-16 Thread Mark Smith via use-livecode
Hi Paul, My bad. I don’t have the polygrid widget installed. I bought the summer bundle but haven’t had time to install or play with it. I will try this afternoon and send feedback later. Mark > On 15 Aug 2022, at 9:49 pm, Paul Dupuis via use-livecode > wrote: > > FYI, > > I also just te

Re: Polygrid sorting (problems)

2022-08-15 Thread Mark Wieder via use-livecode
On 8/15/22 16:43, Mark Wieder via use-livecode wrote: On 8/15/22 16:22, Alex Tweedly via use-livecode wrote: I haven't tried csvdata or tsvdata (they're not listed in the dictionary, so I'd tend to avoid them if possible. I do see tsvData in the dictionary, but I'm getting weird errors thrown

Re: Polygrid sorting (problems)

2022-08-15 Thread Paul Dupuis via use-livecode
On 8/15/2022 7:51 PM, Paul Dupuis via use-livecode wrote: On 8/15/2022 7:22 PM, Alex Tweedly via use-livecode wrote: On 15/08/2022 20:34, 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

Re: Polygrid sorting (problems)

2022-08-15 Thread Paul Dupuis via use-livecode
On 8/15/2022 7:22 PM, Alex Tweedly via use-livecode wrote: On 15/08/2022 20:34, 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')

Re: Sorting [was: Polygrid sorting]

2022-08-15 Thread Paul Dupuis via use-livecode
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'

Re: Polygrid sorting (problems)

2022-08-15 Thread Mark Wieder via use-livecode
On 8/15/22 16:22, Alex Tweedly via use-livecode wrote: I haven't tried csvdata or tsvdata (they're not listed in the dictionary, so I'd tend to avoid them if possible. I do see tsvData in the dictionary, but I'm getting weird errors thrown from the widget when I try to use it. May still be ex

Re: Sorting [was: Polygrid sorting]

2022-08-15 Thread Bob Sneidar via use-livecode
Datagrids have this feature, so yes, I would expect there to be some way to specify what kind of sort you want to do. But it would have to be on a per column basis. But if you are sorting the text yourself, you can use the syntax: sort lines of tText by item n of each. I don't think any assum

Re: Polygrid sorting (problems)

2022-08-15 Thread Bob Sneidar via use-livecode
I think they are trying to be consistent with datagrid terminology, perhaps thinking that a tabular data object has become a new class of objects. Bob S > On Aug 15, 2022, at 16:22 , Alex Tweedly via use-livecode > wrote: > > > On 15/08/2022 20:34, Paul Dupuis via use-livecode wrote: >> So

Sorting [was: Polygrid sorting]

2022-08-15 Thread Alex Tweedly via use-livecode
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

Re: Polygrid sorting (problems)

2022-08-15 Thread Alex Tweedly via use-livecode
On 15/08/2022 20:34, 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

Re: Polygrid sorting

2022-08-15 Thread Paul Dupuis via use-livecode
On 8/15/2022 4:55 PM, Mark Wieder via use-livecode wrote: On 8/15/22 13:12, Paul Dupuis via use-livecode wrote: So I see that the Summer Bundle of widgets in the store has a note that says "Latest update 1.0.19: 11 August 2022" However, the Download button says "Version 1.0.0". Does anyone kno

Re: Polygrid sorting

2022-08-15 Thread Mark Wieder via use-livecode
On 8/15/22 13:12, Paul Dupuis via use-livecode wrote: So I see that the Summer Bundle of widgets in the store has a note that says "Latest update 1.0.19: 11 August 2022" However, the Download button says "Version 1.0.0". Does anyone know how to update the widget set to 1.0.19 or how to update

Re: Polygrid sorting

2022-08-15 Thread Paul Dupuis via use-livecode
FYI, I also just tested on a MacBook Air, M1, running Monterey with LC9.6.8 and the version 1.0.0 of the Summer Bundle widget packs and the PolyGrid and my sample stack displayed for me at 10, 100, and 500 columns and rows. On 8/15/2022 4:01 PM, Mark Smith via use-livecode wrote: Hi Paul,

Re: Polygrid sorting

2022-08-15 Thread Paul Dupuis via use-livecode
I just tested on macOS Mojave (10.14) on an Intel MacBook Pro and the PolyGrid and my sample stack work as expected. Tried 10, 100, and 500 columns/rows. Now I have to find the MacBook Air with Monterey and see... 8/15/2022 4:01 PM, Mark Smith via use-livecode wrote: Hi Paul, I downloaded y

Re: Polygrid sorting

2022-08-15 Thread Paul Dupuis via use-livecode
So I see that the Summer Bundle of widgets in the store has a note that says "Latest update 1.0.19: 11 August 2022" However, the Download button says "Version 1.0.0". Does anyone know how to update the widget set to 1.0.19 or how to update a single widget? On 8/15/2022 2:29 PM, Paul Dupuis

Re: Polygrid sorting

2022-08-15 Thread Paul Dupuis via use-livecode
Okay, I built the stack and tested it under Windows 10. The 3 beeps are intentional. It is to let me know when it is done as some test with 500+ columns/rows takes a while. It does display under LC9.6.8 (64 bit) on Windows 10. Now I have to go try it on macOS? On 8/15/2022 4:01 PM, Mark Smi

Re: Polygrid sorting

2022-08-15 Thread Mark Smith via use-livecode
Hi Paul, I downloaded your sample stack, put 100 into the Columns field, heard 3 audible beeps but no data (or PolyGrid) appeared. There is data in the pgcolumnnames and pgdata custom properties (so those values were defined). It’s just the grid that did not appear. Thinking it might be my lapt

Re: Polygrid sorting (problems)

2022-08-15 Thread Paul Dupuis via use-livecode
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 delimit

Polygrid sorting

2022-08-15 Thread Paul Dupuis via use-livecode
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 ca