InfoQube IM - Community

Submitted by David_H on 2017/01/20 20:08

When performing searches for items that are child items, search always finds the items, but the "Shown In" column typically doesn't displays the grids in which they actually exist as child items (since they usually don't a value for the grid/s since they are a child item).

Is there a way for search to have the "shown in" column display grids where the items exist as child items? After all, they are "shown in" those grids, aren't they :-)?

Thanks

Comments

Hi David,

Grids are dynamic in nature, so keeping track or what items are displayed is not always easy, keeping the performance as the number of items in the database increases.

With the new Item Home feature (Item Home), I'll be able to improve this.

Pierre_Admin

IQ Designer

Thanks Pierre. I notice that when searching for an item that..

1. Is assigned to Grid X that is set to Outline display mode.

2. Has a value that matches the source value of Grid X.

3 Is a child item.

...that the "shown in" column still does not show "Grid X". But I'd have thought it would, since the item has a value that matches the source value of the grid. So I guess "shown in" ONLY shows grids in which the item appears as a TLI?

Thanks again.

[quote=David_H]

Thanks Pierre. I notice that when searching for an item that..

1. Is assigned to Grid X that is set to Outline display mode.

2. Has a value that matches the source value of Grid X.

3 Is a child item.

Thanks again.

[/quote]

If the item is visible after a refresh, it'll appear in the "shown in" column. If it's not, it won't appear there. So currently the "shown" in column literally only shows what's shown, nothing else.

[Edit : the column filters don't have any effect on the "shown in" results though. Only the filters from the source bar. Unless I'm mistaken, but that's what I've witnessed in the last few years.]

Interestingly, I just tested what I thought I knew, but the result wasn't exactly what I thought.

The right grid for a newly created subitem (not meeting the source per se, nevertheless not filtered out) appeared in the "shown in" column after a search. I didn't think it would.

[quote=Armando]

[/quote]

[quote=Armando]

Interestingly, I just tested what I thought I knew, but the result wasn't exactly what I thought.

The right grid for a newly created subitem (not meeting the source per se, nevertheless not filtered out) appeared in the "shown in" column after a search. I didn't think it would.

[/quote]

@Armando, your first statement is correct, not the second

The "Shown In" column means just that... the last time the grid was used, was the item shown in it or not. It has nothing to do with fields assigned, TLI, etc... (actually, it is whether the item was loading into the grid or not)

To help on this recurring question, in v93, I'll add a displayed column selector:

Grids
Fields
WikiTags
Home
Match field (i.e. current Details view)

HTH !

Pierre_Admin

IQ Designer

[quote=Pierre_Admin]

[quote=Armando]

[/quote]

[quote=Armando]

Interestingly, I just tested what I thought I knew, but the result wasn't exactly what I thought.

The right grid for a newly created subitem (not meeting the source per se, nevertheless not filtered out) appeared in the "shown in" column after a search. I didn't think it would.

[/quote]

@Armando, your first statement is correct, not the second

To help on this recurring question, in v93, I'll add a displayed column selector:

Grids
Fields
WikiTags
Home
Match field (i.e. current Details view)

HTH !

Pierre_Admin

IQ Designer

[/quote]

Yes, I know my first statement is supposed to be correct... That's what I thought, but I decided to test it nevertheless.

When I tested, I was able to see the grid's name in the "shown in" columns for items that weren't "shown" yet (they're under some parent, but not currently shown -- not because of the filter but because the hierarchy hasn't been expanded). Maybe that's because they'd been show in that grid at some point, between refresh, and the grid had never been closed and reopen in the mean time. Hard to explain, but I'll check that later if I have the time.

[quote=Armando]

Yes, I know my first statement is supposed to be correct... That's what I thought, but I decided to test it nevertheless.

[/quote]

That's what confused me as well when I did some testing. I just tested it again - collapsed a grid, then refreshed it. Even made sure to close it. Then ran the search and strangely the grid still showed up for the item in the "shown in" column. In fact, nothing I can do can stop the item from showing up (collapse, refresh, close grid etc) even though apparently it shouldn't. I've even tried closing and reopening the search grid.

I thought maybe it was that once a search found an item, that subsequently collapsing the grid refreshing etc made no difference. But testing it on a completely different item it works exactly as Pierre says it should, if I collapse the grid and refresh it the shown in column does not list the grid on subsequent searches.

So like you I don't find it to be always behaving as Pierre describes. And FWIW the testing I performed is on items in the same grid, with the same parent, and both also share the source value for the grid. Yet a search on one shows the grid in the "shown in", but not for the other one.

If it shows in "Shown in", then the item was loaded (though maybe not visible) the last time the grid was saved.

If the item meets the source, it is quite possible that it is loaded, even if it is hidden under a collapsed parent. This is because of the way grids are loaded and hierarchy created.

If you can reproduce it in the sample app, send it over and I'll look into it !

Pierre_Admin

IQ Designer

Pierre, that's great. Would it be possible to add ItemParent and ItemGParent columns?