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