Filter tables that start with _ (underscore)

StormRider

How do I filter tables that start with an _ (underscore)?
just using _ doesn't work, as it filters everything. I tried [_] (sql style escape) and _ (regex style escape), and they didn't work either. Ideas?

SQL Source Control version 3.7.5.328

Rob C

Hi,

Unfortunately there is currently no way to escape the underscore character. This is a bug with reference SC-5894.

If it is acceptable, you could move the object to a new schema and then filter by schema name. I know this isn't ideal but there isn't a good workaround at the moment.

I will let you know when the bug is fixed. Apologies.

Rob C

This bug is now fixed.

StormRider

Robert Clenshaw wrote:

This bug is now fixed.

I installed 3.8.11.103 and I'm still unable to filter tables that start with underscore.

Rob C

StormRider wrote:

Robert Clenshaw wrote:

This bug is now fixed.

I installed 3.8.11.103 and I'm still unable to filter tables that start with underscore.

Hi,

I suspect you might be encountering another bug that is related to underscores that was fixed in a later version. Can you try installing 3.8.19? Here's a link - ftp://support.red-gate.com/patches/SQLS ... 19.130.exe

StormRider

Thanks Robert, that worked. For anyone else that runs across this issue, you'll need to enter [_] into your filter, the square brackets escape the underscore.