You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
ATC vocabulary has the following concept classes: 'ATC 1st', 'ATC 2nd', 'ATC 3rd', 'ATC 4th', 'ATC 5th'.
Query "D08 Find drug classes for a drug or ingredient" has the following code: AND c1.concept_class_id IN ('ATC','VA Class','Mechanism of Action','Chemical Structure','ETC','Physiologic Effect')
It should be replaced with: AND c1.concept_class_id IN ('ATC 1st', 'ATC 2nd', 'ATC 3rd', 'ATC 4th', 'ATC 5th','VA Class','Mechanism of Action','Chemical Structure','ETC','Physiologic Effect').
Some other queries might be also affected by the issue.
The text was updated successfully, but these errors were encountered:
ATC vocabulary has the following concept classes: 'ATC 1st', 'ATC 2nd', 'ATC 3rd', 'ATC 4th', 'ATC 5th'.
Query "D08 Find drug classes for a drug or ingredient" has the following code:
AND c1.concept_class_id IN ('ATC','VA Class','Mechanism of Action','Chemical Structure','ETC','Physiologic Effect')
It should be replaced with:
AND c1.concept_class_id IN ('ATC 1st', 'ATC 2nd', 'ATC 3rd', 'ATC 4th', 'ATC 5th','VA Class','Mechanism of Action','Chemical Structure','ETC','Physiologic Effect')
.Some other queries might be also affected by the issue.
The text was updated successfully, but these errors were encountered: