EtherCIS Clinical Query - Ian to explain what Rob can do to support "friendly API wrapper around the JSON AQL

Question

EtherCIS Clinical Query - Ian to explain what Rob can do to support "friendly API wrapper around the JSON AQL

Closed this issue 7 years ago · 12 comments

PhilBarrett commented 7 years ago

Answer 1 · 2017-06-19T08:56:39.000Z

@freshehr Please could I ask for an update on this, thanks

Answer 2 · 2017-06-19T09:22:40.000Z

Discussed with Rob on Friday and he says he understands what needs to be done now

On Mon, 19 Jun 2017 at 09:56, PhilBarrett ***@***.***> wrote: @freshehr <https://github.com/freshehr> Please could I ask for an update on this, thanks — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#5 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ABQ4RQymv9uEbjMzAPdEB5_IfOTVa-tdks5sFjfJgaJpZM4N7fw0> .

-- Ian McNicoll

Answer 3 · 2017-06-19T12:59:57.000Z

Thanks @freshehr , @robtweed please can you update here once progressed, thanks

Answer 4 · 2017-06-29T07:56:40.000Z

Linked with ethercis/ethercis#25 and ethercis/ethercis#26

Answer 5 · 2017-06-29T09:10:10.000Z

Clinical query middle tier is done - awaiting UI and Ethercis issues to be sorted out

Answer 6 · 2017-06-29T16:47:44.000Z

@freshehr @ethercis
Can we get an update on these 2 issues please;
ethercis/ethercis#25 and ethercis/ethercis#26
This fix is dependent on them
thanks
T

Answer 7 · 2017-06-30T02:48:55.000Z

I have posted a new aql-processor lib on the test server. It should address these two issues. Please note though that re ethercis/ethercis#25 requires more work to be addressed properly (please see #25 for more on this)

Answer 8 · 2017-06-30T13:25:47.000Z

thanks @ethercis @robtweed fyi

…

On 30 June 2017 at 03:48, Christian Chevalley ***@***.***> wrote: I have posted a new aql-processor lib on the test server. It should address these two issues. Please note though that re ethercis/ethercis#25 <ethercis/ethercis#25> requires more work to be addressed properly (please see #25 <ethercis/ethercis#25> for more on this) — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#5 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AA5X3K0gKgpijvGuXU1uEEzOZXWbc9lZks5sJGIXgaJpZM4N7fw0> .

Answer 9 · 2017-06-30T13:46:20.000Z

Christian - it's still not working correctly. The following query should return 9999999000 but I get an empty resultSet coming back:

select
e/ehr_id/value as ehrId,
e/ehr_status/subject/external_ref/id/value as nhsNo
from EHR e
contains COMPOSITION a
contains EVALUATION a_a[openEHR-EHR-EVALUATION.adverse_reaction_risk.v1]
where a/name/value='Adverse reaction list'
and
a_a/data[at0001]/items[at0002]/value/value like 'Peanut'

eg 9999999000 has a number of allergy records where cause is "Allergy to Peanut Butter". The pattern match should be case insensitive, so

a_a/data[at0001]/items[at0002]/value/value like 'peanut'

should also work

Answer 10 · 2017-06-30T13:48:37.000Z

The text formatting has removed the * from around "Peanut" .... should be '{asterisk}Peanut{asterisk} ' where {asterisk} = *

Answer 11 · 2017-06-30T13:54:51.000Z

Ah ok. As specified by @fresher the asterisk was a percent % :( what is the correct syntax ?On Jun 30, 2017 8:48 PM, robtweed <notifications@github.com> wrote:The text formatting has removed the * from around "Peanut" .... should be '{asterisk}Peanut{asterisk} ' where {asterisk} = * —You are receiving this because you were mentioned.Reply to this email directly, view it on GitHub, or mute the thread.

Answer 12 · 2017-06-30T13:58:28.000Z

Actually it appears that % works on both Ethercis and Marand now. So I'll use % around the "likes" instead of * I guess Ian gave me the wrong info :-)