IS2000: Personnel Records: Advanced Filtering By Card

Below are instructions on how to filter personnel records that do not have a card number and do have a card on personnel manager.

  1. In Personnel Manager, click the filter button (i.e. the funnel) to view the filter popup menu. (See Figure 1)

Figure 1

 Advanced Filtering By Card 1

  1. In the filter menu, click on the “Advanced Filter” tab. In the blank entry field at the bottom of the filter menu, enter the appropriate SQL statement. (See Figure 2)

To filter personnel records that do not have a card, enter:

personnel.id not in (select record_id from credentials where Credential_Number<>”)

To filter personnel records that do have a card, enter:

personnel.id not in (select record_id from credentials where Credential_Number<>”)

Figure 2

Advanced Filtering By Card 2

  1. Click “OK” and your personnel records will sort accordingly.