Filtering Table Names without Numbers

[expired user #11119]'s profile image [expired user #11119] posted 6 years ago in General Permalink

Hi everyone,

I am new to this forum, and I think it's a great community for a great tool.

Intros aside, I am really curious if it's possible to filter out table names without numbers. I have a huge database with a multi-tenant design, and a lot of these tables have numbers in them (table44123 for example) and some tables don't have numbers (global tables). With this, I would like to list down which tables are not multi-tenant (doesn't have numbers in them)

Thanks,

Jan

kalvaro's profile image kalvaro posted 6 years ago Permalink

The filter box expects good old regular expressions, so you can start with [^0-9] and fine-tune to your needs.

[expired user #11119]'s profile image [expired user #11119] posted 6 years ago Permalink

The filter box expects good old regular expressions, so you can start with [^0-9] and fine-tune to your needs.

Does the regex work on this filter? The one for viewing the tables of the database? Tried what you've added and I can't seem to get it to work.

1 attachment(s):
  • filter
ansgar's profile image ansgar posted 6 years ago Permalink

No, regular expressions are supported on the upper left table filter, but not on the right panel.

[expired user #11119]'s profile image [expired user #11119] posted 6 years ago Permalink

I see. And no plans to have this in the future?

ansgar's profile image ansgar posted 6 years ago Permalink

Well, with such nice screenshots, you could make a feature request in the tracker?

[expired user #11119]'s profile image [expired user #11119] posted 6 years ago Permalink

Will do! Thanks :)

Please login to leave a reply, or register at first.