# AQL problems with the clause 'CONTAINS' searching for an EHR with two different compositions

**Category:** [Platform](https://discourse.openehr.org/c/platform-implem/7)
**Created:** 2023-03-29 10:10 UTC
**Views:** 380
**Replies:** 3
**URL:** https://discourse.openehr.org/t/aql-problems-with-the-clause-contains-searching-for-an-ehr-with-two-different-compositions/3765

---

## Post #1 by @Miguel_Frias_Carmona

I'm trying to search an ehr with two COMPOSITIONS. I'm doing this query:

"q": "SELECT e/ehr_id/value FROM EHR e CONTAINS (COMPOSITION c1 [openEHR-EHR-COMPOSITION.observation_basica.v0]) AND (COMPOSITION c2 [openEHR-EHR-COMPOSITION.evaluation_basica.v0])"

It returns 0 rows, but it should returns 1.

I have tried with "(" and without it, but not works correctly.

Any help? 

Thanks!

---

## Post #2 by @ian.mcnicoll

[quote="Miguel_Frias_Carmona, post:1, topic:3765"]
“q”: “SELECT e/ehr_id/value FROM EHR e CONTAINS (COMPOSITION c1 [openEHR-EHR-COMPOSITION.observation_basica.v0]) AND (COMPOSITION c2 [openEHR-EHR-COMPOSITION.evaluation_basica.v0])”
[/quote]

Have you tried

```sql
“q”: “SELECT e/ehr_id/value FROM EHR e CONTAINS (COMPOSITION c1 [openEHR-EHR-COMPOSITION.observation_basica.v0] AND COMPOSITION c2 [openEHR-EHR-COMPOSITION.evaluation_basica.v0])”
```

---

## Post #3 by @Miguel_Frias_Carmona

Thanks for the response. In this way I had already tried it. The query continues to return 0 rows.

---

## Post #4 by @ian.mcnicoll

Thanks Miguel,

I can replicate this on EhrBase i.e no rows found where there should be 1.

```
select e/ehr_id/value as ehrId, 
c/archetype_details/archetype_id/value as archetype1,
c/uid/value as uid,
c/context/start_time/value as compositionStartTime,
c/name/value as compositionName,
c2/name/value as compositionName2,
c2/uid/value as uid2,
c2/archetype_details/archetype_id/value as archetype2,
c2/context/start_time/value as compositionStartTime2 
from EHR e
contains (COMPOSITION c [openEHR-EHR-COMPOSITION.report-result.v1] AND COMPOSITION c2[openEHR-EHR-COMPOSITION.transfer_summary.v1])
```

Can I suggest you report this as a bug at https://github.com/ehrbase/ehrbase ?

---


**Canonical:** https://discourse.openehr.org/t/aql-problems-with-the-clause-contains-searching-for-an-ehr-with-two-different-compositions/3765
**Original content:** https://discourse.openehr.org/t/aql-problems-with-the-clause-contains-searching-for-an-ehr-with-two-different-compositions/3765