Add an option to filter out tables with no rows in the connections database explorer

[sae907]

What:

Add an option to filter out tables with no rows in the connections database explorer

Why:

Our electronic medical records vendor only ever adds tables. They never delete them. They also provide very little useful documentation on how their tables are connected together. Also, they have very little naming and normalization consistency. I often have to recreate the data I need by exploring tables until I find what I need.

One thing that would help, is if I could only see tables with at least 1 row of data in them. For example, currently there are 8,770 tables in their database. 5 of the first 12 tables do not have data in them. It would be nice to just suppress them from the list to help me target what I am looking for easier.

Additional Context:

[mikeburgh]

Interesting, at the moment the filter feature is just plain text match, maybe I can make it a sub menu with some options or even a custom where clause, let me have a think about it, and look at it next week when I am back.

[sae907]

feel free to close this if it doesn't align to your vision of dbcode. no need to clutter up your product because one of my vendors clutters up theirs :)