Knowledge Base
cancel
Showing results for 
Search instead for 
Did you mean: 

Date Qualifier in a Listview

Issue

Want to create a listview that shows all expired personnel cards on or after today's date.

Environment

Cyberstation (all versions)

Cause

The built-in Personnel_Expired Cards listview does not have any date filters.

Resolution

Either edit the  built-in Personnel_Expired Cards listview, or create a new on.  Edit the listview, and click on the Qualifiers tab.  Check the Advanced Database Qualifier box, and type the following expression in the Database field:

 ((ExpirationDate >=  [workstation name]\Date) & (Template = False))

where  [workstation name] is the name of the Cyberstation.

When the listview is opened,  cards expiring today and after will be displayed.

 

 

 

 

 

 

Tags (1)
Labels (1)
Version history
Revision #:
1 of 1
Last update:
‎2018-09-06 12:10 PM
Updated by: