...
When the term is dragged, the value selection box will be presented to the user, the STRING tag will cause the following box to be presented:
Image Modified
Note that the "Family History Problem" is a concept code that has a value, which is text in the TVal_Char column, and the value will be searched for the word/phrase "mother". The STRING query box allows the following options for how the string value will be searched:
...
Text constrain options | Sql |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="879344dca5c6d286-729a69b9-4b604e0b-a295af05-64a8da1815e9259c7f4f7aa7"><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="9bfc8e1f5f54e987-5347a657-46a54227-974e8425-25ecbeceb5541089c746098c"><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="3d35d8e8b592bb65-c656c905-47654a27-855897c9-5136a8e4b6b4776205dced34"><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="1297399f6a8dbbfe-d0acb15a-4a3e4248-810ca8b9-46594f1d6c9a0d11f926207f"><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="7834e0dee66bec42-c62f1f3f-40eb4aaf-81939b29-21b1db7037a140ed3f0c4a3d"><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="aac94908a19a547b-17c9283a-4ebb4bef-8888868f-60688a79b43cffe4abeeaae2"><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="247bb5d6060b54ed-7eb34438-42e6471e-bcd0a40d-1b088ca56431fd5ea9379dea"><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="78ae4356c9fa46af-5bae0af9-472747e1-afc5b833-9dbe993440e1dd8ea264a96b"><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%' |
...