Text constrain options | Sql |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="3e11193c-e2db-4679-8597-4209013a75cb"><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="a2a8ef3e-49c2-4c18-a17f-c1a0039a7a2d"><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="6853028a-e914-4a61-8075-be0b3b0e0594"><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="f6b166ef-ec84-4cc3-8fb0-223c3c91672b"><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="d213cb57-dacb-49d4-82c3-3388b0f6c966"><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="a5ef2ced-ffe3-43b5-b0bd-35fb90d3712e"><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="606b99c7-fb56-43ba-a072-2ae1444717de"><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="29e7208c-5d63-499e-9b37-a1cb2a75441a"><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%' |
