Filtering Data

Filtering records

If the current project contains a large data amount you can easily detect the desired objects applying the filter functionalities provided by WinCan VX. You may either use the AutoFilter (Quick Filter) to run a quick search on the project database or the extended filter (User Filter) to define more complex filter criteria.

AutoFilter (QuickFilter)

The AutoFilter works with a list of pre-defined columns, containing a list of available criteria based on text you entered before (2). Once you click on the icon Apply Filter, the database is filtered and shows all records (highlighted in yellow) that match the criteria selected directly from the list.

Click again on the highlighted filter button to quit the filter mode and to re-display all the records:

Extended Filter (UserFilter)

The extended filter (4) on the other hand enables the user to link different criteria together and to query the project database in a more sophisticated way. The query always must be saved with a specific name (4a) before defining the criteria. Always hit the PLUS-button (5) to add additional criteria.

Hitting the filter button (7) is displaying the number of records within the filter dialogue that match the criteria (6). Next push the magnifier button (8) to run the filter query and click on the green tick button (9) to confirm it. The filter result is finally displayed in the overview panel.

Click again on the highlighted filter button (10) to quit the filter mode and to re-display all records.

Exporting Filtered Data

The tab command Data Exchange > Project Export is going to copy the current filter result into a new project, which is automatically created in the background. The user hereby gets the possbility to limit the copy process to certain object categories or data types (1). If the option UseFilter is switched off (2) the whole project will be copied to the target folder (3):

Â