Check to see if required records have been created for date range
I have a table that stores pdfs. These pdfs are required documents that each employee must turn in at the end of each week. I want to give specific users (via privilege set) the ability to go check to make sure all employees have created this record for a given week. If not, they will know who hasn't done it, so they can be notified. Eventually, I'll send automated emails based on this information, but first I want to know how to check for "missing" records. Each user has their own login, and that account_created is part of each of these pdf records. My psuedo-code goes something like this:
- Get list of all active account names
- Find all records in the specified table that were created in date range, and get account_created list for this found set.
- Compare active account name list to account_created list
- Report difference list