Uploaded image for project: 'Service Packs and Hot Fixes'
  1. Service Packs and Hot Fixes
  2. MNT-4175

Using the modification date in the CMIS-SQL WHERE clause doesn't work (web services binding)

    Details

    • Type: Bug
    • Status: Closed
    • Resolution: Not a bug
    • Affects Version/s: 3.3
    • Fix Version/s: 3.3.4
    • Component/s: CMIS
    • Labels:
      None
    • Environment:
      Windows + MySQL (everything was installed using the Alfresco windows installer)
    • Bug Priority:
      Category 2

      Description

      Executing this query : SELECT cmis:name, cmis:lastModificationDate FROM cmis:document WHERE (cmis:name='test.doc' AND cmis:lastModificationDate=TIMESTAMP'2010-09-23T16:56:49.925+02:00'

      returns a document whose modification date doesn't match the date specific in the query.

      Outgoing SOAP request
      ------------------------------------
      <soap:Body>
      <query xmlns="http://docs.oasis-open.org/ns/cmis/messaging/200908/"
      xmlns:ns2="http://docs.oasis-open.org/ns/cmis/core/200908/">
      <repositoryId>9d929533-6e96-4e0e-aa7e-d679069b03c9</repositoryId>
      <statement>SELECT cmis:name, cmis:lastModificationDate FROM cmis:document WHERE (cmis:name='test.doc' AND cmis:lastModificationDate=TIMESTAMP'2010-09-23T16:56:49.925+02:00')</statement>
      <searchAllVersions>false</searchAllVersions>
      <includeAllowableActions>false</includeAllowableActions>
      <includeRelationships>none</includeRelationships>
      <renditionFilter xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />
      <maxItems>3</maxItems>
      <skipCount>0</skipCount>
      <extension />
      </query>
      </soap:Body>

      Incoming SOAP response (returned date doesn't match the date specified in the WHERE clause)
      --------------------------------------------------------------------------------------------------------------------------------------------
      <soap:Body>
      <queryResponse xmlns="http://docs.oasis-open.org/ns/cmis/messaging/200908/"
      xmlns:ns2="http://docs.oasis-open.org/ns/cmis/core/200908/"
      xmlns:ns3="http://www.alfresco.org">
      <objects>
      <objects>
      <ns2:properties>
      <ns2:propertyString propertyDefinitionId="cmis:name" queryName="cmis:name">
      <ns2:value>test.doc</ns2:value>
      </ns2:propertyString>
      <ns2:propertyDateTime propertyDefinitionId="cmis:lastModificationDate" queryName="cmis:lastModificationDate">
      <ns2:value>2010-09-23T16:56:50.925+02:00</ns2:value>
      </ns2:propertyDateTime>
      </ns2:properties>
      </objects>
      <hasMoreItems>false</hasMoreItems>
      <numItems>1</numItems>
      </objects>
      </queryResponse>
      </soap:Body>

        Attachments

          Issue Links

            Structure

              Activity

                People

                • Assignee:
                  closedissues Closed Issues
                  Reporter:
                  laurent.kubaski@entropysoft.net laurent kubaski (Inactive)
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - 0 minutes
                    0m
                    Logged:
                    Time Spent - 2 days, 2 hours, 50 minutes
                    2d 2h 50m

                      Structure Helper Panel