I have a 185 column interface data table that I live in way more than I desire. About 80% of the time I only want to see 15 columns of data. Is there some way to select those 15 and save that column filter option for the SB grid so I do not have to reset to All and reselect these 15 every single time I need to toggle between the subset and full column display? I have about 20 different environments so dragging the "always see" columns to the left, hoping it stays, repeating it in every environment combined with my inability to ever reposition columns without making a complete mess isn't a a good workaround. I have other wide tables that are less visited, but a per-table "column selection favorites" would be sweet.
I assume that you have Options -> Schema Browser -> Data Tab -> Save Layouts checked? This would save your column arrangement and visibility, but doesn't make it easy to copy to other environments.
Have you tried View/Edit query, commenting out the columns you don't want and naming it?
Then after you save and name one, it shows up here for easy retrieval. This is all on a per-table basis.
These settings are saved under User Files\Databases<Connection Name>\SCHEMA_TableFilters.XML. You could easily just copy it to other connections if you wanted.
Oh wow! This has made my day! This is even more flexible. Thanks for the response and demo.
1 Like
A new nag on this one. Is there a trick to make a selected filter more sticky? I'm in my SB Favorites with a few tables and set this on one. It does reset the gird and makes me refilter to reactivate the previous filter. The good news is it is still there and I can enable it again. Then I soak in the data, move to another table to mind meld, then come back the the previously filtered table and it's back to default columns and I've got to select the desired select filter and reapply the filtered data.
Hi Chuck,
Sorry, it always resets to the default query when you browse away from the table and then back.
One workaround though - if you load up whatever tables you're interested into a F4 describe window - the RHS will persist there until the describe window is closed. So you could switch between tables in the describe and they'd keep whatever custom query you select on them until the describe window closes.
1 Like