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.
Example 4.9.3-1: Example Use of termsInLanguages Procedure
| 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. Only languages and dialects in the release files can be selected. With the International Release can be tested with p_langCode set to 'en-GB,en-US'. | text | 'en-GB,en-US' | |
| Example Procedure Call | ||||
call snap_ShowLanguages('80146002,49438003','en-GB,en-US');
| ||||
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 | ||
Feedback
Overview
Content Tools
Apps