Table filters not saved when you amend the filter in the Query Editor
说明
If you have a saved filter on a table in the Schema Browser, and edit the filter query in the Query Editor ('View/Edit Query' button, e.g. hide some columns), the saved filter data is deleted and the filter is lost after clicking on another table, then returning to it. This worked differently in Toad 9.x versions.
原因
Product limitation
解决办法
The 'View/Edit query' (button next to Filter button) doesn't always work well with the filter. The View/Edit query option overrides the filter. The Filter relies on a query being created by Toad, and it remembers the "parts" (columns, where, order by) separately. If you want to edit the column list AND where clause, you can do it all in view/edit query.
The behaviour that's seen isn't 'by design', but more of a limitation. Toad v9.x is a very old version and didn't have the ability to do same/same queries there - only the filter. It also may not have been possible to do same/name filters then, but it's a limitation in the compatibility because for anyone using a lot of saved filters, this can't be changed at this time as it could break that functionality.
