Submitted by Cyganet on 2022/12/01 07:51

Hi Pierre,

Is there a way to select an item, and then open it in a new or scratch grid, so I can see it with all its parents and children, but without the grid source, filter and sort criteria of the grid where I found it?  In effect, a special kind of Hoist, because Hoist now keeps all the info from the source grid.  I tried using the omnibox search with its itemID but that didn't work.

 

Thanks!

Comments

Hi Cyganet,

A command could be added of course, but I can think of two easy ways to do this already:

  1. Use Live-Search to find the item. Select it and click View results
  2. Mark the selected item (Item > Mark). Set a grid source to ItemsMarked or use the Properties pane and right-click on the Marked Items heading > View Marked Items

Building on this request, my next use case for zooming into specific item hierachies.  I want to list all items having a particular item as grandparent.  So I set the grid source as [ItemGParent] = "ABC", which works like a charm except that "ABC" is non-unique. Is there a syntax for replacing "ABC" with the ItemID of the item I'm looking at?  Just putting in [ItemGParent] = 1582 doesn't work.

I looked in the IQDoc, and saw the following about MainParent, but in this case I am looking at the GParent.

<Source>SELECT ¯Items.ParentID AS IDMainParent, ¯Items.ID AS ItemID FROM ¯Items;</Source>

Can I do something similar?

 

Thanks!

 

Hi Cyganet,

You can of course do a similar query for IDGParent:

  • name: IDGParent
  • Type: Number
  • Options: <Source>SELECT ¯Items_1.ID AS ItemID, ¯Items.ParentID AS IDGParent
    FROM ¯Items AS ¯Items_1 INNER JOIN ¯Items ON ¯Items_1.ParentID = ¯Items.ID;</Source>

Somehow, both of these fields do not show in the Properties pane, even if you specify that it should. But it works fine as a grid source (i.e. IDGParent=637)

HTH !

Pierre_Admin
IQ Designer

How do I ?