How to change the status of the documents by using lotus scheduled agent
I want to change the status of the documnets after three(3)months by using scheduled agent.Agent should be run on daily and check the documents and identify which documnet creation date more than 90 days(3 months)
Software/Hardware used:
Software/Hardware used:
ASKED:
April 9, 2008 11:34 AM
UPDATED:
April 10, 2008 1:58 PM
RELATED QUESTIONS
- Creating a scheduled agent to change status of Lotus Notes documents after three months
- Pop-up messages in dialogue to Lotus Notes users using Lotusscript
- ASCENTER scheduling question
- Lotus Notes Agent Accidentally hid all documents in the database
- how to print lotus documents and attachments in lotusscript in a scheduled agent?
Answer Wiki:
SELECT Status = "oldvalue" & @Adjust(@Created; 0; 0; 90; 0; 0; 0) < @Today;
FIELD Status = "newvalue"
If you have a full-text index in the database, you can make this agent faster by using the Document Selection section to find the documents you want to modify (and change the SELECT statement to SELECT @All). The dialog for adding search conditions to the document selection is pretty self-explanatory.
To see all answers submitted to the Answer Wiki: View Answer History.
Check into these methods and objects in designer help. The code this comes from deletes all attachments from any notes documents older than 30 days.
‘ declare and set a comparative value equal to now
Dim rightnow As notesdatetime
Set rightnow = New notesdatetime (Now)
‘ set the comparative value back 30 days
Call rightnow.adjustday(-30) ‘ set to 30 days ago
‘get a collection of documents
‘Loop through the documents.
If (doc.created < rightnow.LSLocalTime) Then
‘Do processing
End If
Clearly, AGuirard’s answer is far superior to mine. If the modification needs to be included within existing LotusScript, you could leverage my suggestion. Otherwise, the formula code AGuirrard provided it much better.