topic solr query exception while fetching the content between certain range in Alfresco Archive

solr query exception while fetching the content between certain range

skumar_us — Thu, 17 Oct 2013 18:25:33 GMT

I need to fetch the document between certain range say 40 to 75,when I enter my:num:"40".."70"(here my is content model and num is the property)in the search criteria I am getting the below errorQuery(PATH:"/app:company_home/st:sites/cm:my/*//*" AND (TYPE:"my:document" AND (my:num:"40".."70" )) )

Re: solr query exception while fetching the content between certain range

mitpatoliya — Fri, 18 Oct 2013 05:42:50 GMT

This
(my:num:"40".."70" )
should be replaced with following part

(@my\:num:[40 TO 70])

Re: solr query exception while fetching the content between certain range

skumar_us — Fri, 18 Oct 2013 08:42:00 GMT

Hi Mits,
tried with (@my\:num:[40 TO 70]) ,no success..got the same error with message"no viable alternative at input '@'"

I believe I need to pass it as num[40 to 70]
Query(PATH:"/app:company_home/st:sites/cm:my/*//*" AND (TYPE:"my:document" AND (num[40 to 70] )) ) AND -TYPE:"cm:thumbnail" AND -TYPE:"cm:failedThumbnail" AND -TYPE:"cm:rating") AND NOT ASPECT:"sys:hidden"

I am getting the below exception:
2013-10-18 14:53:44,646 ERROR [solr.core.SolrCore] [http-8443-7] java.lang.UnsupportedOperationException: Range is not supported against ml-text
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneQueryParser.getRangeQuery(AbstractLuceneQueryParser.java:2377)
   at org.alfresco.repo.search.impl.querymodel.impl.lucene.functions.LuceneFTSRange.addComponent(LuceneFTSRange.java:76)
   at org.alfresco.repo.search.impl.querymodel.impl.lucene.LuceneFunctionalConstraint.addComponent(LuceneFunctionalConstraint.java:58)
   at org.alfresco.repo.search.impl.querymodel.impl.lucene.LuceneDisjunction.addComponent(LuceneDisjunction.java:66)
   at org.alfresco.repo.search.impl.querymodel.impl.lucene.LuceneDisjunction.addComponent(LuceneDisjunction.java:66)
   at org.alfresco.repo.search.impl.querymodel.impl.lucene.LuceneConjunction.addComponent(LuceneConjunction.java:70)
   at org.alfresco.repo.search.impl.querymodel.impl.lucene.LuceneConjunction.addComponent(LuceneConjunction.java:70)
   at org.alfresco.repo.search.impl.querymodel.impl.lucene.LuceneConjunction.addComponent(LuceneConjunction.java:70)
   at org.alfresco.repo.search.impl.querymodel.impl.lucene.LuceneConjunction.addComponent(LuceneConjunction.java:70)

Re: solr query exception while fetching the content between certain range

mitpatoliya — Fri, 18 Oct 2013 09:33:42 GMT

The one I gave you is the correct one only.
Actually I can see many other errors as well in your query which may be causing issues.

First is issue with your path It should be as follow
PATH:"/app:company_home/st:sites/cm:my//*"

Then you are using combination of "AND", "-" and "NOT" which makes it prone to syntactical error are you able to execute this through node browser?

Re: solr query exception while fetching the content between certain range

kaynezhang — Fri, 18 Oct 2013 09:41:00 GMT

<strong>Range is not supported against ml-text<strong>， check your custom type ,make sure my:num property not d:mltext type

Re: solr query exception while fetching the content between certain range

skumar_us — Sat, 19 Oct 2013 14:42:00 GMT

I don't see any issue with the path as it is working fine when i search with the exact number.the exception I am getting only when i try with a range.
the below query is working fine.
((PATH:"/app:company_home/st:sites/cm:my/*//*" AND (TYPE:"my:document" AND (70 )) ) AND -TYPE:"cm:thumbnail" AND -TYPE:"cm:failedThumbnail" AND -TYPE:"cm:rating") AND NOT ASPECT:"sys:hidden"

Also your query is returning the results when i try from node browser.
but when i try from search textbox then only it is throwing the exception.

Re: solr query exception while fetching the content between certain range

skumar_us — Sat, 19 Oct 2013 14:43:53 GMT

I am not using d:mltext,the datatype for num property is d:int,but still it is throwing error as "Range is not supported against ml-text".So strange !!