How to change the status of the documents by using lotus scheduled agent

pts.
Tags:
Lotus Agents
Lotus Notes
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)

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Brooklynegg
    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
    3,845 pointsBadges:
    report
  • Brooklynegg
    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.
    3,845 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following