Show/Hide Toolbars

CardExchange® Producer Help

 

In a limited number of situations, even the advanced filter does not offer the flexibility needed to make the precise selection. In that case, you have the possibility to choose the option Show SQL in the View menu of the Advanced database filter window. The following screen will be shown:

 

Filters_Edit_Level_Three_Advanced_Add_Filter_SQL

 

In this window, you can define your filter conditions using the SQL of the connected database. By default, you will see the SQL equivalent of the conditions defined in the standard view of the advanced filter, but you can change it the way you want. The SQL you enter will be stored in the internal database, but will be lost if you switch back to the standard view. In that case, you will see the conditions as you defined them before activating the Show SQL option.