NorthArrowResearch / champ-workbench

http://workbench.northarrowresearch.com/
GNU General Public License v3.0
0 stars 0 forks source link

Update all 0 and null Threshold values in Metric_Definitions #46

Closed volkcj closed 6 years ago

volkcj commented 6 years ago

Update them all to 0.008.

philipbaileynar commented 6 years ago

Performed on version 47 of DB by Philip on 16 Oct 2017. Will be shipped in next DB version.

UPDATE Metric_Definitions SET Threshold = 0.008 WHERE (IsActive <> 0) AND (XPath IS NOT NULL) AND ((Threshold IS NULL) OR (Threshold = 0))