Hello,
Suggestion: When applying a filter on a column in an Explorer tab, have the filter apply to all records in the table, not just those in the default loading.
For example, say there's 22,000 records in a table and the default loading is set at 10,000 records. I select the table and the 10,000 records load. I then apply a filter on a column, expecting the filter to apply to the entire table. Instead, it is only applied to the 10,000 records initially loaded. I, therefore, get no or partial results thinking that I got all results. Turns out that's not the case.
There has been several frustrating times (including today), where I'm thinking there's no records for the criteria I'm interested in, only to find out that I forgot to force the entire table to load. After doing so, I then have to reapply the filter to see the desired records.
For now, I have updated the setting to load all records from a table. Obviously, this is not ideal.
Thanks!
Matt
There are two main ways to filter data in columns displayed within Toad's Data Grids.
-
Basic Column Filtering (e.g. Excel-style),
which, yes, only filters the data rows currently present in the display grid. TDP does NOT re-execute the query to re-produce your filtered data. This is by design.
... A work-around here is to simply right-click on the data grid and choose to Read ALL Rows, and then you're free to continue using Excel-style filtering that will operate on all the data.
-
Advanced (User-Defined) Filtering,
which is accessible either via right-click on the data grid (Define Data Filter) or via the funnel icon in the upper left of the grid display, per screen snap below. The advanced filter allows users more freedom to define and customize their filters. This option DOES re-execute the query to retrieve all the data that matches your filter criteria.
Hope this helps.
1 Like
Hi Gary,
Thank you for the quick response. That does, indeed, help.
Much appreciated,
Matt
