Submitted by David_H on 2018/08/19 23:02
 I have a couple of grids where I am experiencing something strange and am not sure why or if I did something inadvertently to cause the issue. I have a grid where if I open it, it shows 0 items. I just created the gird the other day and it should only have 1 item.
 
So if I search for the item it instantly shows up in search. When I then click on the item from search the grid where I first expected to find it now opens and says (H1) on the tab, with the item appearing as it should, and the grid evidently hoisted on the item.
 
If I turn hoisting off, the item disappears. This confuses me, because in my mind hoisting works the opposite way, hoisting an item makes other non-hoisted items disappear. Whereas a non-hoisted grid should show all items. So why is the grid empty when hoisting is turned off, and the item only shows up when hoisting is turned on, on that item, which can only be found via search? I'm trying to figure out how it would even be possible for a user to recreate this scenario?
 
To add a little more info, if I initially open the grid and turn hoisting on, nothing shows up either, I assume since there is nothing to select to hoist. It's only by searching for the item and then opening it from search that the item can be found (with hoisting activated automatically). BTW, the item values shows 0 parents, 0 children, 0 siblings and shown in 0 grids.
 
Thanks

Comments

 This is not a big deal since I just corrected the issue by deleting the item and recreating it. It's more just a curiosity thing of wanting to understand internal IQ operation. Attached is a screenshot after I deleted the item. How is it even possible for an empty grid to be hoisted? What is there to hoist on?
 
 

 Well actually that didn't correct it. I deleted the old item, the closed the grid, reopened it making sure it was not hoisted to anything, and recreated the item assuming that would fix it. But now when I close and reopen the grid the new item is also gone, and once again I can only find it by searching for it, clicking on it, and then it appears in the grid and says "hoisted", same as before.
 
If I add other items to the grid, the same thing happens, I have to search for each item, and the item only shows up entirely on its own hoisted.
 
I am running the latest version of IQ (but it happened in the prior one too), and it happens regardless of display mode and context parent settings.

 OK, I think I figured it out. The source field for the grid was a text field. Changing it to a yes/no field solved the issue.
 
Pierre, please explain when you get a chance.

[quote=David_H]
This confuses me, because in my mind hoisting works the opposite way, hoisting an item makes other non-hoisted items disappear. Whereas a non-hoisted grid should show all items. So why is the grid empty when hoisting is turned off, and the item only shows up when hoisting is turned on, on that item, which can only be found via search?
[/quote]
Hi David,
Well, it isn't exactly that... 
  1. Grid (not hoisted) show items that match the source / filter criteria
  2. Hoisted grid can show any items from the IQBase, related or not to the grid
 
Pierre_Admin
IQ Designer