To pull information on users who do not have documents under a specific category:
Create a query on document categories
Click Access Button
then click HR Admin.
Go to Queries then click on Create a New Query [+].
Select Documents then select:
Document Name.
Document Category.
Click Next then under Filters & Options, click on Document Category.
Select Equals.
Select the relevant Category from the dropdown list.
Click Next then give the query a name.
Click Next then over over Export To and select Export To Excel.
Create a query to show all users' records
lick Access Button
then click HR Admin.
Go to Queries then click on Create a New Query [+].
Click Next then Next again.
Give the query a name then click Next.
Hover over Export To and select Export To Excel.
Compare
After you have exported both queries to Excel, you will need to delete the mutual records between both exported Excel files. This will allow you see which users don't have a document under a certain category
β