InfoQube IM - Community

Submitted by WayneK on 2017/07/27 11:21

This has been discussed a few times but I'm still having trouble understanding how InfoQube counts items when it loads a grid. My understanding was that InfoQube counts only items that will be displayed. It does not count collapsed subitems. However, I keep getting warnings about number of items when it seems like I shouldn't. Example follows.

1) I turn off hoist.

2) I receive warning about trying to load a grid with 1,056 items. I choose "load all items" option.

3) Grid loads and there are only 100+ items displayed (not 1,000+). In fact, the grid only contains 627 items when all levels are expanded.

So why am I getting the item number warning when only a handful of items will be displayed, and the grid contains well under 1,000 items if they were all displayed?

By the way, I'm getting the item counts from tooltips (hovering mouse over grid tab).

Wayne

Comments

The item count warning is the number of items which meet the source (and source filters). Once these are loaded in the grid, the number can change as items are arranged in hierarchy and grid filters applied.

If the display mode is Source items, Flat list with context parents off and no grid filters, the number of items should match

Pierre_Admin

IQ Designer

Pierre,

Thank you. I have to run out right now but I want to work through this and really understand it because its a serious issue for me. If I'm understanding you, the item count changes based on display mode etc. I think I need to create a sample grid with a manageable number of items then apply various modes and filters to see what gets counted. For some reason, this is not readily obvious to me.

Wayne

[quote=WayneK]

really understand it because its a serious issue for me

[/quote]

Out of curiosity, why is this so ? And why is the # column not providing useful information ?

(I rarely look at the number of items in a grid, if at all, to ensure the number is manageable, and if not, apply a more restrictive filter, such as a DateFilter)

Pierre_Admin

IQ Designer

2 different counts:

- item count on grid tab : shows the number of *loaded* & *visible* items in the grid. So if an item is shown more than once (under multiple parents), and it's visible, it will be counted as a different item each time.

(So : not counting the potentially visible items. Filtered out or items "hidden" under parents aren't counted as this wouldn't mean anything. E.g. You're in a todo list grid, and some items could be shown but are not because you've marked them as done in the past and the grid filter filters them out; they shouldn't be counted; however, if the filter is set to show them, they'll be counted.)

- item selected, in the status bar : might show the same count as the item count in the grid's tab, with one caveat : the number might be lower as counting *selected* item will not count an item more than once (e.g. if it's shown under multiple parents).

I use the count feature often too (item selected, mostly), for various reasons (like checking if 2 sets of items are consistent – generally references I need to sort, tasks that I'm transferring, )

WAYNE :

I had no filtered or "hidden" items. All levels were fully expanded. No items were selected. No items have multiple parents. That's why I don't understand why the item count doesn't match the warning I was getting. When I went to flat view, the item count increased to over 2,000 and I don't know why.

ARMANDO :

Maybe a screenshot would help.

In any case, I was just explaining where the number come from, normally. It's still possible there's a bug. I'll keep my eyes open. (I rarely open grids with thousands of items though)

Looks like a couple of my posts above got deleted. I'm systematically working through this using different display options. Still not done but so far I haven't found an explanation for the warnings I'm getting. This is for my own benefit because I still find the various combinations of display options to be confusing. As I said, I want to understand this because it could affect how I create grids. I have grids with several thousand items. What most concerns me is not just the warning, but that in some cases the grids were loading with subitems missing. That's of great concern to me.

1) I've been getting item count warnings because trhe gid was trying to load 1,029 items. That seemed like a low count to get a warning for since it's been stated that grids can display up to 20,000 items.

2) I just created a grid with over 2,200 items and all were assigned to the grid. Repeatedly loaded the grid by hoisting / unhoisting and was unable to trigger the warning.

I'm not saying anything is wrong. I'm saying I don't completely understand what's going on.

It's aggravating personally because I'm 67 now and I can definitely see the difference. I can't hold as many things in memory at the same time, so I have to rely more on explicitly laying things out in writing before I can grasp it. Then I forget it again (ugh).

Wayne

Hi Wayne,

I can certainly raise the 1000 limit before a warning is shown. It is there more for convenience to users than a "real" warning.

Perhaps in the back of my mind, a friendly reminder to users... "Do you really need > 1000 items in this grid ? Will you often require all those items to be there ? Why not filter out non-relevant ones..." That kind of things.

You probably already know, grids are just display devices, showing a sub-set of items in your IQBase. They don't hold anything. They are like you TV set, or your web browser.

For this reason, grids have extensive filtering capabilities (source, filter, alpha-filter, date-filter, grid filter, column filter, hoist, etc) so they show what you really need to see at that moment, not too much more

I rarely have more than 100-200 items in a grid. Whenever it goes above that number, I tend to filter (source filter and / or date-filter set to year-view). If I want to see more, live-search or change date filter range will do the trick

Just my 2 cents

Pierre_Admin

IQ Designer

[quote=WayneK]

Looks like a couple of my posts above got deleted.

[/quote]

Sorry Wayne, I'm guilty!

I wanted to reply and I completely inadvertently edited one of your post (admin rights)!

First mistake in 8 years though. Please forgive me (Wayne.. and Pierre! Maybe Pierre has access to some history, but... I doubt so.)

You must've wondered what happened -- what's written in that "deleted post" is my answer to your now deleted post (only one though).

Let me try one last thing and then I'll call it a day. I've been going round and round with this and can't quite figure out what's going on. I started out trying to understand the grid item loading warnings I was getting. To really understand that, I backed up to go over display modes again, and that's where I'm stuck right now.

I've gone through the Grid Display Modes help section several times. It says this: "In addition, for each mode, context parents can be shown or not, making a total of 6 displays. We'll look into each of these and their typical use case." It then displays a grid in outline mode but offers no explanation of how the parents setting works with that display mode. And this is exactly where I'm having my problem.

Case #1

Display mode: Outline; Parents: on. I have a TLI named "InfoQube" which has numerous subitems going down 3 or 4 levels. With the settings shown, it does not display most of the subitems of InfoQube, It appears that its only showing subitems that have been explicitly assigned to the grid. It's displaying the "InfoQube" Item only as a context parent for the subitems assigned to the grid.

"InfoQube" has been assigned to the grid, so why won't it display? And being a TLI, why doesn't it display all its subitems?

Case #2

Same as above, except Parents are turned off. Now InfoQube DOES display correctly with all its subitems. But those subitems that have been assigned to the grid, also display as separate items with no parents. Thus, they display twice: as a subitem under InfoQube, and as standalone TLI's.

I can't figure out why it does this. Each of these items has only one parent. Why don't they display under their parents within the InfoQube hierarchy? Why do they display as TLI's when I'm in outline mode? I'd understand if it was a flat list.

Wayne

Hi Wayne,

Regarding outline view with context parents, it is not shown as it doesn't add much more... you'd only see the same display as eCars Ltd and EF Consulting do not have parents. If they had, they would simply be displayed with no impact on the display

A screenshot of each case would help, as I do not know which items have the grid source and not.

Case 1: I'm confused... is InfoQube a context parent or a item meeting the grid source ? I suspect from your description that it is just a context parent (to be sure, turn off context parents to see if it is displayed). As such, it is normal that it does not show all its sub-items, only those that meet the grid source. This is expected since the purpose of this grid is to show items that have the grid source. If you want to see all sub-items of InfoQube, either set InfoQube have the grid source (or right-click on InfoQube and select Show all sub-items).

[Edit] A screenshot is required as I can't make any sense of your 2 cases...

Sorry

Pierre_Admin

IQ Designer