|
How can I find a specific cardholder or person?
Author: Lori Tassin Reference Number: AA-00341 Views: 21775 Created: 03-22-2013 07:33 PM Last Updated: 03-23-2013 01:03 PM |
0 Rating/ Voters
|
![](http://ossi-usa.com/kb/admin/images/local/FirstTheme/ico-rating-g.gif) ![](http://ossi-usa.com/kb/admin/images/local/FirstTheme/ico-rating-g.gif) ![](http://ossi-usa.com/kb/admin/images/local/FirstTheme/ico-rating-g.gif) ![](http://ossi-usa.com/kb/admin/images/local/FirstTheme/ico-rating-g.gif) |
You can easily search the database on any combination of the CardData fields. In Card Management Mode, - Click the <Search> button. A blank CardData tab is presented.
- Fill in your search criteria. Any and all fields can be filled in. The most common are First Name, Last Name, Card Number, and/or Department.
![CardData Query](http://www.ossi-usa.com/kb/admin/media_store/2/AA-00341/CardData Search.jpg)
- Click the <Query> button.
The results of the search will display. All of the cards that match the query will be listed on the left with the details of the first record displayed on the right.
![](http://www.ossi-usa.com/kb/admin/media_store/2/AA-00341/CardData Search results.jpg) Notice the highlighted SQL query above. This is the query formed from the data entered on the CardData tab for the search. Those users well versed in SQL may prefer to write their own queries.
![SELECT by Firstname and Lastname](http://www.ossi-usa.com/kb/admin/media_store/2/Shared/SELECT by Firstname and Lastname.jpg)
|
|
|
|
|
|
|
|