Date & Time
20:00 UTC Wednesday 31st January 2018
To join the meeting please go to https://snomed.zoom.us/j/471420169.
Further information can be found at SLPG meeting information
- Discuss recent comments - ECL requirements and string collation
- Updates to SNOMED URI Standard
- Progress SNOMED Query language
- Chair: Linda Bird
- Project Group: Michael Lawley, Daniel Karlsson, Ed Cheetham, Anne Randorff Højen
Agenda and Meeting Notes
Welcome and apologies
Michael: "How can I write an ECL expression to match attribute names - for example, list all the attribute names that are used by << 404684003 |Clinical finding|.
Daniel: "Query language and collation"
When specifying the lexical search type for term matching there is a need to specify the collation used, and to specify the default collation for the language in which the terms are to be matched are represented.
Examples based on mysql collation behavior:
"AAO" matches "ÅÄÖ" in utf8_generic_ci and utf8_unicode_ci (and utf8_german2_ci) but not in utf8_swedish_ci collation.
"Aåa" matches "aåa" in utf8_generic_ci and utf8_swedish_ci but not in utf8_bin collation (i.e. case insesitive vs. sensitive, sometimes you need case sensitivity when searching...).
Similar behavior can be implemented e.g. by java.text.Collator in java or by the collection.find() or cursor.collation() method in MongoDB.
Outstanding questions about relationship filters
Outstanding questions about lexical filters
|Confirm next meeting date/time|
Next meeting to be held at 20:00 UTC on Wednesday 14th February 2018