Lotus Notes View Formula
I have a need to get snapshots of data as it existed on a previous date. Specifically, I need tpo see all open tickets (not in status of closed) for the beginning of each month going back to January. Is this possible?

Software/Hardware used:
Lotus Notes 5.0.6
ASKED: October 14, 2011  4:49 PM
UPDATED: January 16, 2012  7:57 AM

Answer Wiki:
Yes, it's possible going forward, and there are a number of ways to accomplish this. You could write an agent that runs monthly and creates copies of the required documents on a different form and view, or you could make monthly copies of the whole database. Or, you could redesign the existing form in such a way that it captures existing data at every change of state. Which approach you choose just depends on your current database and your needs. If you are wanting data from months prior to today, you may have to restore some of your backups.
Last Wiki Answer Submitted:  January 16, 2012  7:57 am  by  Ledlincoln   1,620 pts.
All Answer Wiki Contributors:  Ledlincoln   1,620 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _