OpenEHR queries

2007-11-05 Thread Chunlan Ma
Hi Greg, Rong has indicated there is a paper about archetype query language. Thanks Rong. That paper introduced basic query syntax. It was written at the beginning of this year. The query syntax has been enriched recently in order to support more complicated queries. I've already started to write

OpenEHR queries

2007-11-05 Thread Heath Frankel
Hi Greg, The Archetype Query Language (AQL, formerly known as EHR Query language or EQL) was developed by Ocean Informatics and a specification is being prepared to be offered to the openEHR foundation as a candidate openEHR specification. For now the paper referred to by Rong is the main referenc

OpenEHR queries

2007-11-05 Thread Greg Caulton
I appreciate the information. Writing new queries wouldn't be too hard, it is parsing the queries and then executing the corresponding queries or service calls against the implemented system that is the tricky part. Is Ocean Informatics planning to provide a open source java (or similar language)

OpenEHR queries

2007-11-05 Thread Greg Caulton
Question on the query below, if at0004 occurs *only* once in the archetype model, in the position data[at0001]/events[at0002]/data[at0003]/items[at0004]/value, could one theoretically have the shorter query SELECT o/items[at0004]/value FROM EHR [uid = $ehrUid] CONTAINS OBSERVATION o [openEHR-EHR-O

OpenEHR queries

2007-11-05 Thread Thomas Beale
Greg Caulton wrote: > Thanks Rong, > > Just the thought for someone but it would be handy to have the XPath > (such as o/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value/value) > for a data value somewhere accessible in the editor or in the html > generated content such as > http://svn.

OpenEHR queries

2007-11-05 Thread Thomas Beale
Greg Caulton wrote: > Question on the query below, if at0004 occurs *only* once in the > archetype model, in the position > data[at0001]/events[at0002]/data[at0003]/items[at0004]/value, could > one theoretically have the shorter query > Greg, while it is sometimes the case that an at-code is uni

Searching/Accessing your data was: OpenEHR queries

2007-11-05 Thread Tim Cook
On Mon, 2007-11-05 at 06:18 -0500, Greg Caulton wrote: > Of course that would break if a new data element was added in a > position (fabricated) > data[at0001]/events[at0099]/data[at00100]/items[at0004]/value but the > simplicity is tempting. This is of course why you should (IMHO) change your fo

Searching/Accessing your data was: OpenEHR queries

2007-11-05 Thread Greg Caulton
One reason for the question was that it wasn't clear whether the at uniquely identifies a concept within the ADL. I think it still does, but it can have different context depending on where it occurs. Implementing a hierarchy of information (information model) using entity relationships (data

OpenEHR queries

2007-11-05 Thread Randolph Neall
k/mailman/listinfo/openehr-technical > ___ > openEHR-technical mailing list > openEHR-technical at openehr.org > http://lists.chime.ucl.ac.uk/mailman/listinfo/openehr-technical > -- next part -- An HTML attachment was scrubbed... URL: <http://lists.openehr.org/mailman/private/openehr-technical_lists.openehr.org/attachments/20071105/5145b2c3/attachment.html>

Searching/Accessing your data was: OpenEHR queries

2007-11-05 Thread Gerard Freriks
e/openehr-technical_lists.openehr.org/attachments/20071105/3f4ea615/attachment.html>

Searching/Accessing your data was: OpenEHR queries

2007-11-05 Thread Tim Cook
On Mon, 2007-11-05 at 19:25 +0100, Gerard Freriks wrote: > > Why? > > > (Not that I intend to do that) > > > On Nov 5, 2007, at 1:20 PM, Tim Cook wrote: > > > (please do NOT use MySQL for healthcare > > information) I will "assume" that your WHY? question was in response to this statement

Searching/Accessing your data was: OpenEHR queries

2007-11-05 Thread Thomas Beale
Greg Caulton wrote: > One reason for the question was that it wasn't clear whether the > at uniquely identifies a concept within the ADL. I think it still > does, but it can have different context depending on where it occurs. > it doesn't in general. In certain archetypes it happens to, bu

Searching/Accessing your data was: OpenEHR queries

2007-11-05 Thread Bert Verhees
Tim Cook schreef: > On Mon, 2007-11-05 at 19:25 +0100, Gerard Freriks wrote: > >> Why? >> >> >> (Not that I intend to do that) >> >> > > >> On Nov 5, 2007, at 1:20 PM, Tim Cook wrote: >> >> >>> (please do NOT use MySQL for healthcare >>> information) >>> > > > I will "assume

XML versions of the ADL

2007-11-05 Thread Greg Caulton
In writing some code to parse the XML to populate my database I notice there is not always a matching XML on subversion for a given ADL. For example there is http://svn.openehr.org/knowledge/archetypes/dev/adl/openehr/ehr/entry/observation/openEHR-EHR-OBSERVATION.blood_pressure.v1.adl http://svn

OpenEHR queries

2007-11-05 Thread Randolph Neall
the query) > > Or is this future functionality? > > thanks > > Greg > > http://www.patientos.org > ___ > openEHR-technical mailing list > openEHR-technical at openehr.org > http://lists.chime.ucl.ac.uk/mailman/listinfo/openehr-technical > ___ > openEHR-technical mailing list > openEHR-technical at openehr.org > http://lists.chime.ucl.ac.uk/mailman/listinfo/openehr-technical > > > > ___ > openEHR-technical mailing list > openEHR-technical at openehr.org > http://lists.chime.ucl.ac.uk/mailman/listinfo/openehr-technical > > -- next part -- An HTML attachment was scrubbed... URL: <http://lists.openehr.org/mailman/private/openehr-technical_lists.openehr.org/attachments/20071105/18b7507e/attachment.html>

OpenEHR queries

2007-11-05 Thread Randolph Neall
> Somewhere I recall reading that there was an OpenEHR query that > > theoretically an OpenEHR compliant system could execute a return > > results for. > > > > Is there a spec somewhere, preferably with a simple example. > > > > So if someone knew my patient and queried for all instances of > > Respiratory Rate grea