search

IBM / db2forzosdeveloperextension-about

IBM Db2 for z/OS Developer Extension for VS Code
https://IBM.github.io/db2forzosdeveloperextension-about/
Other
12 stars 7 forks source link

Schema Filtering for Catalog List #115

Open peterpk opened 11 months ago

peterpk commented 11 months ago

Schema Filtering for Catalog List

On my Db2 for z/OS system there over 100,000 tables in almost 2000 schemas. About 10 of those schemas belong to my projects. I would love to be able to set something (i.e. a list or pattern) in the connection itself that filters results in the catalog explorer so that it only shows the schemas I am interested in.

katsoohoo commented 11 months ago

Hi @peterpk,

Thanks for the suggestion. We do support filtering by name on the list page, but not at a connection-level. We'll look into connection-level filtering in future releases.

peterpk commented 11 months ago

hi @katsoohoo , I did check that out, but it filters purely on the name, and not by schema. For instance, on the list view, I can not set the filter as USERA.* to see only USERA's tables.

b-tsao commented 3 months ago

Hi @peterpk developer extension 2.1.6 has now completed filtering on all catalog navigation objects on any column.

peterpk commented 2 months ago

Yes! Even better would be if a default filter could be defined at the connection level, so that I don't have to first load everything (which for my system takes between 5 and 10 minutes), and then filter it down to just the ones I want. But this is a great step in the right direction. I'm off to go play with it now!

b-tsao commented 2 months ago

Thank you for your feedback @peterpk, we have noted a similar issue here https://github.com/IBM/db2forzosdeveloperextension-about/issues/129