Hello,
I try to use the function CONTAINS in my query but I can not to get my documents with it.
SELECT * FROM my:medatas WHERE my:type='TYPE1'
works fine. While the query :
SELECT * FROM my:medatas m WHERE CONTAINS(m, 'TYPE1')
works (no exceptions) but I have not any documents.
I want to use this function because I would like to make a search on all the properties and not only on my:type.
Solved! Go to Solution.
Hi
CMIS CONTAINS() by default matches only content.
If you are using the public API it is possible to change this default.
There is an example here.
You can specify the field in the query. Beware, the CMIS specification is quite limited but we support any Alfresco full text search expression in CONTAINS() - the CMIS specification is a sub-set that assumes you mean content.
SELECT * FROM my:medatas WHERE CONTAINS('my:type=TYPE1')
Andy
Hi
CMIS CONTAINS() by default matches only content.
If you are using the public API it is possible to change this default.
There is an example here.
You can specify the field in the query. Beware, the CMIS specification is quite limited but we support any Alfresco full text search expression in CONTAINS() - the CMIS specification is a sub-set that assumes you mean content.
SELECT * FROM my:medatas WHERE CONTAINS('my:type=TYPE1')
Andy
Ask for and offer help to other Alfresco Content Services Users and members of the Alfresco team.
Related links:
By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods). If you are not ok with these terms, please do not use this website.