<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>