[opencms-dev] NPE when using group in Solr search query
Daniel Seidel
d.seidel at alkacon.com
Tue Mar 28 15:07:49 CEST 2017
Hi Felix,
have you checked if your recurring_s and date_dt fields are really
filled as expected? If so, I would expect "sort=recurring_s asc,date_dt
desc" to work.
Best, Daniel.
Am 27.03.2017 um 20:46 schrieb f.noz at gmx.de:
> Hi Daniel,
> it's OpenCms 10.0.1
> The exception doesn't occur when I use the solr parameter
> group.main=true but then I get only one result instead of a flat and
> grouped list of all results as mentioned in the solr doucmentation.
> Maybe my approach is wrong because I'm trying to solve a really banal
> problem. I just want the result first sorted by the boolean field
> ride_recurring (when value==true) and then by a date field descending,
> eg having the following resources
> Ride1: recurring=false, date=01.05.2017
> Ride2: recurring=true, date=01.05.2017
> Ride3: recurring=true, date=01.06.2017
> Ride4: recurring=false, date=01.06.2017
> should give the result in the folloging order:
> Ride3 -> Ride2 -> Ride4 -> Ride1
> using sort=recurring_s asc,date_dt desc results in strange order so
> that's why I try it with group.
> Any suggestions?
> Regards
> Felix
> *Gesendet:* Mittwoch, 22. März 2017 um 14:10 Uhr
> *Von:* "Daniel Seidel" <d.seidel at alkacon.com>
> *An:* opencms-dev at opencms.org
> *Betreff:* Re: [opencms-dev] NPE when using group in Solr search query
>
> Hi Felix,
>
> could you please tell me your OpenCms-Version?
>
> Best, Daniel.
>
> Am 22.03.2017 um 12:40 schrieb Felix Noz:
>
> Hi guys,
> there's an XmlContent which contains a field named ride_recurring
> of type OpenCmsBoolean. My goal is that the result of the query
> shows first all items with ride_recurring==false and only after
> that all items with ride_recurring==false.
> When omitting the grouping parameters the search works fine and
> all items are displayed non-grouped but as soon as adding
> &group=true&group.field=ride_recurring_s the exception below occurs.
> Can anybody help me and tell me what's going wrong there?
> Regards
> Felix
> Caused by: org.opencms.search.CmsSearchException: Ausführung des
> Queries "q=*:*&fl=*,score&qt=edismax&rows=5000&fq=expired:[NOW TO
> *]&fq=con_locales:de&fq=parent-folders:"/sites/default/"&fq=type:nb-ms-ride&fq=released:[*
> TO
> NOW]&fq=search_exclude:"false"&group.field=ride_recurring_s&group=true&start=0"
> schlug fehl.
> at
> org.opencms.search.solr.CmsSolrIndex.search(CmsSolrIndex.java:1095)
> at
> org.opencms.search.solr.CmsSolrIndex.search(CmsSolrIndex.java:507)
> at
> org.opencms.file.collectors.CmsSolrCollector.getResults(CmsSolrCollector.java:193)
> at
> org.opencms.file.collectors.CmsSolrCollector.getResults(CmsSolrCollector.java:169)
> at
> org.opencms.jsp.CmsJspTagContentLoad.init(CmsJspTagContentLoad.java:575)
> at
> org.opencms.jsp.CmsJspTagContentLoad.doStartTag(CmsJspTagContentLoad.java:235)
> at
> org.apache.jsp.WEB_002dINF.jsp.offline.system.modules.XXX_002dlist_jsp._jspService(ride_002dlist_jsp.java:373)
> at
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
> at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:443)
> at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)
> at
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
> at com.XXX.filter.BaseFilter.processFilter(BaseFilter.java:82)
> at
> com.XXX.filter.WelcomeFilter.processFilter(WelcomeFilter.java:86)
> at com.XXX.filter.BaseFilter.doFilter(BaseFilter.java:31)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
> at
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:726)
> at
> org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:592)
> at
> org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:526)
> at
> org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDispatcher.java:191)
> at
> org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:165)
> at
> org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDispatcher.java:191)
> at
> org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:165)
> at org.opencms.loader.CmsJspLoader.service(CmsJspLoader.java:655)
> at
> org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFlexRequestDispatcher.java:441)
> at
> org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:169)
> at
> org.opencms.jsp.CmsJspTagInclude.includeActionWithCache(CmsJspTagInclude.java:379)
> at
> org.opencms.jsp.CmsJspTagInclude.includeTagAction(CmsJspTagInclude.java:244)
> at
> org.opencms.jsp.CmsJspTagInclude.doEndTag(CmsJspTagInclude.java:490)
> at
> org.apache.jsp.WEB_002dINF.jsp.offline.system.modules.org_opencms_ade_config.formatters.function_jsp._jspx_meth_cms_005finclude_005f0(function_jsp.java:340)
> at
> org.apache.jsp.WEB_002dINF.jsp.offline.system.modules.org_opencms_ade_config.formatters.function_jsp._jspx_meth_c_005fwhen_005f0(function_jsp.java:288)
> at
> org.apache.jsp.WEB_002dINF.jsp.offline.system.modules.org_opencms_ade_config.formatters.function_jsp._jspx_meth_c_005fchoose_005f0(function_jsp.java:249)
> at
> org.apache.jsp.WEB_002dINF.jsp.offline.system.modules.org_opencms_ade_config.formatters.function_jsp._jspx_meth_cms_005fformatter_005f0(function_jsp.java:191)
> at
> org.apache.jsp.WEB_002dINF.jsp.offline.system.modules.org_opencms_ade_config.formatters.function_jsp._jspService(function_jsp.java:142)
> ... 117 more
> Caused by: java.lang.NullPointerException
> at
> org.opencms.search.solr.CmsSolrIndex.search(CmsSolrIndex.java:866)
> ... 154 more
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev
>
>
>
> --
> Kind Regards,
> Daniel.
>
> -------------------
>
> Daniel Seidel
>
> Alkacon Software GmbH & Co. KG - The OpenCms Experts
> http://www.alkacon.com -http://www.opencms.org
> _______________________________________________ This mail is sent to
> you from the opencms-dev mailing list To change your list options, or
> to unsubscribe from the list, please visit
> http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev
>
>
>
--
Daniel Seidel
-------------------
Alkacon Software GmbH & Co. KG - The OpenCms Experts
Daniel Seidel
An der Wachsfabrik 13
50996 Koeln, DE
Tel: +49 (0)2236 3826-16
Fax: +49 (0)2236 3826-20
Email: d.seidel at alkacon.com
http://www.alkacon.com
http://www.opencms.org
Amtsgericht Köln, HRA 32185, USt-IdNr.: DE259882372
Vertreten durch: Alkacon Verwaltungs GmbH
Geschäftsführer: Alexander Kandzior, Amtsgericht Köln, HRB 88218
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20170328/4e7c539c/attachment.htm>
More information about the opencms-dev
mailing list