Submitted by Paul_J_Miller on 2018/05/29 13:44

In InfoQube there are parent/child relationships.

I would find it useful to have another type of relationship which is a reference to another item that is not a parent or a child but just a related item.  Like background information or 'see also'.

It is possible to make all the related items children of the item they are related to but this becomes messy if there are more than a few items.  The problem then becomes how to differentiate between the real children and the 'see also' children.

In normal use you wouldn’t want related items cluttering up the tree in a grid.

I wondered if it was possible in InfoQube to have a list of items associated with an item but not as children.

So I experimented.

If you define a 'Related' field as a multi-select list of 'Item [T]' then you can create a list of related items for each item in a grid in a column on the right.

Well that didn't work very well.  The list was populated from just one grid (the 'Categories' grid bizarrely), even with nothing in the 'Filter' box, I didn't know how to get it to look for items in all grids but then I remembered I have an 'All' grid which lists all items in any grid so I set the filter of the multi-select list of 'Item [T]' to filter on the 'All' grid and this worked very well.

Having a list of related items is useful but the frustrating thing is you cannot do anything with the list.  It would be nice if I could just double click on an item name in the list to be taken to that item.  I wonder if I could define something in AHK to lookup the name in the 'Omnibox' or something. Watch this space.

The 'All' grid just shows all items even if they are not shown in any other grid.  The 'source' for that grid is 'Item <> NULL' which is true for every item that exists, I haven't tested it on items which don't exist.   LOL

It might be useful if there were a command which was available in a context menu (right click) or assigned to a key (or both) which was 'lookup the word at the cursor position in the Omnibox'.

 

Comments

It's on my todo list to add a related items feature, in fact the database is already for it... It could be shown in the properties pane, alongside siblings etc. Grids could also show these in a column or with children.
 
For now, could you not select the items > Copy item IDs and create a hyperlink to these in your related items field (ctrl -k, paste)
 
Pierre_Admin
IQ Designer
 

Paul_J_Miller

2018/05/30 16:13

In reply to by Pierre_Admin

[quote=Pierre_Admin]
For now, could you not select the items > Copy item IDs and create a hyperlink to these in your related items field (ctrl -k, paste)
 
Pierre_Admin
IQ Designer
 
[/quote]
 
It seems that if you do this to the field displayed in a column in the grid it works correctly, if you try and do the same thing to the field in the 'Properties' pane then it gets messed up.
 
But at least I know how to do it now. 
 

I made a mistake, when I transferred this from my sandbox notebase to the real notebase it didn't work.  That's because I had been doing some experimentation in the sandbox previously.
 
I cannot use the 'All' grid for the selection of related items because it has a complex 'source' and for use as a filter it needs to be a simple field.
 
Also I don't know what is going on but I cannot turn the item names into links, it doesn't work for some reason.  When I select the name of the related item and press Ctrl-K the dialog comes up with the WikiTags which are in the categories field as the link text.
 

Tom

2018/05/30 13:55

In reply to by Paul_J_Miller

Re the 'ALL' grid:
if you remove the source from a grid (leave field blank), it will show all items. Probably easiest to do it in manage grids dialog-window.
 
I dont know will this work for your needs, this just in case you didnt already know.

Paul_J_Miller

2018/05/30 16:03

In reply to by Tom

Good idea, I should have tried this.
 
However it still doesn't give me a field to filter on.
 
If I erase the filter in the item selector in the 'List of items pop-up' it ought to bring up all items instead of all items from just one grid but it seems that is not the way it works ... oh well
 
Thanks anyway, I will do it this way in future
 

In v114b:
 
Related Items
  • Related items are shown in the Properties pane, as a hyperlink
  • Right-click on the header to show all related items in the Scratch grid
  • The number of related items can be shown as a grid column
  • To add related items, simply mark items (Shift + Ctrl + M) and right-click on the Related Items header and select Add Marked Items
This is the first cut at a new type of link. More to come. Comments welcomed !
 
Pierre_Admin
IQ Designer
 

Pierre_Admin

2019/09/11 21:50

In reply to by Pierre_Admin

I've started added Related Items to the documentation section of the Welcome to IQ database...
Wow, it should help users immensely !!  
 
Pierre_Admin
IQ Designer
 

Paul_J_Miller

2019/09/12 06:29

In reply to by Pierre_Admin

That was quick !!!     ...   only one year and three months
 

Pierre_Admin

2019/09/12 13:18

In reply to by Paul_J_Miller

[quote=Paul_J_Miller]
That was quick !!!     ...   only one year and three months
[/quote]
Yeah... 1 day of work after more than a year of procrastination !
That summarizes it...
 
Pierre_Admin
IQ Designer
 

Paul_J_Miller

2019/09/13 05:47

In reply to by Pierre_Admin

From the documentation it looks powerful.
 
I'm looking forward to getting hold of it but at the moment 114a is what I have.

Pierre_Admin

2019/09/13 07:28

In reply to by Paul_J_Miller

Hi Paul, 
 
re: v114b
Indeed, I wanted v114b to include the Related Items documentation, so I wrote it first and synced the Welcome to IQ file with the web site
Next version should be online today
 
 
Pierre_Admin
IQ Designer
 

Paul_J_Miller

2019/09/13 13:08

In reply to by Pierre_Admin

Thank you for this feature, it is useful as it stands but it would be more useful if I could have a column containing related items listed as hyperlinks, similar in appearance to the 'Tags' column.  But it isn't too much trouble to go to the 'Properties' pane to do this.

Pierre_Admin

2019/09/13 14:12

In reply to by Paul_J_Miller

[quote=Paul_J_Miller]
it would be more useful if I could have a column containing related items listed as hyperlinks
[/quote]
Indeed, and it is planned
 
If you want a smaller pane than the Properties, you can open the More Info pane, it also shows related items
 
Pierre_Admin
IQ Designer
 

Paul_J_Miller

2019/09/13 18:21

In reply to by Pierre_Admin

Yet another feature of InfoQube which I had missed.
 
There seems to be a problem moving the 'More Info' dialog to a second screen.  It seems reluctant to leave the main program window.
 
I will take a good look at this dialog box and see if it is useful.  Thank you.