Text constrain options | Sql |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="96c2fd01-923f-4a6e-9f99-df9119d25c4c"><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="2e2b3d84-58ad-407f-9722-0e452c87a27e"><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="797e3e7f-56b9-43fe-8252-69b904248991"><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="80eff1e2-3c66-4ad0-b589-8bd3a5707827"><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="9e8be64c-2f58-4a39-9a97-f97be0bebf6c"><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="178816f4-2d66-4c5e-85cb-2a23ebb4f0ca"><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="72613d61-9c0b-4144-acd6-3a73062aa1a0"><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="9658d9b6-619c-4888-92bd-2d7280466413"><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%' |