Add a reporting page where Administrators can see a list of all Accounts that have never made a vacation request
Hello, Have two entities. VacationRequest & OOTB Account. VacationRequest has two associations with Account 1. Submitter & 2. Approver. Would need to generate report for administrators so that they can see a list of all Accounts that have never made a vacation request. Any help would be greatly appreciated.
I suggest retrieving a list of all accounts via XPath, then retrieving a list of all accounts with a request and performing a subtract list operation between the first and the second list.
To get all accounts with a request use something similar to:
You can also do this is a single step by placing the retrieval Xpath above in a not() but that’s advised against due to the performance impact.