Re: AQL for multi-occurrence nodes

[Bjørn Næss]

I would also look at the ITS specification.  
https://github.com/openEHR/specifications-ITS/tree/master/REST_API

There is a XSD there which defines some structures.



Vennlig hilsen
Bjørn Næss
Produktansvarlig
DIPS ASA


 Opprinnelig melding 
Fra: Thomas Beale 
Dato: 03.11.2017 18:27 (GMT+01:00)
Til: openehr-technical@lists.openehr.org
Emne: Re: AQL for multi-occurrence nodes


Dileep,

see 
here<https://openehr.atlassian.net/wiki/spaces/spec/pages/4915240/Ocean+Informatics+EHR+Service+Interface#OceanInformaticsEHRServiceInterface-DataStructures>.
 But I suggest you post this question on the implementers 
list<http://www.openehr.org/community/mailinglists> to see if someone can point 
you to classes already available.

- thomas

On 03/11/2017 02:47, Dileep V S wrote:
Dear Thomas,

Can you point me to details of Java structures

regards

___
openEHR-technical mailing list
openEHR-technical@lists.openehr.org
http://lists.openehr.org/mailman/listinfo/openehr-technical_lists.openehr.org

Re: AQL for multi-occurrence nodes

[Thomas Beale]

Dileep,

see here 
. 
But I suggest you post this question on the implementers list 
 to see if someone can 
point you to classes already available.


- thomas


On 03/11/2017 02:47, Dileep V S wrote:

Dear Thomas,

Can you point me to details of Java structures

regards


___
openEHR-technical mailing list
openEHR-technical@lists.openehr.org
http://lists.openehr.org/mailman/listinfo/openehr-technical_lists.openehr.org

Re: AQL for multi-occurrence nodes

[Dileep V S]

Dear Thomas,

Can you point me to details of Java structures

regards

Dileep V S
*Founder*
HealtheLife Ventures LLP
m: +91 9632888113
a: 103, Innovation Centre, IIIT, Electronics City, Bangalore 560100
w: healthelife.in  e: dil...@healthelife.in

On Thu, Nov 2, 2017 at 8:12 PM, Thomas Beale 
wrote:

> Hi Dileep
>
> On 27/10/2017 04:15, Dileep V S wrote:
>
> Hi,
>
> What is the expected response to AQL on a node with multiple occurrences?
> Does it return all the occurrences or only the first one?
>
>
> querying is always about returning everything that matches - it's a
> declarative concept, not a procedural one.
>
>
> If it is expected to return all occurrences, what is the structure of the
> response? will the occurrences be returned as an array?
>
>
> In REST terms, see here
> . If you want
> other structures, e.g. C# / Java / other language etc, please respond here,
> there are answers for that as well.
>
> - thomas
>
> --
> Thomas Beale
> Principal, Ars Semantica 
> Consultant, ABD Team, Intermountain Healthcare
> 
> Management Board, Specifications Program Lead, openEHR Foundation
> 
> Chartered IT Professional Fellow, BCS, British Computer Society
> 
> Health IT blog  | Culture blog
> 
>
> ___
> openEHR-technical mailing list
> openEHR-technical@lists.openehr.org
> http://lists.openehr.org/mailman/listinfo/openehr-
> technical_lists.openehr.org
>
___
openEHR-technical mailing list
openEHR-technical@lists.openehr.org
http://lists.openehr.org/mailman/listinfo/openehr-technical_lists.openehr.org

Re: AQL for multi-occurrence nodes

[Dileep V S]

Thanks everybody for the clarification.

regards

Dileep V S
*Founder*
HealtheLife Ventures LLP
m: +91 9632888113
a: 103, Innovation Centre, IIIT, Electronics City, Bangalore 560100
w: healthelife.in  e: dil...@healthelife.in

On Thu, Nov 2, 2017 at 10:43 PM, Pablo Pazos 
wrote:

>
>
> On Fri, Oct 27, 2017 at 3:15 AM, Dileep V S  wrote:
>
>> Hi,
>>
>> What is the expected response to AQL on a node with multiple occurrences?
>> Does it return all the occurrences or only the first one?
>>
>>
> If the query matches multiple occurrences of data defined by the same
> archetype node, then all the matched occurrences should be returned. It
> doesn't make sense to return the first occurrence since each occurrence
> contains different clinical data.
>
>
>> If it is expected to return all occurrences, what is the structure of the
>> response? will the occurrences be returned as an array?
>>
>
> IMO the result will have the structure of the items in the SELECT, if the
> query projection is a COMPOSITION, then the result will be a list of
> compositions, and those might contain multiple occurrences of a node. On
> this context, the match in the WHERE might be that exists a node at certain
> path that contains certain value, that path might have multiple occurrences
> of a node, and the resulting compositions will be returned if any of those
> occurrences have that value.
>
> If the SELECT has a projection for the matched nodes that might have
> multiple occurrences, a list of those nodes will be returned, and those
> might be from many COMPOSITIONs. If the results are just a plain list, it
> will be difficult to know which occurrences have the same context
> (contained on the same composition), I prefer to return the composition uid
> alongside with the data and a timestamp.
>
>
>>
>> If only the first one is returned, how do we get all the occurrences?
>> Adding multiple select lines in aql may not be practical as the number of
>> occurrences can vary.
>>
>
> I don't think this is an issue of AQL, but an implementations issue on not
> supporting multiple occurrences of nodes on query results. Multiple
> occurrences is a basic part of the openEHR spec IMO and very common in
> clinical records, like having more than one diagnosis on the same document.
>
> As Thomas said, the query should return anything that matches, multiple
> occurrences included.
>
>
>>
>> Can nay body give a select statement syntax for this?
>>
>> regards
>>
>> Dileep V S
>> *Founder*
>> HealtheLife Ventures LLP
>> m: +91 9632888113 <+91%2096328%2088113>
>> a: 103, Innovation Centre, IIIT, Electronics City, Bangalore 560100
>> w: healthelife.in  e: dil...@healthelife.in
>>
>> ___
>> openEHR-technical mailing list
>> openEHR-technical@lists.openehr.org
>> http://lists.openehr.org/mailman/listinfo/openehr-technical_
>> lists.openehr.org
>>
>
>
>
> --
> Ing. Pablo Pazos Gutiérrez
> e: pablo.pa...@cabolabs.com
> p: +598 99 043 145
> skype: cabolabs
> 
> http://www.cabolabs.com
> https://cloudehrserver.com
> Subscribe to our newsletter 
>
> ___
> openEHR-technical mailing list
> openEHR-technical@lists.openehr.org
> http://lists.openehr.org/mailman/listinfo/openehr-
> technical_lists.openehr.org
>
___
openEHR-technical mailing list
openEHR-technical@lists.openehr.org
http://lists.openehr.org/mailman/listinfo/openehr-technical_lists.openehr.org

Re: AQL for multi-occurrence nodes

[Pablo Pazos]

On Fri, Oct 27, 2017 at 3:15 AM, Dileep V S  wrote:

> Hi,
>
> What is the expected response to AQL on a node with multiple occurrences?
> Does it return all the occurrences or only the first one?
>
>
If the query matches multiple occurrences of data defined by the same
archetype node, then all the matched occurrences should be returned. It
doesn't make sense to return the first occurrence since each occurrence
contains different clinical data.


> If it is expected to return all occurrences, what is the structure of the
> response? will the occurrences be returned as an array?
>

IMO the result will have the structure of the items in the SELECT, if the
query projection is a COMPOSITION, then the result will be a list of
compositions, and those might contain multiple occurrences of a node. On
this context, the match in the WHERE might be that exists a node at certain
path that contains certain value, that path might have multiple occurrences
of a node, and the resulting compositions will be returned if any of those
occurrences have that value.

If the SELECT has a projection for the matched nodes that might have
multiple occurrences, a list of those nodes will be returned, and those
might be from many COMPOSITIONs. If the results are just a plain list, it
will be difficult to know which occurrences have the same context
(contained on the same composition), I prefer to return the composition uid
alongside with the data and a timestamp.


>
> If only the first one is returned, how do we get all the occurrences?
> Adding multiple select lines in aql may not be practical as the number of
> occurrences can vary.
>

I don't think this is an issue of AQL, but an implementations issue on not
supporting multiple occurrences of nodes on query results. Multiple
occurrences is a basic part of the openEHR spec IMO and very common in
clinical records, like having more than one diagnosis on the same document.

As Thomas said, the query should return anything that matches, multiple
occurrences included.


>
> Can nay body give a select statement syntax for this?
>
> regards
>
> Dileep V S
> *Founder*
> HealtheLife Ventures LLP
> m: +91 9632888113 <+91%2096328%2088113>
> a: 103, Innovation Centre, IIIT, Electronics City, Bangalore 560100
> w: healthelife.in  e: dil...@healthelife.in
>
> ___
> openEHR-technical mailing list
> openEHR-technical@lists.openehr.org
> http://lists.openehr.org/mailman/listinfo/openehr-
> technical_lists.openehr.org
>



-- 
Ing. Pablo Pazos Gutiérrez
e: pablo.pa...@cabolabs.com
p: +598 99 043 145
skype: cabolabs

http://www.cabolabs.com
https://cloudehrserver.com
Subscribe to our newsletter 
___
openEHR-technical mailing list
openEHR-technical@lists.openehr.org
http://lists.openehr.org/mailman/listinfo/openehr-technical_lists.openehr.org

Re: AQL for multi-occurrence nodes

[Ian McNicoll]

Hi - agree with Thomas and more here

https://github.com/ethercis/ethercis/issues/69

Ian


Dr Ian McNicoll
mobile +44 (0)775 209 7859
office +44 (0)1536 414994
skype: ianmcnicoll
email: i...@freshehr.com
twitter: @ianmcnicoll


Co-Chair, openEHR Foundation ian.mcnic...@openehr.org
Director, freshEHR Clinical Informatics Ltd.
Director, HANDIHealth CIC
Hon. Senior Research Associate, CHIME, UCL

On 2 November 2017 at 14:42, Thomas Beale  wrote:

> Hi Dileep
>
> On 27/10/2017 04:15, Dileep V S wrote:
>
> Hi,
>
> What is the expected response to AQL on a node with multiple occurrences?
> Does it return all the occurrences or only the first one?
>
>
> querying is always about returning everything that matches - it's a
> declarative concept, not a procedural one.
>
>
> If it is expected to return all occurrences, what is the structure of the
> response? will the occurrences be returned as an array?
>
>
> In REST terms, see here
> . If you want
> other structures, e.g. C# / Java / other language etc, please respond here,
> there are answers for that as well.
>
> - thomas
>
> --
> Thomas Beale
> Principal, Ars Semantica 
> Consultant, ABD Team, Intermountain Healthcare
> 
> Management Board, Specifications Program Lead, openEHR Foundation
> 
> Chartered IT Professional Fellow, BCS, British Computer Society
> 
> Health IT blog  | Culture blog
> 
>
> ___
> openEHR-technical mailing list
> openEHR-technical@lists.openehr.org
> http://lists.openehr.org/mailman/listinfo/openehr-
> technical_lists.openehr.org
>
___
openEHR-technical mailing list
openEHR-technical@lists.openehr.org
http://lists.openehr.org/mailman/listinfo/openehr-technical_lists.openehr.org

Re: AQL for multi-occurrence nodes

[Thomas Beale]

Hi Dileep


On 27/10/2017 04:15, Dileep V S wrote:

Hi,

What is the expected response to AQL on a node with multiple 
occurrences? Does it return all the occurrences or only the first one?


querying is always about returning everything that matches - it's a 
declarative concept, not a procedural one.




If it is expected to return all occurrences, what is the structure of 
the response? will the occurrences be returned as an array?


In REST terms, see here 
. If you want 
other structures, e.g. C# / Java / other language etc, please respond 
here, there are answers for that as well.


- thomas

--
Thomas Beale
Principal, Ars Semantica 
Consultant, ABD Team, Intermountain Healthcare 

Management Board, Specifications Program Lead, openEHR Foundation 

Chartered IT Professional Fellow, BCS, British Computer Society 

Health IT blog  | Culture blog 

___
openEHR-technical mailing list
openEHR-technical@lists.openehr.org
http://lists.openehr.org/mailman/listinfo/openehr-technical_lists.openehr.org

RE: AQL for multi-occurrence nodes

[Bjørn Næss]

This is a very interesting topic. I have written out some of the problems in 
this repo: https://github.com/DIPSASA/openehr-conformance/tree/master/aql

The general answer is that you need to write you AQL as detailed as possible. 
Meaning you need to know which level you expect the multiple occurences to 
appear. Take a look at the examples given above. I would be happy to answer 
follow ups on this.

Vennlig hilsen
Bjørn Næss
Produktansvarlig
DIPS ASA

Mobil +47 93 43 29 10

From: openEHR-technical [mailto:openehr-technical-boun...@lists.openehr.org] On 
Behalf Of Dileep V S
Sent: fredag 27. oktober 2017 08:15
To: For openEHR technical discussions 
Subject: AQL for multi-occurrence nodes

Hi,

What is the expected response to AQL on a node with multiple occurrences? Does 
it return all the occurrences or only the first one?

If it is expected to return all occurrences, what is the structure of the 
response? will the occurrences be returned as an array?

If only the first one is returned, how do we get all the occurrences?  Adding 
multiple select lines in aql may not be practical as the number of occurrences 
can vary.

Can nay body give a select statement syntax for this?

regards

[https://drive.google.com/uc?id=0BxQc41y9yqs6bkE5a1JQQVBjZG8]

Dileep V S

Founder

HealtheLife Ventures LLP

m:

+91 9632888113

a:

103, Innovation Centre, IIIT, Electronics City, Bangalore 560100

w:

healthelife.in<http://healthelife.in/>  e: 
dil...@healthelife.in<mailto:dil...@healthelife.in>


___
openEHR-technical mailing list
openEHR-technical@lists.openehr.org
http://lists.openehr.org/mailman/listinfo/openehr-technical_lists.openehr.org

AQL for multi-occurrence nodes

[Dileep V S]

Hi,

What is the expected response to AQL on a node with multiple occurrences?
Does it return all the occurrences or only the first one?

If it is expected to return all occurrences, what is the structure of the
response? will the occurrences be returned as an array?

If only the first one is returned, how do we get all the occurrences?
Adding multiple select lines in aql may not be practical as the number of
occurrences can vary.

Can nay body give a select statement syntax for this?

regards

Dileep V S
*Founder*
HealtheLife Ventures LLP
m: +91 9632888113
a: 103, Innovation Centre, IIIT, Electronics City, Bangalore 560100
w: healthelife.in  e: dil...@healthelife.in
___
openEHR-technical mailing list
openEHR-technical@lists.openehr.org
http://lists.openehr.org/mailman/listinfo/openehr-technical_lists.openehr.org