Text constrain options | Sql |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="f4584a7f-256b-431e-8d94-9a30c436d201"><ac:plain-text-body><![CDATA[ | LIKE[exact]
]]></ac:plain-text-body></ac:structured-macro>
Case insensitive search.
<constrain_by_value>
<value_type>TEXT</value_type>
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="6cb59877-3ed5-4446-b75f-2e9ea2f7616c"><ac:plain-text-body><![CDATA[ <value_operator> LIKE[exact]</value_operator>
]]></ac:plain-text-body></ac:structured-macro>
<value_constraint> NEG </value_constraint>
</constrain_by_value> | Select * from observation_fact where
Concept_cd in (select concept_Cd from concept_dimension where ..) and
valtype_cd = 'T' and
upper(tval_char) = upper('NEG') <ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="ec4d8d7e-4743-4abd-a48d-150c3c866104"><ac:plain-text-body><![CDATA[ |
LIKE[begin]
] ]></ac:plain-text-body></ac:structured-macro>
Begin will be the default option if the optional tag is not present. This will support backward compatibility.
<constrain_by_value>
<value_type>TEXT</value_type>
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="5214a0d0-36ce-48e2-9849-d64fe70e88bf"><ac:plain-text-body><![CDATA[ <value_operator>LIKE[begin]</value_operator>
]]></ac:plain-text-body></ac:structured-macro>
<value_constraint> NEG </value_constraint>
</constrain_by_value>
| Select * from observation_fact where
Concept_cd in (select concept_Cd from concept_dimension where ..)
and
valtype_cd = 'T' and
upper(tval_char) LIKE upper('NEG%') <ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="d2ad60bc-866b-4630-92a9-088588ef1a4a"><ac:plain-text-body><![CDATA[ |
LIKE[end]
] ]></ac:plain-text-body></ac:structured-macro>
<constrain_by_value>
<value_type>TEXT</value_type>
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="0c1df5be-53a2-41b5-b2a5-8f711d1df302"><ac:plain-text-body><![CDATA[ <value_operator>LIKE[end]</value_operator>
]]></ac:plain-text-body></ac:structured-macro>
<value_constraint> NEG </value_constraint>
</constrain_by_value>
| Select * from observation_fact where
Concept_cd in (select concept_Cd from concept_dimension where ..)
and
valtype_cd = 'T' and
tval_char LIKE '%NEG' <ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="90a23026-e60c-486e-b0a2-f6cdc7cab20f"><ac:plain-text-body><![CDATA[ |
LIKE[contains]
] ]></ac:plain-text-body></ac:structured-macro>
<constrain_by_value>
<value_type>TEXT</value_type>
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="a0dc3565-08a4-46d2-9510-487745614628"><ac:plain-text-body><![CDATA[ <value_operator>LIKE[contains] </value_operator>
]]></ac:plain-text-body></ac:structured-macro>
<value_constraint>NEG </value_constraint>
</constrain_by_value>
| Select * from observation_fact where
concept_cd in (select concept_Cd from concept_dimension where ..)
and
valtype_cd = 'T' and
tval_char LIKE '%NEG%' |
