topic ORDER BY on custom properties added to model in Alfresco Archive

ORDER BY on custom properties added to model

mcs130 — Fri, 14 Sep 2012 01:33:15 GMT

Hello,Question re: querying back for Document instances when using a custom model XML file.I have the section of our model XML which we have created and started the server with and then successfully uploaded documents… populating the properties defined: <types> <!– Enterprise-wide ge

Re: ORDER BY on custom properties added to model

afaust — Fri, 14 Sep 2012 07:06:44 GMT

Hello,

can you check the logs on the SOLR server for any error output? I'd assume a 500 response should also leave an error report in there somewhere.

Regards
Axel

Re: ORDER BY on custom properties added to model

mcs130 — Fri, 14 Sep 2012 13:59:43 GMT

Here is what we are finding: there is in fact a SOLR error encountered attempting to use the ORDER BY involving the custom properties. Is there something else we should have included in the XML file for configuration?

Thanks

Sep 13, 2012 9:23:35 PM org.apache.solr.common.SolrException log
10462 SEVERE: org.apache.chemistry.opencmis.commons.exceptions.CmisInvalidArgumentException: Ordering is not support for acme:displayName
10463 at org.alfresco.opencmis.search.CMISQueryParser.buildOrderings(CMISQueryParser.java:915)
10464 at org.alfresco.opencmis.search.CMISQueryParser.parse(CMISQueryParser.java:154)
10465 at org.alfresco.solr.AlfrescoSolrDataModel.parseCMISQueryToAlfrescoAbstractQuery(AlfrescoSolrDataModel.java:1038)
10466 at org.alfresco.solr.query.CmisQParserPlugin$CmisQParser.parse(CmisQParserPlugin.java:88)
10467 at org.apache.solr.search.QParser.getQuery(QParser.java:131)
10468 at org.apache.solr.handler.component.QueryComponent.prepare(QueryComponent.java:89)
10469 at org.apache.solr.handler.component.SearchHandler.handleRequestBody(SearchHandler.java:174)
10470 at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:131)
10471 at org.apache.solr.core.SolrCore.execute(SolrCore.java:1316)
10472 at org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter.java:338)

Re: ORDER BY on custom properties added to model

afaust — Sat, 15 Sep 2012 12:05:12 GMT

Hello,

please note that text properties with tokenized = true are not orderable - those need to be set to either false or both.

Regards
Axel

Re: ORDER BY on custom properties added to model

mcs130 — Sat, 15 Sep 2012 12:31:42 GMT

We will give that a try…I think we had used false before and had the same issue but I will try the 2 different settings…based on what we show in the XML file content , I assume this should be the only adjustment.?

Thanks

Re: ORDER BY on custom properties added to model

mcs130 — Sat, 15 Sep 2012 20:13:44 GMT

Axel

I used the value "both" instead of "false" and IT WORKS CORRECTLY now with our custom properties of type d:text. Thank you again for your help with this.

Regards

Mark