Regular Expressions in Filter
When setting up filter rules, it would be useful if we could use some regular expressions on the criteria. We have several objects that we would like to exclude from source control when they end with a string of 6 numbers. The numbers are different for each object, so if we could use some simple regular expressions, we could filter out objects that end with [0-9][0-9][0-9][0-9][0-9][0-9].
WizKid
shared this idea
As of SQL Source Control 3.8.13, filter rules now support the standard T-SQL LIKE syntax for wildcard characters (‘%’, ‘_’, ‘[abc]’, and ‘[^abc]’ – see MSDN for details).
To include wildcard characters explicitly in a filter, they can be escaped with square brackets.
‘Equals’ and ‘Does not equal’ operators will not treat those characters as special wildcard characters.
-
Thanks for the suggestion. In the meantime you could set up 10 'starts with' rules, with 0,1,2,3,4,5,6,7,8,9 as the suffixes?
