Re: AQL support for an array of ehr_id

2018-08-31 Thread Dileep V S
Dear Ian,

Thanks for the pointer, I will check it out

regards

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

On Fri, Aug 31, 2018 at 10:25 PM, Ian McNicoll  wrote:

> It seems to work on Ethercis for this
>
> {
> "executedAQL": "SELECT e/ehr_id/value FROM EHR e WHERE e/ehr_id/value
> matches { 'cd8abecd-9925-4313-86af-93aab4930eae' ,
> '3a579ae0-0cbe-425b-9ac9-f15b83750481' }",
> "resultSet": [
> {
> "ehr_id/value": "3a579ae0-0cbe-425b-9ac9-f15b83750481"
> },
> {
> "ehr_id/value": "cd8abecd-9925-4313-86af-93aab4930eae"
> }
> ]
> }
>
> Certainly should be legal AQL .
> 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 Fri, 31 Aug 2018 at 17:44, Dileep V S  wrote:
>
>> Dear Ian,
>>
>> Thanks. Is this part of the AQL spec or a feature that THinkEhr has
>> implemented?
>>
>> Given the emerging importance of patient consent, given the GDPR and
>> similar rules coming our across the world (DISHA in India), this may become
>> a basic requirement in any EHR systems of the future. A static mapping of
>> an EHR to the creator organization, as is normal in provider centric
>> systems, may not be good enough.
>>
>> regards
>>
>>
>> Dileep V S
>> *Founder*
>> HealtheLife Ventures LLP
>> m: +91 9632888113
>> a: 106, Innovation Centre, IIIT, Electronics City, Bangalore 560100
>> w: healthelife.in  e: dil...@healthelife.in
>>
>> On Thu, Aug 30, 2018 at 11:11 PM, Ian McNicoll  wrote:
>>
>>> Hi Dileep - this is supported by THinkEhr...
>>>
>>> SELECT
>>>e/ehr_id/value, a/data[at0001]/events[at0006]/time,
>>>   a/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value,
>>>   a/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value --
>>> diastolic
>>>  FROM EHR e CONTAINS OBSERVATION a[openEHR-EHR-OBSERVATION.
>>> blood_pressure.v1]
>>> WHERE e/ehr_id/value MATCHES { 'e241715b-3ca7-435e-a474-718579aadaa2',
>>> '0e7ac1d6-2dc6-40ec-8259-ac9f9a9727d1', 'ed74f788-4bd6-4e47-ab98-
>>> 211643cc4b0c'}
>>>
>>> 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 Thu, 30 Aug 2018 at 18:23, Dileep V S  wrote:
>>>
 Hi,

 I am not sure if this has been asked before. I am asking again since I
 could not find an answer

 Does AQL support an array of EHRs? In AQL specs i can see examples to
 query any a single EHR and across all EHRs in the system. If I want to
 limit my query to a set of EHRs is it possible using AQL?

 Use case - As part of a dynamic consent management framework, we keep a
 dynamic mapping of EHRs to organizations. This is kept updated based on
 patient consent. So at any time a query is run by an organization, it
 should be limited to the EHRs that it has consent at that point of time.

 regards
 Dileep V S
 *Founder*
 HealtheLife Ventures LLP
 m: +91 9632888113
 a: 106, 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

>>>
>>> ___
>>> 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
>>
>
> ___
> 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 support for an array of ehr_id

2018-08-31 Thread Ian McNicoll
It seems to work on Ethercis for this

{
"executedAQL": "SELECT e/ehr_id/value FROM EHR e WHERE e/ehr_id/value
matches { 'cd8abecd-9925-4313-86af-93aab4930eae' ,
'3a579ae0-0cbe-425b-9ac9-f15b83750481' }",
"resultSet": [
{
"ehr_id/value": "3a579ae0-0cbe-425b-9ac9-f15b83750481"
},
{
"ehr_id/value": "cd8abecd-9925-4313-86af-93aab4930eae"
}
]
}

Certainly should be legal AQL .
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 Fri, 31 Aug 2018 at 17:44, Dileep V S  wrote:

> Dear Ian,
>
> Thanks. Is this part of the AQL spec or a feature that THinkEhr has
> implemented?
>
> Given the emerging importance of patient consent, given the GDPR and
> similar rules coming our across the world (DISHA in India), this may become
> a basic requirement in any EHR systems of the future. A static mapping of
> an EHR to the creator organization, as is normal in provider centric
> systems, may not be good enough.
>
> regards
>
>
> Dileep V S
> *Founder*
> HealtheLife Ventures LLP
> m: +91 9632888113
> a: 106, Innovation Centre, IIIT, Electronics City, Bangalore 560100
> w: healthelife.in  e: dil...@healthelife.in
>
> On Thu, Aug 30, 2018 at 11:11 PM, Ian McNicoll  wrote:
>
>> Hi Dileep - this is supported by THinkEhr...
>>
>> SELECT
>>e/ehr_id/value, a/data[at0001]/events[at0006]/time,
>>   a/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value,
>>   a/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value --
>> diastolic
>>  FROM EHR e CONTAINS OBSERVATION
>> a[openEHR-EHR-OBSERVATION.blood_pressure.v1]
>> WHERE e/ehr_id/value MATCHES { 'e241715b-3ca7-435e-a474-718579aadaa2',
>> '0e7ac1d6-2dc6-40ec-8259-ac9f9a9727d1',
>> 'ed74f788-4bd6-4e47-ab98-211643cc4b0c'}
>>
>> 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 Thu, 30 Aug 2018 at 18:23, Dileep V S  wrote:
>>
>>> Hi,
>>>
>>> I am not sure if this has been asked before. I am asking again since I
>>> could not find an answer
>>>
>>> Does AQL support an array of EHRs? In AQL specs i can see examples to
>>> query any a single EHR and across all EHRs in the system. If I want to
>>> limit my query to a set of EHRs is it possible using AQL?
>>>
>>> Use case - As part of a dynamic consent management framework, we keep a
>>> dynamic mapping of EHRs to organizations. This is kept updated based on
>>> patient consent. So at any time a query is run by an organization, it
>>> should be limited to the EHRs that it has consent at that point of time.
>>>
>>> regards
>>> Dileep V S
>>> *Founder*
>>> HealtheLife Ventures LLP
>>> m: +91 9632888113
>>> a: 106, 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
>>>
>>
>> ___
>> 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
>
___
openEHR-technical mailing list
openEHR-technical@lists.openehr.org
http://lists.openehr.org/mailman/listinfo/openehr-technical_lists.openehr.org


Re: AQL support for an array of ehr_id

2018-08-31 Thread Dileep V S
Dear Ian,

Thanks. Is this part of the AQL spec or a feature that THinkEhr has
implemented?

Given the emerging importance of patient consent, given the GDPR and
similar rules coming our across the world (DISHA in India), this may become
a basic requirement in any EHR systems of the future. A static mapping of
an EHR to the creator organization, as is normal in provider centric
systems, may not be good enough.

regards


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

On Thu, Aug 30, 2018 at 11:11 PM, Ian McNicoll  wrote:

> Hi Dileep - this is supported by THinkEhr...
>
> SELECT
>e/ehr_id/value, a/data[at0001]/events[at0006]/time,
>   a/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value,
>   a/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value --
> diastolic
>  FROM EHR e CONTAINS OBSERVATION a[openEHR-EHR-OBSERVATION.
> blood_pressure.v1]
> WHERE e/ehr_id/value MATCHES { 'e241715b-3ca7-435e-a474-718579aadaa2',
> '0e7ac1d6-2dc6-40ec-8259-ac9f9a9727d1', 'ed74f788-4bd6-4e47-ab98-
> 211643cc4b0c'}
>
> 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 Thu, 30 Aug 2018 at 18:23, Dileep V S  wrote:
>
>> Hi,
>>
>> I am not sure if this has been asked before. I am asking again since I
>> could not find an answer
>>
>> Does AQL support an array of EHRs? In AQL specs i can see examples to
>> query any a single EHR and across all EHRs in the system. If I want to
>> limit my query to a set of EHRs is it possible using AQL?
>>
>> Use case - As part of a dynamic consent management framework, we keep a
>> dynamic mapping of EHRs to organizations. This is kept updated based on
>> patient consent. So at any time a query is run by an organization, it
>> should be limited to the EHRs that it has consent at that point of time.
>>
>> regards
>> Dileep V S
>> *Founder*
>> HealtheLife Ventures LLP
>> m: +91 9632888113
>> a: 106, 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
>>
>
> ___
> 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