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