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

Alfresco CMIS gets inconsistent results on sort with cmis:lastModifiedBy

    Details

      Description

      Our implementation of Alfresco CMIS gets inconsistent results on a sort with cmis:lastModifiedBy and cmis:createdBy. Hassan Janjua brought this up to me:

      "We are violating the spec. CMIS Spec says results must be sorted if order by is used (http://docs.oasis-open.org/cmis/CMIS/v1.1/CMIS-v1.1.html).
      I verified this with CMIS Product Management team. We need to create bug JIRA on this."

      Steps to Replicate:

      Tested this on 5.0 using this query:

      . Created folder1 under repository
      . Created 3 text files: test1.txt, test2.txt, test3.txt
      . Created two users: testuser1 2testuser
      . Modified test1.txt with testuser1
      . Modified test3.txt with 2testuser

      Observed:

      . Run the following queries with CMIS workbench:

      SELECT cmis:lastModifiedBy FROM cmis:document where in_folder('workspace://SpacesStore/50fd4388-74db-4845-84ed-740f34de5f5c') order by cmis:lastModifiedBy

      2testuser
      admin
      testuser1

      SELECT cmis:lastModifiedBy FROM cmis:document where in_tree('workspace://SpacesStore/50fd4388-74db-4845-84ed-740f34de5f5c') order by cmis:lastModifiedBy

      admin
      admin
      2testuser
      testuser1
      testuser1
      2testuser

      Expected:

      The list with in_tree should be returned as:

      2testuser
      admin
      testuser1

        Attachments

          Issue Links

            Structure

              Activity

                People

                • Assignee:
                  closedbugs Closed Bugs
                  Reporter:
                  hseritt Harlin Seritt
                • Votes:
                  1 Vote for this issue
                  Watchers:
                  8 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 - 1 week, 2 hours, 25 minutes
                    1w 2h 25m

                      Structure Helper Panel