User opens Schema Browser | Data tab of a table and right-clicks on Data Grid to select Filter Data. He enters a filter to reduce number of rows in his grid. He then selects Filter/Sort icon located on the Data tab toolbar. The filter previously entered in the other Filter window is not preserved and not shown. As a result,user can enter a new filter from here and add a second filter to Data Grid
These two windows appear to work independently and dont show the same filter criteria.
There are major differences between these two kinds of filter windows, and therefore there was no attempt to keep them in sync. The Filter/Sort dialogue changes the WHERE and ORDER BY clauses of the Data Tab query. The filtering and sorting is done on the server.
The right-click menu option Filter Data dialogue is processed on client side and does not limit the number of rows fetched from the server.
Therefore, it is advised to use Filter/Sort window on larger tables for better performance. On small tables, the Filter Data window may be faster because it avoids communication with the database.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy