How can we help you today? How can we help you today?

Filter tables that start with _ (underscore)

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
StormRider
0

Comments

5 comments

Sort by
  • 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
    0
  • Rob C
    This bug is now fixed.
    Rob C
    0
  • StormRider
    This bug is now fixed.

    I installed 3.8.11.103 and I'm still unable to filter tables that start with underscore.
    StormRider
    0
  • Rob C
    StormRider 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
    Rob C
    0
  • 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.
    StormRider
    0

Add comment

Please sign in to leave a comment.