Select criteria in a View

HCL Domino Domino Forum
1

Hello,I am currently modifying an attendance database and am creating a new view. I have been asked to create a view that shows all employees that have called in sick 5 or more times in a rolling 150 days. I am not sure how I would create the criteria for the 5 or more times. What can I do to make it so that it only shows a “Requestor” that has been out 5 seperate times. Here is what I have so far.

SELECT @If(Form = “frmRequestEditable”) & (TimeOffTyp=“Called In Sick”:“Left Early - Sick”) & (StartDate>(@Adjust(@Today; 0; 0; -150; 0; 0; 0)))

Thank you!!!

2

Subject: Select criteria in a View

There’s no way to do it without modifying the documents themselves – documents can only be selected on the basis of what they, themselves, contain. You can, however, populate a folder with an action (or agent) that looks at a view categorized on the name, then cycles through the category entries doing GetAllDocumentsByKey and counting the resulting collection. If there are more than four documents in the collection, then put the whole collection into the folder.