Once you get a short overview on the queries, it is not that difficult to write them. CMIS queries can be written and called from CMIS API's in languages like Java, Python, etc. Also, you can directly write queries using the CMIS workbench for debugging and learning.
You might have already found some related resources online
ttps://chemistry.apache.org/docs/cmis-samples/samples/query-examples/index.html
This has some examples, probably in python
ttps://chemistry.apache.org/python/docs/examples.html#get-a-repository-object
On the other hand, if you can get a hold of this book PDF - CMIS and Apache Chemistry in Action,
then it contains a dedicated chapter at least on queries.
This CMIS and all looks like a deviation from resolving your original issue. However I hope this will help your Alfresco work in some way or other.
One custom example
Here we have our own custom type (slo) extending the cmis:content, which contains our custom aspect (slo:documentProperties) as mandatory.
documentProperties is our custom aspect of several properties
Trying to query with where clause containing conditions on our custom aspect properties (lo_link, lo_category)
SELECT doc.*, SLOALIAS.* FROM cmis:document AS doc JOIN slo:documentProperties AS SLOALIAS ON doc.cmis
bjectId = SLOALIAS.cmisbjectId WHERE IN_TREE(doc, 'workspace://SpacesStore/0a813931-e5d4-4a4a-82ad-8ccbbd1c2405') AND (SLOALIAS.slo:lo_link = 10) AND (SLOALIAS.slo:lo_category = 'Comp')
<types>
<type name="slo:lodocument">
<title>slo Document type</title>
<parent>cm:content</parent>
<!-- associations section - no associations as of now -->
<!-- aspect is defined to hold all the properties -->
<mandatory-aspects>
<aspect>slo:documentProperties</aspect>
</mandatory-aspects>
</type>
</types>
<aspect name="slo:documentProperties">
<title>lo document properties</title>
<properties>
<property name="slo:lo_category">
<title>Category</title>
<type>d:text</type>
</property>
<property name="slo:lo_link">
<title>Link ID</title>
<type>d:int</type>
</property>
...
Some queries from the book aforementioned
SELECT * FROM cmisbook:text where cmisbook:author IN ('Jane Taylor', 'Geoffrey Chaucer')
String:
SELECT * FROM cmisbook:text where cmisbook:author
IN ('Jane Taylor', 'Geoffrey Chaucer')
DateTime:
SELECT * FROM cmisbook:image WHERE cmis:creationDate
NOT IN ( TIMESTAMP '2011-06-30T12:00:00.000Z',
TIMESTAMP '2012-06-30T12:00:00.000+00:00')
ID:
SELECT * FROM cmis:document WHERE cmisbjectId IN
('130','131','132','133')
Integer:
SELECT * FROM cmisbook:audio WHERE cmisbook:year
NOT IN (1988, 1990)
Decimal:
SELECT * FROM cmisbook:video WHERE cmisbook:videoDuration
NOT IN (0, 60.0, 120.0)
To match a percent sign or underscore in a LIKE predicate, the escape character
backslash (\) must precede the % or _. This example returns all of the lyrics for song
titles that start with “Sacred_”:
SELECT cmisbook:songtitle FROM cmisbook:lyrics
WHERE cmisbook:songtitle LIKE 'Sacred\_%'
This example returns all of the lyrics in which the author name ends with “%Bleu”:
SELECT cmisbook:author FROM cmisbook:lyrics
WHERE cmisbook:author LIKE '%\%Bleu'
The following two examples
should both work to return all of the lyrics for documents where the song titles start
with “David’s”:
SELECT cmisbook:songtitle FROM cmisbook:lyrics
WHERE cmisbook:songtitle LIKE 'David''s%'
SELECT cmisbook:songtitle FROM cmisbook:lyrics
WHERE cmisbook:songtitle LIKE 'David\'s%'
Finally, if you want to match the backslash character itself, add another backslash. This
example matches “back\slash” in the song title:
SELECT cmisbook:songtitle FROM cmisbook:lyrics
WHERE cmisbook:songtitle LIKE 'back\\slash%'
Try testing a Boolean property for FALSE, or not set at all:
SELECT * from cmisbook:note where cmis:isVersionSeriesCheckedOut is null OR
cmis:isVersionSeriesCheckedOut = FALSE
SELECT * FROM cmisbook:note WHERE ANY cmisbook:noteLinks
NOT IN ( 'resource.txt' , 'test.txt') OR cmisbook:noteLinks IS NULL
