Replies: 3 comments 3 replies
-
|
What's a situation where sorting by the internal data value would be preferred? I'm trying to think of one (quickly), but everything I'm coming up with (so far) would be better sorting by the result after formatting is applied. |
Beta Was this translation helpful? Give feedback.
-
|
Ahhh. Looking at the linked examples shows the problem:
The problem seems to be our current approach is changing the underlying data type (eg number to string) when applying formatting. So what should (for example) be a simple format change to adjust the number of decimal places in numbered output changes the sort order completely. Sounds like a bug we could potentially fix in a 3.13.1 follow up release. 😄 |
Beta Was this translation helpful? Give feedback.
-
In fact, there is a workaround for real numbers #3603 (just don't use a function that returns a string like |
Beta Was this translation helpful? Give feedback.
-
|
Let me throw a (potentially-related) rock in the pond... I think we are talking about the sort order of the rows viewed in the Browse Data tab. True? My new idea is that I sometimes feel the urge to sort the rows of the Execute SQL tab as well. I would find this useful to get a sense of, "What fraction of rows have a value less than 5..." without constructing a whole new query. I have always figured that DB4S displays the rows sorted by the BUT... Perhaps we could address both questions with one mechanism. I'll throw out this idea (without much thought behind it), that basically would add a third choice to the options above:
This needs lots more thought (and thus shouldn't hold up 3.13), because as I was typing this, I came up more questions:
Thanks for listening. |
Beta Was this translation helpful? Give feedback.
-
This seems unusual logic, and as other programs don't do this, doesn't seem intuitive to the user. I prefer to keep things 'traditional' and 'expected', as it leads to less support issues. If the original order is required again, the user can simply rerun the query?
This is my point - so many apps use the up and down arrows, people know what they are .. if we start using double-arrows or blue arrows then green arrows (for example), they're not going to immediately know what these are for.
Obi-Wan: "I felt a great disturbance in the Force, as if millions of voices suddenly cried out in terror and were suddenly silenced. I fear something terrible has happened." But this is only my opinion .. one vote out of many. |
Beta Was this translation helpful? Give feedback.
-
|
... and that's why I included "Is this a dumb idea?" as an option for opinions. :-) I just voted to retain the 3.12 behavior. Thanks! |
Beta Was this translation helpful? Give feedback.
Uh oh!
There was an error while loading. Please reload this page.
-
As reported in #3603 and #2149, when you apply a display format, the sort order starts to use the displayed text and no longer the internal column data. Ideally, the user should be able to select the behaviour, but that will require development effort, translations and possible bugs, so it won't happen for the next v3.13. It's easy, though, to just change the behaviour, so the internal data value is always used, via this simple change:
That means that we could include this change in 3.13 if it is considered the most general and expected behaviour for the majority of users.
Consequently, I'd appreciate it if many users vote for their preference, so we can decide what to do for the imminent v3.13.
4 votes ·
Beta Was this translation helpful? Give feedback.
All reactions