InfoQube IM - Community

Submitted by jimspoon on 2020/04/01 20:48

When a grid filter returns > 2000 items, and I select to have the first 2000 displayed, it would be nice if the items displayed were the 2000 most recently modified items. Or perhaps it would be nice to have some other user-specified default criterion for determining which 2000 items are the first displayed. For me though, "most recently modified" would be most useful.

Comments

Hi Jim,

Improvements are needed to manage the display of a large number of items.

I'm considering automatically loading 1000 items and showing a button at the bottom to show the next 1000, much like we see on many web sites

If you want to see recently modified items, why not apply a date filter, using ItemModified. See 2. Filtering

Pierre_Admin

IQ Designer

That's what I've been doing, and it works. The date I need to put in to get >2000 items depends on how many items fit the other criteria. What really brought this to mind is, I have an "Items Modified" grid, and I wanted to sort it on the Item Modified field, descending, so the most recently modified items appear at the top. After adding some items, I noticed that my most recently added items did not appear in this view. Then I realized the reason was that >2000 items met the filter, and my most recenlly modified items were not among the first 2000 displayed according to IQ's present method. So they could not be sorted to the top. I thought that IQ might be displaying the first 2000 by IDItem, but I just determined that's not so. Maybe if we choose to display the first 2000 and do so, and then change the sort order, IQ could refilter by adding the sort field as a filter. E.g. if sort by ItemModified descending is chosen, IQ could then automatically generate a date filter so that the most recent items are displayed. But as you say, it's a minor thing; only a bit disconcerting when you don't see the items you expected to see.

If you sort by ItemModified Desc on the Source bar (bar on top of the grid with source, filter and sort text boxes), then it should work

Try it and confirm back if it works

Pierre_Admin

IQ Designer

It works! Great! Thanks for pointing this out. Right click on ItemModified heading > Sort Items Descending doesn't do the trick, but the Source Bar method does.

Exactly, that's because the source bar sort is executed when retrieving the data, the sort bar sort (or column sort) is executed after the data was retrieved

Pierre_Admin

IQ Designer

Good to have both options. I'm glad I understand now.

Pierre, just to make sure I understand, when I select the ItemModifed DESC sort order in the Source Bar, and then I select to return the first 2000 items that meet the filters, are these the items that have the 2000 most recent ItemModified values, among those that meet the filters?

Exactly, you can add the ItemModified column to the grid to ensure that it is the case

Pierre_Admin

IQ Designer