<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>Hi Felix,</p>
<p>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.</p>
<p>Best, Daniel.<br>
</p>
<br>
<div class="moz-cite-prefix">Am 27.03.2017 um 20:46 schrieb
<a class="moz-txt-link-abbreviated" href="mailto:f.noz@gmx.de">f.noz@gmx.de</a>:<br>
</div>
<blockquote
cite="mid:trinity-5082dbb0-07ff-423e-84cb-b0cf6b292077-1490640414515@3capp-gmx-bs04"
type="cite">
<div style="font-family: Verdana;font-size: 12.0px;">
<div>
<div>Hi Daniel,</div>
<div> </div>
<div>it's OpenCms 10.0.1</div>
<div>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.</div>
<div>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</div>
<div> </div>
<div>Ride1: recurring=false, date=01.05.2017</div>
<div>Ride2: recurring=true, date=01.05.2017</div>
<div>Ride3: recurring=true, date=01.06.2017</div>
<div>Ride4: recurring=false, date=01.06.2017</div>
<div> </div>
<div>should give the result in the folloging order:</div>
<div> </div>
<div>Ride3 -> Ride2 -> Ride4 -> Ride1</div>
<div> </div>
<div>using sort=recurring_s asc,date_dt desc results in
strange order so that's why I try it with group.</div>
<div>Any suggestions?</div>
<div> </div>
<div>Regards</div>
<div>Felix</div>
<div>
<div name="quote" style="margin:10px 5px 5px 10px; padding:
10px 0 10px 10px; border-left:2px solid #C3D9E5;
word-wrap: break-word; -webkit-nbsp-mode: space;
-webkit-line-break: after-white-space;">
<div style="margin:0 0 10px 0;"><b>Gesendet:</b> Mittwoch,
22. März 2017 um 14:10 Uhr<br>
<b>Von:</b> "Daniel Seidel" <a class="moz-txt-link-rfc2396E" href="mailto:d.seidel@alkacon.com"><d.seidel@alkacon.com></a><br>
<b>An:</b> <a class="moz-txt-link-abbreviated" href="mailto:opencms-dev@opencms.org">opencms-dev@opencms.org</a><br>
<b>Betreff:</b> Re: [opencms-dev] NPE when using group
in Solr search query</div>
<div name="quoted-content">
<div style="background-color: rgb(255,255,255);">
<p>Hi Felix,</p>
<p>could you please tell me your OpenCms-Version?</p>
<p>Best, Daniel.</p>
<div class="moz-cite-prefix">Am 22.03.2017 um 12:40
schrieb Felix Noz:</div>
<blockquote>
<div style="font-family: Verdana;font-size: 12.0px;">
<div style="font-family: Verdana;font-size:
12.0px;">
<div>Hi guys,</div>
<div> </div>
<div>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.</div>
<div>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.</div>
<div>Can anybody help me and tell me what's
going wrong there?</div>
<div> </div>
<div>Regards</div>
<div>Felix</div>
<div> </div>
<div>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.<br>
at
org.opencms.search.solr.CmsSolrIndex.search(CmsSolrIndex.java:1095)<br>
at
org.opencms.search.solr.CmsSolrIndex.search(CmsSolrIndex.java:507)<br>
at
org.opencms.file.collectors.CmsSolrCollector.getResults(CmsSolrCollector.java:193)<br>
at
org.opencms.file.collectors.CmsSolrCollector.getResults(CmsSolrCollector.java:169)<br>
at
org.opencms.jsp.CmsJspTagContentLoad.init(CmsJspTagContentLoad.java:575)<br>
at
org.opencms.jsp.CmsJspTagContentLoad.doStartTag(CmsJspTagContentLoad.java:235)<br>
at
org.apache.jsp.WEB_002dINF.jsp.offline.system.modules.XXX_002dlist_jsp._jspService(ride_002dlist_jsp.java:373)<br>
at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)<br>
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)<br>
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:443)<br>
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)<br>
at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)<br>
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)<br>
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)<br>
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)<br>
at
com.XXX.filter.BaseFilter.processFilter(BaseFilter.java:82)<br>
at
com.XXX.filter.WelcomeFilter.processFilter(WelcomeFilter.java:86)<br>
at
com.XXX.filter.BaseFilter.doFilter(BaseFilter.java:31)<br>
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)<br>
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)<br>
at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:726)<br>
at
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:592)<br>
at
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:526)<br>
at
org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDispatcher.java:191)<br>
at
org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:165)<br>
at
org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDispatcher.java:191)<br>
at
org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:165)<br>
at
org.opencms.loader.CmsJspLoader.service(CmsJspLoader.java:655)<br>
at
org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFlexRequestDispatcher.java:441)<br>
at
org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:169)<br>
at
org.opencms.jsp.CmsJspTagInclude.includeActionWithCache(CmsJspTagInclude.java:379)<br>
at
org.opencms.jsp.CmsJspTagInclude.includeTagAction(CmsJspTagInclude.java:244)<br>
at
org.opencms.jsp.CmsJspTagInclude.doEndTag(CmsJspTagInclude.java:490)<br>
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)<br>
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)<br>
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)<br>
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)<br>
at
org.apache.jsp.WEB_002dINF.jsp.offline.system.modules.org_opencms_ade_config.formatters.function_jsp._jspService(function_jsp.java:142)<br>
... 117 more<br>
Caused by: java.lang.NullPointerException<br>
at
org.opencms.search.solr.CmsSolrIndex.search(CmsSolrIndex.java:866)<br>
... 154 more</div>
</div>
<div> </div>
<div class="signature"> </div>
</div>
<fieldset class="mimeAttachmentHeader"> </fieldset>
<pre>_______________________________________________
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
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev" target="_blank">http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev</a>
</pre>
</blockquote>
<pre class="moz-signature">--
Kind Regards,
Daniel.
-------------------
Daniel Seidel
Alkacon Software GmbH & Co. KG - The OpenCms Experts
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.alkacon.com" target="_blank">http://www.alkacon.com</a> - <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.opencms.org" target="_blank">http://www.opencms.org</a> </pre>
_______________________________________________ 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 <a moz-do-not-send="true"
href="http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev"
target="_blank">http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev</a></div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
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
<a class="moz-txt-link-freetext" href="http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev">http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
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: <a class="moz-txt-link-abbreviated" href="mailto:d.seidel@alkacon.com">d.seidel@alkacon.com</a>
<a class="moz-txt-link-freetext" href="http://www.alkacon.com">http://www.alkacon.com</a>
<a class="moz-txt-link-freetext" href="http://www.opencms.org">http://www.opencms.org</a>
Amtsgericht Köln, HRA 32185, USt-IdNr.: DE259882372
Vertreten durch: Alkacon Verwaltungs GmbH
Geschäftsführer: Alexander Kandzior, Amtsgericht Köln, HRB 88218</pre>
</body>
</html>