Submitted by carloscadu on 2020/07/19 08:38
 Hi,
 
I'm using IQ 0.9.116pre2.
Is it possible to constrain the automatic/random sorting of grid's items after a filter (e.g. hoist, column filter) is turned off?
The problem I'm facing is:
- I spend plenty of time ordering items manually in an IQ grid.
- Then after using a filter (e.g. hoist, column filter) an adding/handling items with the filter ON, my manual ordering of the full grid is lost when I turn the filter OFF.
In the end, I'm just trying to find out a way to constrain IQ grids to sort similarly to MS Excel, which will reordering rows "permanently" only when the user triggers manually the "Sort A to Z / Z to A" commands. 
 
Thank you,
Carlos

Comments

Huh, I've never ever lost the sort order in any of my grids. Could you briefly outline the steps "necessary" to achieve this? Thanks!

Hi Carlos,
 
This should not happen. Unless you have a sort on your grid. Ensure sort is off.
 
Pierre_Admin
IQ Designer
 

I dont normally use manual sort, but, to rule out the sort settings:
 
Is the manual sort sticky at all i.e. does it survive a simple F5 refresh?
 
If not, look at your sort settings in the menu and in the grid settings under Manage Grids

This has happened to me many times and I believe I posted a thread on it a long time ago.  It usually occurs when turning off a hoist.  Having said that, I cannot guarantee that in every case I had sort properly turned off.  But I am positive that in at least some cases it was turned off and still scrambled when hoist was turned off.
 
To solve this problem, I use a sequence text column.  When I get the sort I want, I use the excellent renumber command (alt-z) to assign sequence numbers.
 
It only takes a few seconds to do this, and you will have a fail-safe system for keeping your sorts no matter what else you do.
 
This is useful even if InfoQube is working 100% correctly because it's all too easy to end up with the sort setting in the wrong position without realizing it.  By the time you find out, it's too late.
 
Wayne
Win 7, 64 bit Cyberpower Model 1, C Series (2011) 16 GB RAM
27" Samsung S27A350H, 24" ASUS VW242H  1920x1080

carloscadu

2020/07/20 13:56

Permalink

[quote=WayneK]
It usually occurs when turning off a hoist.  Having said that, I cannot guarantee that in every case I had sort properly turned off.  But I am positive that in at least some cases it was turned off and still scrambled when hoist was turned off.
 
[/quote]
 
Many thanks all of you for the replies and directions. 
For now, I will make Wayne's words mine.
I do need observing more the circumstances that the issue has appeared to report better. 
Cheers,
Carlos