directus/directus

Regex Table Filters

benhaynes asked for this feature about 1 year ago — 1 comment

benhaynes commented about 1 year ago Admin

@chaserelock commented on Aug 31, 2015

Hey guys - awesome project! I saw that there is a mechanism to blacklist table names by passing in an array of tables not to be read. While this is great, it's not extensible for databases that constantly grow in # of tables that are not necessarily interesting from a dev standpoint (e.g. data specific to 1 user in table_12345). Because our naming however is consistent, a regex filter would allow me to permanently capture that set of tables to ignore going into the future.

@benhaynes commented on Aug 31, 2015

An excellent recommendation. I think that this array might be vestigial, since now Directus takes the opposite approach – only pulling in whitelisted tables. We ran into issues with some installations where temporary tables were created by services that weren't meant to be managed at all. Now you have to add managed tables into directus_tables to pull them into the system.

We will go through and reassess this whitelist/blacklist process to make sure it all makes sense and removes redundancy. Thanks!

Join the discussion!

Sign-in with GitHub to comment