InfoQube IM - Community

Submitted by Jon on 2010/10/14 11:03

I am confused about the "Sort" option listed under "Manage Grids." Am I correct in assuming that all I have to do is type in the name of a field, and the grid willl always be sorted on that field? If so, I must be doing something wrong. It does not work here.

Thank you for your help.

Jon

Comments

2nd Attempt :)

That reflects what's in the sortbox - which is on the same 'toolbar' as the source filter, on the right-hand-side (#2 in screenshot here)

I know the sortbox only works when the [A/Z] button to the left of it is clicked (#1 in screenshot here)

The other thing that could affect things is if

Menu: Grid >Sort applies to Sub-items

is turned off

Also if you have the sortbar on the sortbox doesnt work (by design). See 5. Sorting and Grouping Items for descriptions of both....

It's no wonder Jon is confused.

[quote=jan_rifkinson]

It's no wonder Jon is confused.

[/quote]

I agree there especially with regard to the two different sorting methods

Pierre,

I dont think the benefits of having two sorting methods outweigh the complexity it brings to the programme (in terms of having to explain how things work).

But then I never use the Sortbar any more...

I know you could say I'm biased (I dont use the sortbar:- partly because I forget which is active; the Sortbox covers my needs; this below is my idea) - but,

I think using the Sortbar (or a replacement) as a GUI for the Sortbox would be the ideal user friendly high powered sorting method.

v0.9.27 will bring a more Ecco-like grid display, which should make things more intuitive

HTH

[quote=Pierre_Admin]

v0.9.27 will bring a more Ecco-like grid display, which should make things more intuitive

HTH

[/quote]

Thanks Pierre,

I'd better leave you in peace then ;-) (sorry, I'd forgotten what the response was the last time I suggested it)

Tom:

Thank you for taking time to explain this. However, I am not referring to sortbox or the sortbar. I cliick on the "Manage Grids" icon on the toolbar. On the right, under "Data" is the option to "Sort:" This is what I am confused about (unless what you were explaining has something to do with this - then I am REALLY lost). My assumption is that the user can type in the name of a field from which the grid will be sorted when opened. If my assumption is true, I cannot get this to work. Also, if the field name is supposed to be typed here, wouldn't it be better and more consistent to have a drop-down list?

Jon

[quote=Jon]

I cliick on the "Manage Grids" icon on the toolbar. On the right, under "Data" is the option to "Sort:" (...) My assumption is that the user can type in the name of a field from which the grid will be sorted when opened.

[/quote]

Your assumption is correct. Setting a field name there is exactly the same as setting it in the SortBox

After setting it, the grid SortBox will update. Apparently, a refresh is required (F5)

It is best to use the SortBox (Alt-S to view it) as there is now a Sort ON/OFF button and the Manage Grid dialog hasn't been update to include it.

HTH

[quote=Tom]

That reflects what's in the sortbox [...][/quote]

I probably could have emphasised that more :-)

It's actually quite powerful, default sort is ascending but you can also sort decending and by multiple fields.

An example from the linked manual page above:

item, itemCreated, itemModified desc :

grid will display items sorted in item (field) ascending alphabetical order, followed by (in terms of priority), the date the item was created in ascending order, and the date the item was modified in descending alphabetical order. Note that "asc" (ascending is not specified as it is the default sorting option)

Got it. Thank you all for your help.

Jon