Mark,

Without some reasonable amount of work, I can't make it so individual
columns remember their settings.

Too bad. I didn't consider the effort it might take. Presumably the effort is because it (the last seen direction of each column) would need to be remembered per-user, perhaps in a cookie?

The problem is that when sorting in a database, sorting most recent
first on a number (ie date) corresponds to sorting from z to a on a
string. I'm sorting the same 'direction' according to the database,
but it looks like the opposite to you.

That I understood.

I don't think it would have been of nearly as much concern if the columns each remembered their "last seen" direction; which is the only reason I tossed that idea into this topic.

I've made the following change on the members page. If it's at least
sufficient for now, I'll propagate it elsewhere. ... Please let me
know what you think.

I think it is fine now. I primarily didn't like having a direction change in one column affect the direction of another.

Shal

On Fri, Jun 21, 2019 at 04:55 PM, Gerald Boutin wrote:

I am still confused on what the "Delivery" sort is based on.

It's the digit that is stored as part of their record in the group database.  If you export your members list, you'll see them there.  "Email Delivery(0=Single,1=Plain Digest,2=Special,3=None,4=Full Digest,5=Summary)"

Duane

Mark,

Thanks for the update and clarification.

I am still confused on what the "Delivery" sort is based on. Possibly last character of string? For example, when clicking on the Delivery column, I see the order as follows: Single / Special / No Email / Full Digest / Summary

--
Gerald

Yay, works perfectly now!
--
J

Messages are the sole opinion of the author, especially the fishy ones.
My humanity is bound up in yours, for we can only be human together. - Desmond Tutu

Members always defaults to Joined/Applied (unrestricted/restricted groups): newest - oldest
no matter which view (Display Name, Email, Delivery, or Joined/Applied) or sort order was last chosen.

Then clicking on Display Name, Email, or Delivery now yields A-Z sort;
and clicking on Joined/Applied:
if currently sorted, yields the reverse
if currently not sorted, yields newest - oldest.

Having it remember last view and sort would be preferred, but this is fine for me.



-- .--- .--.

On Fri, Jun 21, 2019 at 07:56 PM, Mark Fletcher wrote:

Now all columns default to a-z sorting, except Joined, which defaults to most recent first.

That works for me.

Thanks Mark.

Andy

That sounds perfect and I will check it out later.

--
J

Messages are the sole opinion of the author, especially the fishy ones.
My humanity is bound up in yours, for we can only be human together. - Desmond Tutu

On Fri, Jun 21, 2019 at 10:30 AM, Andy W wrote:

I agree with the steps you execute and the results you see, but that still boils down to the fact that the initial click on a column heading (after arriving at the member list or after sorting by another column) sorts the list in reverse alpha (Z-A). 

Exactly, just tested this and Andy took the words right out of my mouth. This is still just the original problem (or "sin" ;)
 
--
J

Messages are the sole opinion of the author, especially the fishy ones.
My humanity is bound up in yours, for we can only be human together. - Desmond Tutu

Hi Shal,

On Fri, Jun 21, 2019 at 06:16 PM, Shal Farley wrote:

Is that what you expected and want? Not me.

I agree with the steps you execute and the results you see, but that still boils down to the fact that the initial click on a column heading (after arriving at the member list or after sorting by another column) sorts the list in reverse alpha (Z-A).  All we have asked for is that it sorts A-Z.

Hope that helps.

Regards,
Andy

On Fri, Jun 21, 2019 at 04:38 PM, J_Catlady wrote:

The table is ordered by one column at a time. I must be misunderstanding you.

My thoughts exactly.

Andy

On Fri, Jun 21, 2019 at 08:10 AM, Shal Farley wrote:

As of last night's test the astonishing (to me) answer was "the other columns copy the ordering of the column you changed".

Wow, that would be astonishing, alright. I don't even understand how this is conceivable. The table is ordered by one column at a time. I must be misunderstanding you.
 
--
J

Messages are the sole opinion of the author, especially the fishy ones.
My humanity is bound up in yours, for we can only be human together. - Desmond Tutu

On Fri, Jun 21, 2019 at 07:18 AM, J_Catlady wrote:

Correct. The date column is ordered by reverse chrono.

Well, unless Shal is seeing something relating to Mark's latest fix that we haven't yet seen.
 
--
J

Messages are the sole opinion of the author, especially the fishy ones.
My humanity is bound up in yours, for we can only be human together. - Desmond Tutu

On Fri, Jun 21, 2019 at 07:17 AM, J_Catlady wrote:

chrono (not reverse chrono) for the alpha columns.

typo: I meant "alpha (not reverse alpha) for the alpha columns"
 
--
J

Messages are the sole opinion of the author, especially the fishy ones.
My humanity is bound up in yours, for we can only be human together. - Desmond Tutu

On Fri, Jun 21, 2019 at 01:50 AM, Andy W wrote:

As it is now, Joined/Applied has mysteriously switched to oldest first.

I don't see this. If I go to a member list, the default order is the most recent join/applied entries at the top of the list.

Correct. The date column is ordered by reverse chrono.
 
--
J

Messages are the sole opinion of the author, especially the fishy ones.
My humanity is bound up in yours, for we can only be human together. - Desmond Tutu

On Fri, Jun 21, 2019 at 06:17 AM, Gerald Boutin wrote:

To summarize further, one click to change to sort of a different column. Further clicks on the active column will toggle the sort direction for that column, and hence the table as well.

Exactly. And with the change of column, you would use *that column's* default sort order - i.e.: reverse only for the date ("Joined") column, but chrono (not reverse chrono) for the alpha columns.
 
--
J

Messages are the sole opinion of the author, especially the fishy ones.
My humanity is bound up in yours, for we can only be human together. - Desmond Tutu

On Fri, Jun 21, 2019 at 05:50 AM, Andy W wrote:

Hi Shal,

On Fri, Jun 21, 2019 at 05:10 AM, Shal Farley wrote:

As it is now, Joined/Applied has mysteriously switched to oldest first.

I don't see this. If I go to a member list, the default order is the most recent join/applied entries at the top of the list.

What I want is for each column to retain its own direction, independent of changing the direction of any other other column.

Agreed.  If I click the Display Name, Email or Delivery column headings, the list is sorted in reverse alpha (Z-A). All we have asked for is that to be the other way around (A-Z) to start with and if the column heading is clicked for a second time, it goes Z-A.

Regards,
Andy

I agree with what Shal said about each column remembering its own direction. That resolves the issue of the "to start with" quandary. It will be whatever you left it at last. What it starts out at is immaterial.

To summarize further, one click to change to sort of a different column. Further clicks on the active column will toggle the sort direction for that column, and hence the table as well.

Life gets more complicated depending on how many sub-levels one wants to incorporate for breaking ties in the primary column. Ideally, it might be all columns with the last used column being the secondary key and next last used column, the next key and so on. In reality, probably one sub-column sub-level should be enough.
 
--
Gerald