Add a reporting page where Administrators can see a list of all Accounts that have never made a vacation request

0
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.  
asked
1 answers
0

Hello Chandra,

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.

Hope this helps

answered