Generally, activating the Level Three filter can only be done by the administrator and is done via selecting the Enable level three filter button in the Filters section. If authorized, you can activate the Level Three filter by checking the Enable level-three filter option in the Data tab. CardExchange® Producer will display the following warning message to make clear that the Data Record View will no longer be automatically filled.
So do not be surprised if you no longer see any records. When activated, the operator himself can determine in what manner he wants to filter his data.
Every time the operator requests information from the database, for example, by selecting Refresh data in the Find section or pressing F5 on the keyboard, a window prompts for the desired filter conditions.
In this standard window you have the option to search on any field in the connected database.
In the Find what text box you enter the information you are looking for and if you want to find exact matches only, you have to select the 'Search for exact matches only' check box.
Now if you click on OK, CardExchange® Producer will execute the SQL directly to the connected database and will present the result in the Data Record View.
The advantage of this filter is that when connecting to databases with hundred of thousands of records, you only load the information needed for your production without constantly loading the Data Record View with information that is not needed.
An example using this filter could be when taking pictures of students. The student enters the room, the operator enters the student number into the Find what field, hits OK to search, when the record is found, takes a photo of the student, and saves the record.
Disable the filter by clicking on the 'Disable level three filter' button and click on Refresh data or press F5 to reload the database data into the Data Record View.