{"type":"doc","content":[{"type":"paragraph","content":[{"text":"Responding to customers' needs, vendors implemented functionality for decorating data in EHR with additional “tags” to encode non-structured non-clinical (technical) context, that needs not be versioned. This is not yet part of the openEHR standard and has been introduced by vendors with barely any coordination, so implementations are incompatible. We hope to be able to unify our approaches at least in their “least common denominator” and standardise this aspect of CDRs. Vendors might still add their own bells and whistles to the standardised bare minimum, but the basic idea would be uniformed.","type":"text"}]},{"type":"paragraph","content":[{"text":"The first step is to gather information on existing implementations, which is the purpose of this page.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Better (ex Marand)","type":"text"}]},{"type":"paragraph","content":[{"text":"Our CDR can work with tags on arbitrary AQL-path-addressable element from a COMPOSITION downward. Technically tags have two fields to address the target element (full COMPOSITION UID and an AQL path) and two content fields (tag name and an optional tag value, both strings).","type":"text"}]},{"type":"paragraph","content":[{"text":"Tagging can be done in two ways.","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Tags (with optional values) can be part of the contributed composition in our proprietary “flat JSON” format under the ","type":"text"},{"text":"ctx/tags","type":"text","marks":[{"type":"code"}]},{"text":" field. The canonical format has no place for tags, obviously.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Via a proprietary REST API; see ","type":"text"},{"text":"/tagging","type":"text","marks":[{"type":"code"}]},{"text":" under ","type":"text"},{"type":"hardBreak"},{"text":"Electronic Health Record APIs","type":"text","marks":[{"type":"code"}]},{"text":" on ","type":"text"},{"text":"https://www.ehrscape.com/api-explorer.html","type":"text","marks":[{"type":"link","attrs":{"href":"https://www.ehrscape.com/api-explorer.html"}}]},{"text":". Adding a tag this way does not create a new version of composition, and non-current version can be tagged as well.","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Tags can be used in multiple ways:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Tags on a composition can be retrieved via that same API.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Objects, tagged with specific tags (where either only tag name can be constrained, or the value as well if required), can be retrieved via that same API. Note that CDR can be instructed to search only among the current versions of the compositions, or to return only the most recent version of any object that has the requested tag(s) (which may or may not be the current i.e. generally most recent version), or to return all tagged versions, or to return only the current version of any object that ever had a request tag, even if it does not have it in the current version.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The AQL has been extended with a function ","type":"text"},{"text":"tags(c)","type":"text","marks":[{"type":"code"}]},{"text":" that returns a list of compositions' tags (including values and AQL paths, if they have them) like this:","type":"text"}]},{"type":"codeBlock","content":[{"text":"\n /\n formName\n Diagnosis of diabetes - LDL order\n","type":"text"}]},{"type":"paragraph","content":[{"text":"(","type":"text"},{"text":"te","type":"text","marks":[{"type":"code"}]},{"text":" is our proprietary namespace ","type":"text"},{"text":"http://schemas.marand.com/thinkehr/v1","type":"text","marks":[{"type":"code"}]},{"text":")","type":"text"},{"type":"hardBreak"},{"text":"This function can, at the moment, only be used in the projection (","type":"text"},{"text":"SELECT","type":"text","marks":[{"type":"code"}]},{"text":") part of the AQL.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The AQL has been extended with a keyword ","type":"text"},{"text":"TAGGED BY","type":"text","marks":[{"type":"code"}]},{"text":" that can be used in ","type":"text"},{"text":"WHERE","type":"text","marks":[{"type":"code"}]},{"text":" clauses; at the moment only for entire compositions: ","type":"text"},{"text":"… WHERE c TAGGED BY 'key::value'","type":"text","marks":[{"type":"code"}]},{"text":". The double colon and value can be omitted to filter only by tag name (key). We propose this approach not to be standardised and instead to use the function ","type":"text"},{"text":"tags","type":"text","marks":[{"type":"code"}]},{"text":" in this context as well to avoid modifying the grammar; we believe DIPS does filtering this way.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Code24","type":"text"}]},{"type":"paragraph","content":[{"text":"What we have:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"a tag is a pair of key-value associated with the latest version of a composition (or party, or folder); tag values are mandatory","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"tags are not stored in the version’s data (so not in the composition) but instead are associated with the versioned_object (of that composition)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"tags are used as indexes, their values are auto-extract from pre-configured paths, every time a version is committed; in theory we could also deal explicit values (instead of extracted) but this functionality is not used","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"tags are not folders","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"we also have labels, which in comparison with tags are just values associated with versioned_object; these labels have to be explicitly set (they are not auto-extracted as tags above)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"tags and values are returned or could be set as metadata in REST api of specific resource","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"while querying with our query engine we use tags and labels in a similar way as Better above, although it is written differently, equivalent to ","type":"text"},{"text":"… WHERE tags.key = ‘value'","type":"text","marks":[{"type":"code"}]},{"text":" as well as ","type":"text"},{"text":"… WHERE tags.key LIKE 'val%’","type":"text","marks":[{"type":"code"}]},{"text":" . This can be seen as a reserved operand prefix.","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"What we are open for:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"stopping with ‘labels’ in favor of ‘tags’.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"allowing tags to have optional value.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"support usage of tags in query as functions as ","type":"text"},{"type":"mention","attrs":{"id":"557058:ef9f8e05-3d44-45e5-8a40-7d1ca81569b0","text":"@Bjørn Næss"}},{"text":" suggested: ","type":"text"},{"text":"select c/name/value, tag(c, 'EpisodeOfCareId') from composition c where tag(c, 'EpisodeOfCareId') = 'test' limit 5","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"if via function tag() is not an valid option (curious about ","type":"text"},{"type":"mention","attrs":{"id":"557058:44fd8a34-b99a-413a-9b2e-9ae43f1caf5f","text":"@Seref Arikan"}},{"text":" feedback) , then ","type":"text"},{"text":"TAGGED BY","type":"text","marks":[{"type":"code"}]},{"text":" will also do, but preferably as ","type":"text"},{"text":"… WHERE c TAGGED BY key = 'value'","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"DIPS ","type":"text"}]},{"type":"paragraph","content":[{"text":"Tags were developed to support integration with proprietary systems which don’t do versioning of data. Some metadata might change without committing a new version. The tags are used to update metadata on Compositions from the client. ","type":"text"}]},{"type":"paragraph","content":[{"text":"The client may update the tags using the REST API: ","type":"text"}]},{"type":"paragraph","content":[{"text":"POST /api/v1/{uid}/tags - ","type":"text","marks":[{"type":"code"}]},{"text":"Update tags on a COMPOSITION or FOLDER. Existing tags will be replaced.","type":"text"}]},{"type":"paragraph","content":[{"text":"There is also a REST API to get all tags in the CDR: ","type":"text"}]},{"type":"paragraph","content":[{"text":"GET /api/v1/tag/keys - Get all tag keys currently defined in the CDR. ","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph","content":[{"text":"For query we have one function tag(c, ) which returns the value of the of the composition. The function might be used both in SELECT and WHERE like this: ","type":"text"}]},{"type":"paragraph","content":[{"text":"select tag(c, ‘EpisodeOfCareId’) as Episode from Composition c where tag(c, ‘ReferralId’) = ‘’ ","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph"},{"type":"paragraph"}],"version":1}