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. 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