CONTAINS keyword usage in CMIS queries

charlie_k — Wed, 09 Sep 2015 14:28:28 GMT

Hello,I have CONTAINS keyword usage question. I am using Alfresco 5.0.d and trying to query my custom type objects via CMIS like thisELECT * FROM custom:type WHERE CONTAINS('test')‍I tested this query via OpenCMIS Workbench. I expected to get all custom:type entries where at least one of my custom

Re: CONTAINS keyword usage in CMIS queries

s_palyukh — Thu, 28 Jan 2016 16:08:00 GMT

Unfortunately, you will not be able to use pseudo-field "ALL", because it isn't implemented on alfresco side. Take a look at sources of method createAllQuery of class org.alfresco.solr.query.Solr4QueryParser:


protected Query createAllQuery(String queryText, AnalysisMode analysisMode, LuceneFunction luceneFunction) throws ParseException {
// Set<String> all = searchParameters.getAllAttributes();
// if ((all null) || (all.size() 0))
// {
// Collection<QName> contentAttributes = dictionaryService.getAllProperties(null);
// BooleanQuery query = new BooleanQuery();
// for (QName qname : contentAttributes)
// {
// // The super implementation will create phrase queries etc if required
// Query part = getFieldQuery(PROPERTY_FIELD_PREFIX + qname.toString(), queryText, analysisMode, luceneFunction);
// if (part != null)
// {
// query.add(part, Occur.SHOULD);
// }
// else
// {
// query.add(createNoMatchQuery(), Occur.SHOULD);
// }
// }
// return query;
// }
// else
// {
// BooleanQuery query = new BooleanQuery();
// for (String fieldName : all)
// {
// Query part = getFieldQuery(fieldName, queryText, analysisMode, luceneFunction);
// if (part != null)
// {
// query.add(part, Occur.SHOULD);
// }
// else
// {
// query.add(createNoMatchQuery(), Occur.SHOULD);
// }
// }
// return query;
// }
throw new UnsupportedOperationException();
}
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

So, you always receive UnsupportedOperationException, because other lines are commented.

topic Re: CONTAINS keyword usage in CMIS queries in Alfresco Archive

CONTAINS keyword usage in CMIS queries

Re: CONTAINS keyword usage in CMIS queries