Page History
Terms in Languages
The termsInLanguages procedure displays the terms associated with a list of selected concepts in one or more specified languages or dialects. The concepts to be selected are specified by a comma-separated list of conceptIds and the languages in which they are to be displayed are specified by a comma-separated list of language codes.
SQL Call to Procedure | |||||||||||
call snap_termsInLanguages(p_conceptids,p_langCodes); | |||||||||||
Parameter | Description | Data type | Examples | ||||||||
p_conceptids | A string containing a comma separated list of concept identifiers. | text | '80146002,49438003' | ||||||||
p_langCodes | A string containing a comma separated list of language codes.
| text | 'en-GB,en-US' | ||||||||
SQL Call Example | |||||||||||
| |||||||||||
Result | |||||||||||
conceptId | type_and_lang | term | |||||||||
80146002 | FSN en-GB | Excision of appendix (procedure) | |||||||||
80146002 | Preferred en-GB | Appendicectomy | |||||||||
80146002 | Synonyms en-GB | Excision of appendix | |||||||||
80146002 | FSN en-US | Excision of appendix (procedure) | |||||||||
80146002 | Preferred en-US | Appendectomy | |||||||||
80146002 | Synonyms en-US | Excision of appendix | |||||||||
49438003 | FSN en-GB | Appendectomy with drainage (procedure) | |||||||||
49438003 | Preferred en-GB | Appendicectomy with drainage | |||||||||
49438003 | Synonyms en-GB | Appendicectomy and drainage | |||||||||
49438003 | FSN en-US | Appendectomy with drainage (procedure) | |||||||||
49438003 | Preferred en-US | Appendectomy with drainage | |||||||||
49438003 | Synonyms en-US | Appendectomy and drainage |