Submitted by d bartlett on 2021/02/06 14:44
 Hi Pierre,
 
When opening a grid containing literally thousands of items, and the dialog box (if so enabled) pops up first asking if you want to open the first 1000 items (or whatever the # count setting is) or all items (which will take longer) where or how do I change a setting so the most recent items (say 1000, for instance) open instead of the oldest items?
 
I understand in Options/Grids where and how to change the number of items that open, but it's always the oldest items that open.   I want to change that to the most recent items.
 
thanks
Dour Bartlett

Comments

Hi Doug,
 
There are a couple of ways to do this:
  1. In the grid, set the sort text box to ItemModified Desc
  2. Use the Date Filter toolbar to limit the list of items
 
Pierre_Admin
IQ Designer
 

 For my 74,857 item journal file, I did 3- Cancel to exit out of the popup.
Then I put ItemModified > NOW - 10 or ItemCreated > NOW - 10 in the grid filter, then refreshed  to only get 602 items. (Adjust filter to meet your needs)
The grid will remember this for the next time you use it.
 
 

Pierre_Admin

2021/02/06 16:19

In reply to by KeithB

[quote=KeithB]ItemModified > NOW - 10 or ItemCreated > NOW - 10 in the grid filter, then refreshed  to only get 602 items
[/quote]
That's 60.2 items per day... prolific M. Keith 
 
(since I switched to the Daily Notes approach -- I should write up a page on this -- I'm down to < 5 per day lol )
 
Pierre_Admin
IQ Designer
 

LeftEccoForIQ

2021/02/06 16:35

In reply to by Pierre_Admin

Please do! I for one am very intersted in this new approach.

KeithB

2021/02/07 18:50

In reply to by LeftEccoForIQ

 I'm quite interested also. If would be nice to at least get a quick screenshot of a day.
I'm curious if you use the grid, card view, or the new doc pane enhancements, or some combination of these.

thanks guys, I used the DESC filter technique and it accomplished what I was looking for.    the other is a bit beyond my level of comfort and bravado - I'm afraid I might blow-up some structure and not be able to recover from it.
 
thank you both.
 
Doug Bartlett