Fig. 34: Filter records
To restrict the displayed data records in the Dataview, there can be defined several filters, that will be applied to the data record, in the Filter recordsDialog. This corresponds to the WHERE clause in a SELECT statement.
A filter will be defined by selecting the table column that should be filtered in the column Column. Then the Operator will be selected and finally the value by wich should be filtered.
| The dialog Filter recordsprovides the following entries: | ||||
|---|---|---|---|---|
| According all criteria | When this field is activated, the specified criterias of in table will be combined by an AND connection. Otherwise by an OR connection | |||
| Column | The name of the table column, that will be filtered | |||
| Operator | The compare operator for the filter:: | |||
| Operator | Entsprechung | Beschreibung | ||
| Like | = | Filters all data records that are not equal to the given value | ||
| Bigger | > | Shows all data records that are gerater than the given value | ||
| Smaller | < | Shows all data records that are smaller than the given value | ||
| Bigger or Like | >= | Shows all data records that are bigger or equalt to the given value | ||
| Smaller or Like | <= | Shows all data records that are smaller or equal to the given value | ||
| Unlike | != | Shows all values that are not equal to the given value | ||
| Begins with | a* | Shows all data records that start with the given string value | ||
| Begins ends with | *a* | Shows all data records that contain the given string value | ||
| Ends with | *a | Shows all data records that end with the given string value | ||
| Value | The value by wich the column will be compared | |||
The entrie can be committed by pressing the button .
Table Editor