Enhanced filter |
Enhanced filter is called with help of Search and filter / Enhanced filter command and is used for filtering and search of data set records by expression and by range. The user should form expression for filter independently. For construction of filter expression the list of data set fields names and the list of operators are given. By double click of the left mouse button a table field from " Field list " and operation of comparison from window "Operator" are selected. Further it is necessary to proceed into " Current filter text " window and to enter a condition value. Thus editing of the created expression in Current filter text window is possible. It is possible to set complex conditions of filter formating, for example, with the help of logic operations AND and OR. You can save the formed expression for filter (Save button). You can select the saved earlier query in Saved filter list window. By pressing the Clear current button deleting of the current expression for filter is made. With help of the Clear list button you can clear the queries list from all earlier saved elements. Management of filtering of a data set is carried out with help of buttons: Filter, Search and Drop. |