Hi,
I have a tricky question:
I have 2 multivalue fields: Weeks and Occurences.
How can I flag when the occurences has reached a certain number and notify someone, then check from the flag onwards, until it reaches the number again, etc.
In other words, I have to flag when 10 days were reached or 5 occurences (whichever comes first) and say it happened at week 4, the next check starts from week 5.
Example:
Week1 - 5
Week2 - 5 → Flag at this point, then the next check will start at Week 3, until it picks up 10 days or 5 occurences again.
Week3
Rgds
Subject: Multivalue Field
If I understand correctly…
Use a scheduled agent to run a check against the documents. If the doc meets the criteria, then flag it, and at the same time set a startCheckDate field. The scheduled agent will only run against docs on or after the startCheckDate field.
E.g, Agent runs today and finds doc1 has had 5 occurences and/or 10 days. This doc is now flagged. At the same time the startCheckDate field is set to the start of next week. This document won’t be checked again until next week.
Subject: Multivalue Field
Sounds like you need a third field as a counter. It starts off at zero, and your test would be if (more than 10 days) OR (@Elements(Occurences)-counter) > 10. If it is true, set the counter eqaul to Occurences and send the email. Now it will trigger again when you pass 20 ocurrences or another 10 days.
HTH