View with advanced, multiple criteria.
I've defined the following function to determine the Users that haven't been assigned to a Project.
The function browses the Add_a_New_User table for all Users and verifies if each User is contained in the Assign_Project table. If so, the User_Name is added to userList.
- list lookup.Unassigned_Users()
- {
- userList = List();
- for each rec in Add_a_New_User [ID != 0]
- {
- if (count(Assign_Project[User == rec.User_Name]) <= 0)
- {
- userList.add(rec.User_Name);
- }
- }
- return userList;
- }
I've been trying to define the criteria a View that would contain only the users found and added to the userList.
Does anybody have an idea how this can be achieved?