AnsweredAssumed Answered

Check to see if required records have been created for date range

Question asked by jdevans on Jun 12, 2015
Latest reply on Jun 13, 2015 by jdevans

Title

Check to see if required records have been created for date range

Post

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:

         
  1. Get list of all active account names
  2.      
  3. Find all records in the specified table that were created in date range, and get account_created list for this found set.
  4.      
  5. Compare active account name list to account_created list
  6.      
  7. Report difference list

Outcomes