Page 1 of 1

[Sugg] Sorting only according to shown values

Posted: 2006-11-09, 19:47 UTC
by Hacker
Would it be possible to add an internal toggle command to let TC sort only according to the shown values? This would be very useful for multiple column sorting.

For instance when sorting by date, TC considers also seconds even though they are not shown. Or when sorting by tc.size.Gbytes TC considers smaller size differences, too, even though the value for all files is "0".

Now if you try to use multiple column sorting, it has little effect, if the sizes aren't absolutely equal (regardless of the "0" shown in the column). With the proposed command the sort would only use the shown values, as might be expected.


Original idea from Neue Features?

TIA
Roman

Posted: 2006-11-09, 23:15 UTC
by Lefteous
This is indeed a very good idea.

Posted: 2006-11-09, 23:32 UTC
by StickyNomad
Agree, I also would appreciate such feature.

Seconds suck

Posted: 2007-03-24, 19:49 UTC
by Clo
2Hacker

:) Hello Roman !

• I support, of course!

• Sorry, I've missed that thread before…

:mrgreen: KR
Claude
Clo

Posted: 2007-03-25, 03:33 UTC
by petermad
Sorry, I've missed that thread before
Me too - support ++

Posted: 2007-03-25, 16:58 UTC
by Horst.Epp
I would like that as default behaviour

Re: [Sugg] Sorting only according to shown values

Posted: 2022-06-07, 08:21 UTC
by Hacker
Well, perhaps, 15 years later, there is a chance? :)

Roman

Re: [Sugg] Sorting only according to shown values

Posted: 2022-06-07, 08:23 UTC
by AntonyD
It looks like the time has come to lift this wonderful suggestion out of the dust again.

Re: [Sugg] Sorting only according to shown values

Posted: 2022-06-07, 08:42 UTC
by ghisler(Author)
Unfortunately I tried and failed. For example, how would you sort a partially shown date or time? or a partially shown size? Just sorting stupidly by the characters does NOT work correctly. And don't even start thinking about multiple fields together...

Re: [Sugg] Sorting only according to shown values

Posted: 2022-06-07, 09:45 UTC
by Hacker
Christian,
Can you please elaborate?
  • Valid dates or times should be treated and sorted as such. Examples of valid dates: "2022", "06.2022", "07.06.2022", "7.6.2022". Examples of valid times: "1:21", "14:28", "1 am", "02:18 pm".
  • Valid numbers should be treated and sorted as such. Examples of valid numbers: "11", "5280146251374968", "18,4385".
  • Everything else should be treated and sorted as a string.
29.17.2022 -> string
2.2022 -> date (1.2.2022)
0 -> number
0,18 -> number
1983 -> date (numbers between 1900 and 2200 could be treated as dates, or worst case, numbers)
5211 -> number
1.6.202suddenlyletter -> string
8 32 15 -> string
XV.VI.MMXXII -> date (kidding, string)
zero point eight -> string

AFAIK valid delimiters for the current locale can be provided by Windows.
This seems like a good start. What am I missing?

Roman

Re: [Sugg] Sorting only according to shown values

Posted: 2022-06-07, 10:51 UTC
by nsp
ghisler(Author) wrote: 2022-06-07, 08:42 UTC Unfortunately I tried and failed. For example, how would you sort a partially shown date or time? or a partially shown size? Just sorting stupidly by the characters does NOT work correctly. And don't even start thinking about multiple fields together...
I think you want to make it too complicated !
Let the user chose:
You could add a special marker [N][T] in Column definition or a sorting indication in the UI to fix it Default, As plain txt, Natural number...
When it is not defaulted, just use displayed text as reference.

It is very confusing to extract text in a column and sorting is not on the extracted text. Worse it is not possible to sort on what we want i.e Date.M or Time.h ... filename starting at char 8 ....

Re: [Sugg] Sorting only according to shown values

Posted: 2022-06-08, 12:32 UTC
by nsp
I would like to have sort built on top of what we see/extract and not from entire wdx_plugin.field / Strings that compose the column definition.
To make it simple i would use only what is extracted as base for comparison :
Tc.fullmane:8- -> String from fullname keep what is after pos 8
tc.writedate:1-4 -> String YYYY
tc.accessdate.M-D-Y : full datetime Field without time
tc.createddate.D.M.y : full datetime Field without time y is the same as Y meaning Year is significant
tc.createtime.h : time hour only
tc.writedate.D a Date where Y = 0, M=1, D is D and Time is 0
tc.modifieddate.h.m:s a DateTime where Date is null and Time with hms
...

As a first attempt i would just put calculated display string a sorted object.

We could probably ignore static string for comparison, about prefix and postfix this is still questionable.

We have in one software (Java) object in listview column that have a Display String and an ordered List with multiple object use for sorting, refresh URL, .... The compounded comparison is based on Comparing iteratively each object in the list using dedicated comparison method.