Data Quality Services (DQS) domain rule validation ignores [ in does not contain test - by SQLWaldorf

Status : 


Sign in
to vote
ID 777379 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 1/24/2013 5:57:20 AM
Access Restriction Public


When I create a DQS Domain rule 'Value does not contain ' with as value [, and I test the rule, the test always succeeds, even with [ values in the test string, even if the test string is nothing but the [.
Sign in to post a comment.
Posted by Matthew [MSFT] on 4/12/2013 at 10:39 AM
We're closing this issue as "Won't Fix" as we do not plan to address it for SQL Server 2012 DQS. We will keep the feedback on file for future releases of DQS.
Posted by Matthew [MSFT] on 3/1/2013 at 2:48 PM
Hi SQLWaldorf,

Thanks for the feedback. We apologize for the delay in responding.

While we’re investigating the problem you’ve reported, can you please test a potential workaround? You should be able to achieve the desired functionality by using a domain rule with a Regular Expression rather than a “Does Not Contain” rule. A Regular Expression that may provide the functionality you need is \A[^\[]*\z.

If you could test this and let us know if it unblocks you we would appreciate it greatly. Thanks in advance!

DQS Team