Text constrain options | Sql |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="9e7e00ae-81e7-449a-b871-747f711f34e3"><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="d176b614-8fb0-4617-afbe-f27f2767f62f"><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="421a3b0c-4f91-47a3-b958-68529cdbd881"><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="eba9ac37-9132-4d95-a719-2fd11881a24c"><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="68222a9a-b0fe-4a1b-9655-1a137103f649"><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="8fb9d9ab-7a3f-4b95-9e99-abdc9cb843ae"><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="dbea2f59-110c-4f6d-8275-8e12a64386b4"><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="15b96f57-c071-4f84-8282-3b7254e594e6"><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%' |