I don’t think this can be done, but hear me out…
There are over 400 views in a database (don’t laugh, I didn’t design it) and I now tasked to find out which views are not being used or being used seldomly.
My idea was to insert a quick code snipet in the Queryopen event in each of the 400+ views that would send an email to another database where the counting is going on.
Is it possible to edit/update the view’s Queryopen event through LotusScript or some API, COM, etc. deal??? Or is there a better way to do this???
Thanks!
Dan
Subject: Edit View’s Queryopen event from LotusScript???
Whether or not what you asked can be done, I do not know, but you could try just looking in the log file.Under Db Usage, there is an activity document which shows view size. Depending on how the view was designed (with regards to when it creates and deleted its index) it may be rational to conclude that if the view size is continually 0 bytes that it is not being used.
Subject: Edit View’s Queryopen event from LotusScript???
by putting code in QueryOpen event you will get only those views used by UI.
It probably could be easy enough to run XML export, change the text file and import it back. The simplest way, IMO.
Maybe it’s the most important in your case, but in case some of them have been used in the design you may be in trouble.
If that’s also the case (you didn’t design it so you do not really know that they are not used, right?), you may use TeamStudio Analyzer or free DDSearch tool from Sandbox to search for the view names.
I’m not aware of how you can speed up this process – i.e. automatically passing view names to DDSearch or Analyzer, probably by writting some code that does keysend to DDSearch or creating rules for Analyzer.
But probably with 400 views quickest (though probably error prone) would be to run a simple code that produces a text file with Names and Aliases and then use it to cut and paste and check them one by one…