Advanced Filtering of Personnel Records

Using the Advanced Filtered function, Personnel Records can be filtered with advanced search criterias using SQL statements and operands such as equal to, not equal to, greater than, less than and sort by ascending or descending.


Example:  Filter all Personnel records that do not have a credentials/card number asssigned


  1. Open Personnel Manager and unlock the module
  2. Click on the funnel icon to launch the Filter window


  3. In the Filter window, select the Advanced Filter tab
  4. In the box below the Sort By section, type in the following SQL query:  personnel.id not in (select record_id from credentials where Credential_Number<>'')
  5. Click Ok to apply this advanced filter
  6. The list of personnel records should now be condensed with an orange bar showing Filtered Record x of y