Combine queries

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

mundi

Hi,

I wonder if there is any way to combine multiple queries.
To be more specific I have to do a search on several custom aspects.
An example for the queries to combine are the following:

select d.cmis:objectId from cmis:document as d join accident:reponse as a on d.cmis:objectId = a.cmis:objectId‍

and

select d.cmis:objectId from cmis:document as d join accident:foto as a on d.cmis:objectId = a.cmis:objectId‍

these two queries give me results. I've tried:

select d.cmis:objectId from cmis:document as d join accident:reponse as a on d.cmis:objectId = a.cmis:objectId join accident:foto as f on d.cmis:objectId = f.cmis:objectId;‍

but this won't give me any results.
Then I tried with the union

select d.cmis:objectId from cmis:document as d join accident:reponse as a on d.cmis:objectId = a.cmis:objectId union select d.cmis:objectId from cmis:document as d join accident:foto as a on d.cmis:objectId = a.cmis:objectId‍

but this returns me the error that the "Union" is unknown.
I'm using opencmis.

Has anyone an idea?

kaynezhang

keyword Union is not included in CMIS query specification