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

[PhilBarrett]

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

[freshehr]

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 notifications@github.com 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 https://github.com/RippleOSI/Ripple-openEHR/issues/5#issuecomment-309379729, or mute the thread https://github.com/notifications/unsubscribe-auth/ABQ4RQymv9uEbjMzAPdEB5_IfOTVa-tdks5sFjfJgaJpZM4N7fw0 .

-- Ian McNicoll

[PhilBarrett]

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

[PhilBarrett]

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

[robtweed]

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

[tony-shannon]

@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

[ethercis]

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)

[tony-shannon]

thanks @ethercis

@robtweed fyi

On 30 June 2017 at 03:48, Christian Chevalley notifications@github.com 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 https://github.com/ethercis/ethercis/issues/25 requires more work to be addressed properly (please see #25 https://github.com/ethercis/ethercis/issues/25 for more on this)

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/RippleOSI/Ripple-openEHR/issues/5#issuecomment-312160820, or mute the thread https://github.com/notifications/unsubscribe-auth/AA5X3K0gKgpijvGuXU1uEEzOZXWbc9lZks5sJGIXgaJpZM4N7fw0 .

[robtweed]

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

[robtweed]

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

[ethercis]

 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.

[robtweed]

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 :-)