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

CMIS query doesn't return any result when documents are created with a different lang

    Details

    • Type: Service Pack Request
    • Status: Closed
    • Resolution: Fixed
    • Affects Version/s: 3.3.4, 3.4
    • Fix Version/s: 3.4.5
    • Component/s: CMIS
    • Labels:
      None
    • Bug Priority:
      Category 2
    • ACT Numbers:

      15024-25771

      Description

      [ Steps to reproduce ]

      1. Connecting to Alfresco using French language setting (i.e. Accept-Language = fr,en;q=0.9,el;q=0.7,sq;q=0.6,fr-fr;q=0.4,en-gb;q=0.3,en-us;q=0.1)
      2. Creating a document with title, name, content, description = "bagnole" (without quotes)
      3. Executing a HTTP query: http://localhost:8080/alfresco/service/cmis/query?q=select%20*%20from%20cmis:document%20where%20cmis:name%20like%20%27%25bagnole%25%27
      including http header: Accept-Language = fr,en;q=0.9,el;q=0.7,sq;q=0.6,fr-fr;q=0.4,en-gb;q=0.3,en-us;q=0.1

      We got 1 result:

      <?xml version="1.0" encoding="UTF-8"?>
      <feed xmlns="http://www.w3.org/2005/Atom" xmlns:app="http://www.w3.org/2007/app" xmlns:cmisra="http://docs.oasis-open.org/ns/cmis/restatom/200908/" xmlns:cmis="http://docs.oasis-open.org/ns/cmis/core/200908/" xmlns:alf="http://www.alfresco.org" xmlns:opensearch="http://a9.com/-/spec/opensearch/1.1/">
      <author><name>admin</name></author>
      <generator version="3.4.0 (168)">Alfresco (Enterprise)</generator>
      <icon>http://localhost:8080/alfresco/images/logo/AlfrescoLogo16.ico</icon>
      <id>http://www.alfresco.org/rss/atom/urn:uuid:resultset</id>
      <link rel="service" href="http://localhost:8080/alfresco/service/cmis"/>
      <link rel="self" href="http://localhost:8080/alfresco/service/cmis/query?q=select%20*%20from%20cmis:document%20where%20cmis:name%20like%20%27%25bagnole%25%27"/>
      <link rel="first" href="http://localhost:8080/alfresco/service/cmis/query?q=select%20*%20from%20cmis:document%20where%20cmis:name%20like%20%27%25bagnole%25%27&pageNo=1&pageSize=-1&guest=" type="application/atom+xml;type=feed"/>

      <link rel="last" href="http://localhost:8080/alfresco/service/cmis/query?q=select%20*%20from%20cmis:document%20where%20cmis:name%20like%20%27%25bagnole%25%27&pageNo=1&pageSize=-1&guest=" type="application/atom+xml;type=feed"/>
      <title>Result set for select * from cmis:document where cmis:name like '%bagnole%'</title>
      <updated>2011-03-02T10:03:31.424Z</updated>
      <opensearch:totalResults>1</opensearch:totalResults>
      <opensearch:startIndex>0</opensearch:startIndex>
      <opensearch:itemsPerPage>-1</opensearch:itemsPerPage>
      <cmisra:numItems>1</cmisra:numItems>

      <entry>
      <author><name>admin</name></author>
      <content type="text/html" src="http://localhost:8080/alfresco/service/cmis/s/workspace:SpacesStore/i/ba7981b5-9914-41e2-9b23-8dedaad3ef87/content"/><id>urn:uuid:ba7981b5-9914-41e2-9b23-8dedaad3ef87</id>
      <link rel="self" href="http://localhost:8080/alfresco/service/cmis/s/workspace:SpacesStore/i/ba7981b5-9914-41e2-9b23-8dedaad3ef87"/>
      <link rel="edit" href="http://localhost:8080/alfresco/service/cmis/s/workspace:SpacesStore/i/ba7981b5-9914-41e2-9b23-8dedaad3ef87"/>
      <link rel="enclosure" href="http://localhost:8080/alfresco/service/cmis/s/workspace:SpacesStore/i/ba7981b5-9914-41e2-9b23-8dedaad3ef87/content" type="text/html"/>
      <link rel="edit-media" href="http://localhost:8080/alfresco/service/cmis/s/workspace:SpacesStore/i/ba7981b5-9914-41e2-9b23-8dedaad3ef87/content" type="text/html"/>
      <link rel="http://docs.oasis-open.org/ns/cmis/link/200908/allowableactions" href="http://localhost:8080/alfresco/service/cmis/s/workspace:SpacesStore/i/ba7981b5-9914-41e2-9b23-8dedaad3ef87/allowableactions"/>
      <link rel="http://docs.oasis-open.org/ns/cmis/link/200908/relationships" href="http://localhost:8080/alfresco/service/cmis/s/workspace:SpacesStore/i/ba7981b5-9914-41e2-9b23-8dedaad3ef87/rels"/>
      <link rel="http://docs.oasis-open.org/ns/cmis/link/200908/policies" href="http://localhost:8080/alfresco/service/cmis/s/workspace:SpacesStore/i/ba7981b5-9914-41e2-9b23-8dedaad3ef87/pols"/>
      <link rel="http://docs.oasis-open.org/ns/cmis/link/200908/acl" href="http://localhost:8080/alfresco/service/cmis/s/workspace:SpacesStore/i/ba7981b5-9914-41e2-9b23-8dedaad3ef87/acl"/>
      <link rel="up" href="http://localhost:8080/alfresco/service/cmis/s/workspace:SpacesStore/i/ba7981b5-9914-41e2-9b23-8dedaad3ef87/parents" type="application/atom+xml;type=feed"/>

      <link rel="version-history" href="http://localhost:8080/alfresco/service/cmis/s/workspace:SpacesStore/i/ba7981b5-9914-41e2-9b23-8dedaad3ef87/versions"/>
      <link rel="current-version" href="http://localhost:8080/alfresco/service/cmis/s/workspace:SpacesStore/i/ba7981b5-9914-41e2-9b23-8dedaad3ef87?returnVersion=latest"/>
      <link rel="describedby" href="http://localhost:8080/alfresco/service/cmis/type/cmis:document"/>
      <link rel="service" href="http://localhost:8080/alfresco/service/cmis"/>
      <title>bagnole</title>
      <updated>2011-03-02T09:29:43.158Z</updated>
      <alf:icon>http://localhost:8080/alfresco/images/filetypes/_default.gif</alf:icon>
      <cmisra:object>
      <cmis:properties>
      <cmis:propertyBoolean propertyDefinitionId="cmis:isLatestMajorVersion" displayName="Is Latest Major Version" queryName="cmis:isLatestMajorVersion"><cmis:value>false</cmis:value></cmis:propertyBoolean>
      <cmis:propertyId propertyDefinitionId="cmis:contentStreamId" displayName="Content Stream Id" queryName="cmis:contentStreamId"><cmis:value>store://2011/3/2/9/29/f9fd08ab-d7a3-49f8-95a8-313ba85b37cf.bin</cmis:value></cmis:propertyId>

      <cmis:propertyInteger propertyDefinitionId="cmis:contentStreamLength" displayName="Content Stream Length" queryName="cmis:contentStreamLength"><cmis:value>14</cmis:value></cmis:propertyInteger>
      <cmis:propertyId propertyDefinitionId="cmis:objectTypeId" displayName="Object Type Id" queryName="cmis:objectTypeId"><cmis:value>cmis:document</cmis:value></cmis:propertyId>
      <cmis:propertyString propertyDefinitionId="cmis:versionSeriesCheckedOutBy" displayName="Version Series Checked Out By" queryName="cmis:versionSeriesCheckedOutBy"/>
      <cmis:propertyId propertyDefinitionId="cmis:versionSeriesCheckedOutId" displayName="Version Series Checked Out Id" queryName="cmis:versionSeriesCheckedOutId"/>
      <cmis:propertyString propertyDefinitionId="cmis:name" displayName="Name" queryName="cmis:name"><cmis:value>bagnole</cmis:value></cmis:propertyString>
      <cmis:propertyString propertyDefinitionId="cmis:contentStreamMimeType" displayName="Content Stream MIME Type" queryName="cmis:contentStreamMimeType"><cmis:value>text/html</cmis:value></cmis:propertyString>

      <cmis:propertyId propertyDefinitionId="cmis:versionSeriesId" displayName="Version series id" queryName="cmis:versionSeriesId"><cmis:value>workspace://SpacesStore/ba7981b5-9914-41e2-9b23-8dedaad3ef87</cmis:value></cmis:propertyId>
      <cmis:propertyDateTime propertyDefinitionId="cmis:creationDate" displayName="Creation Date" queryName="cmis:creationDate"><cmis:value>2011-03-02T09:29:37.097Z</cmis:value></cmis:propertyDateTime>
      <cmis:propertyString propertyDefinitionId="cmis:changeToken" displayName="Change token" queryName="cmis:changeToken"/>
      <cmis:propertyBoolean propertyDefinitionId="cmis:isLatestVersion" displayName="Is Latest Version" queryName="cmis:isLatestVersion"><cmis:value>true</cmis:value></cmis:propertyBoolean>
      <cmis:propertyString propertyDefinitionId="cmis:versionLabel" displayName="Version Label" queryName="cmis:versionLabel"><cmis:value>0.0</cmis:value></cmis:propertyString>

      <cmis:propertyBoolean propertyDefinitionId="cmis:isVersionSeriesCheckedOut" displayName="Is Version Series Checked Out" queryName="cmis:isVersionSeriesCheckedOut"><cmis:value>false</cmis:value></cmis:propertyBoolean>
      <cmis:propertyString propertyDefinitionId="cmis:lastModifiedBy" displayName="Last Modified By" queryName="cmis:lastModifiedBy"><cmis:value>admin</cmis:value></cmis:propertyString>
      <cmis:propertyString propertyDefinitionId="cmis:createdBy" displayName="Created by" queryName="cmis:createdBy"><cmis:value>admin</cmis:value></cmis:propertyString>
      <cmis:propertyString propertyDefinitionId="cmis:checkinComment" displayName="Checkin Comment" queryName="cmis:checkinComment"/>
      <cmis:propertyId propertyDefinitionId="cmis:objectId" displayName="Object Id" queryName="cmis:objectId"><cmis:value>workspace://SpacesStore/ba7981b5-9914-41e2-9b23-8dedaad3ef87</cmis:value></cmis:propertyId>

      <cmis:propertyBoolean propertyDefinitionId="cmis:isMajorVersion" displayName="Is Major Version" queryName="cmis:isMajorVersion"><cmis:value>false</cmis:value></cmis:propertyBoolean>
      <cmis:propertyBoolean propertyDefinitionId="cmis:isImmutable" displayName="Is Immutable" queryName="cmis:isImmutable"><cmis:value>false</cmis:value></cmis:propertyBoolean>
      <cmis:propertyId propertyDefinitionId="cmis:baseTypeId" displayName="Base Type Id" queryName="cmis:baseTypeId"><cmis:value>cmis:document</cmis:value></cmis:propertyId>
      <cmis:propertyDateTime propertyDefinitionId="cmis:lastModificationDate" displayName="Last Modified Date" queryName="cmis:lastModificationDate"><cmis:value>2011-03-02T09:29:43.158Z</cmis:value></cmis:propertyDateTime>
      <cmis:propertyString propertyDefinitionId="cmis:contentStreamFileName" displayName="Content Stream Filename" queryName="cmis:contentStreamFileName"><cmis:value>bagnole</cmis:value></cmis:propertyString>

      </cmis:properties>
      </cmisra:object>
      </entry>
      </feed>

      4. Executing same query with a different http header:
      Accept-Language = en,fr;q=0.9,el;q=0.7,sq;q=0.6,fr-fr;q=0.4,en-gb;q=0.3,en-us;q=0.1

      Got 0 result <opensearch:totalResults>0</opensearch:totalResults>

      <?xml version="1.0" encoding="UTF-8"?>
      <feed xmlns="http://www.w3.org/2005/Atom" xmlns:app="http://www.w3.org/2007/app" xmlns:cmisra="http://docs.oasis-open.org/ns/cmis/restatom/200908/" xmlns:cmis="http://docs.oasis-open.org/ns/cmis/core/200908/" xmlns:alf="http://www.alfresco.org" xmlns:opensearch="http://a9.com/-/spec/opensearch/1.1/">
      <author><name>admin</name></author>
      <generator version="3.4.0 (168)">Alfresco (Enterprise)</generator>
      <icon>http://localhost:8080/alfresco/images/logo/AlfrescoLogo16.ico</icon>
      <id>http://www.alfresco.org/rss/atom/urn:uuid:resultset</id>
      <link rel="service" href="http://localhost:8080/alfresco/service/cmis"/>
      <link rel="self" href="http://localhost:8080/alfresco/service/cmis/query?q=select%20*%20from%20cmis:document%20where%20cmis:name%20like%20%27%25bagnole%25%27"/>
      <title>Result set for select * from cmis:document where cmis:name like '%bagnole%'</title>

      <updated>2011-03-02T10:02:15.245Z</updated>
      <opensearch:totalResults>0</opensearch:totalResults>
      <opensearch:startIndex>0</opensearch:startIndex>
      <opensearch:itemsPerPage>-1</opensearch:itemsPerPage>
      <cmisra:numItems>0</cmisra:numItems>
      </feed>

      [ Expected Resut ]

      Being able to search against the repository using different languages.

        Attachments

          Issue Links

            Structure

              Activity

                People

                • Assignee:
                  closedbugs Closed Bugs (Inactive)
                  Reporter:
                  tgoirand Thomas Goirand (Inactive)
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 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, 1 hour, 35 minutes
                    2d 1h 35m

                      Structure Helper Panel