InfoQube IM - Community

Submitted by cnewtonne on 2010/10/11 10:02

Hi all,

I spent 2 days last week putting IQ to the test to migrate some of my work via exporting from my current ListPro program. Once thing In noticed as I started manipulating rows around via move/delete/copy/paste in the grid, is that even though the grid clearly showed me that the rows got affected fine by the operations, hitting F5 showed a different story. Rows that I deleted were not actually deleted. Rows that seems to have moved, did not actually move.

This db that I was testing with contained 2500 rows. Both the order and hierarchy matters the most as it described a very specific procedure. My concern is that IQ did not respect this even though the gird showed that it did. The presence of a refresh function concerns me as am not sure what the expectation is from the user!

Am I supposed to refresh everytime I perform an operation on the rows? I do this hundred of times a day and having to refresh to make sure what I see is exactly what am I getting is too much of an overhead. The UI should at any point of time reflect the status of the db where all changes are committed and displayed in the UI instantaneously.

Am I missing anything here?

Thank you.

Comments

Hi,

Thanks for putting IQ to test. At its core, IQ is item based, and as such allows display of these items in great many ways. A consequence, is that items don't show where you expect them. This page can be useful

Also, 2 features will be fixed in v0.9.27 (we're working on v0.9.26) :

Manually sorted main items is not saved (only sub-items)
Sub-items which also meet the grid criteria sometimes show up as top level items

Autorefresh is not yet implemented - I'm not sure what exactly that means (someone else can explain in more detail) but neither move nor delete should be affected by that. The calendar is currently being worked on - I think auto-refresh may be due after that.

Anyways, if you move something - and it changes back again after refresh - there's definitely something funny going on. What are your hierarchy settings? - if you could give more details it would be helpful (check Menu: Grid >Hierarchy >Full Hierarchy and report settings.)

BTW, IQ calls a row an 'item' so I'll use that term from now on

> Rows that I deleted were not actually deleted. Rows that seems to have moved, did not actually move.

Neither of these should happen. What can happen is that, depending on hierarchy settings, an item (which meets the grid's source requirements) will show at top level and at a lower level in the hierarchy.

Re you deleting an item - were you shown a dialog with the option to remove from current grid or remove it from all grids ? What did you choose? Again just trying to pin down the problem - neither should allow the item to continue to show in the current grid.

Ticking (1) Menu: Grid >Save Item State is helpful if you need to refresh a lot (saves the state of the hierarchy). Others that affect grid display are

2) Menu: Grid >Filter applies to sub-items

3) Menu: Grid >Sort applies to sub-items

- none of these should be causing these problems though...(#2 could cause items to 'disappear' if the item doesnt meet the filter)

I would recommend trying an operation, check results, refresh and if there is a problem, to report it giving as many details as possible.

[quote=Tom]

Autorefresh is not yet implemented

[/quote]

Thanks for your reply Tom.

Auto-refresh is partly enabled and toggled ON in Grid >> Properties

Sorry about that Pierre,

I actually looked for something like that and missed it, also seems I havent tried it yet

it's Menu: Grid >Properties [Select Grid] >View >Grid auto-updates

@cnewtonne, I hadnt thought of the 'moving-to-make-a-manual-sort' scenario.

I see you started a thread about manual sort but it got sidetracked by a bug related to moving items in hierarchies Create a user defined ordered hierarchy with no sorts whatsoever

The first few posts talk about the (current) problems of trying to make a manual sort and give a couple of workaround ideas

To manually sort TLI, you can use the new renumber feature:

Add a number column to hold the order #
Collapse to show only TLI (CTRL+1)
Select the number column (right-click on header >> select
Right-click on selected cells >> Renumber

Then in the grid source Sort Box, enter the same number field

HTH !

[quote=Pierre_Admin]

To manually sort TLI, you can use the new renumber feature:

Add a number column to hold the order #
Collapse to show only TLI (CTRL+1)
Select the number column (right-click on header >> select
Right-click on selected cells >> Renumber

Then in the grid source Sort Box, enter the same number field

HTH !

[/quote]

Yes, this is nice and I've use it to renumber / resort a number of lists. Thanks !