Uploaded image for project: 'CMS'
  1. CMS
  2. CMS-9017

Error when using a filter : Unable to parse string literal for xs:dateTime

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 4.1.0
    • Fix Version/s: 4.1.0
    • Component/s: Général
    • Labels:
      None
    • Sprint:
      4.1 RC1

      Description

      This is my filter :

      <?xml version="1.0" encoding="UTF-8"?>
      <!--
         Copyright 2010 Anyware Services
      
         Licensed under the Apache License, Version 2.0 (the "License");
         you may not use this file except in compliance with the License.
         You may obtain a copy of the License at
      
             http://www.apache.org/licenses/LICENSE-2.0
      
         Unless required by applicable law or agreed to in writing, software
         distributed under the License is distributed on an "AS IS" BASIS,
         WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
         See the License for the specific language governing permissions and
         limitations under the License.
         -->
      <filters>
      
           <filter id="alerte" target="content">
           	<handle-user-access>true</handle-user-access> 
              <context type="current-site"/>
               <content-types> 
                   <type id="content-type.alertes"/> 
              </content-types> 
               <view>abstract</view> 
              <metadata condition="AND">
                  <metadata id="start-date" type="date" operator="lte">today</metadata>
                  <metadata id="end-date" type="date" operator="gte">today</metadata>
              </metadata>         
               <sort-information> 
                   <sort metadataId="publication-date" ascending="true"/> 
               </sort-information>                  
           </filter> 
           
      </filters>
      

      This is the error :

      Caused by: org.ametys.plugins.repository.AmetysRepositoryException: An error occured executing the JCR query : //element(*, ametys:content)[((@ametys-internal:contentType = 'content-type.alertes' and (@ametys:start-date < xs:dateTime('2018-02-13T00:00:00+01:00') and @ametys:end-date >= xs:dateTime('2018-02-12T00:00:00+01:00'))) and (@ametys:site = 'intranet' and @ametys-internal:language ='fr'))] order by @ametys:publication-date ascending
      	at org.ametys.plugins.repository.AmetysObjectResolver.query(AmetysObjectResolver.java:646)
      	at org.ametys.web.filter.DefaultWebContentFilter.getMatchingContents(DefaultWebContentFilter.java:301)
      	at org.ametys.web.filter.DefaultWebContentFilter.getMatchingContents(DefaultWebContentFilter.java:220)
      	at org.ametys.web.filter.ContentFilterHelper.saxMatchingContents(ContentFilterHelper.java:118)
      	at org.ametys.web.tags.inputdata.FilteredContentsInputData.saxFilter(FilteredContentsInputData.java:203)
      	at org.ametys.web.tags.inputdata.FilteredContentsInputData.toSAX(FilteredContentsInputData.java:110)
      	at org.ametys.web.inputdata.InputDataGenerator.generate(InputDataGenerator.java:155)
      	at org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.processXMLPipeline(AbstractProcessingPipeline.java:581)
      	... 53 more
      Caused by: javax.jcr.query.InvalidQueryException: Unable to parse string literal for xs:dateTime: 2018-02-13T00:00:00+01:00
      

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              fravetier Frederic Ravetier
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: