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

BaseAssociationEditor.java returns too many results when the query filter consists of "firstname + lastname"

    Details

    • Type: Service Pack Request
    • Status: Closed (View Workflow)
    • Resolution: Fixed
    • Affects Version/s: 4.1.4
    • Fix Version/s: 4.1.6
    • Component/s: Alfresco Explorer
    • Labels:
      None
    • Environment:
      RHEL, MySQL, Tomcat

      Description

      When searching from people in Alfresco Explorer using first name and last name, Alfresco returns any user that matches the first name or the last name rather than users matching both first name and last name

      The behaviour has changed from 3.4.6.45 to 4.1.3

      In Alfresco 3.4.6.45 the query uses the "+" sign (must match) so both filters must match in the result.

      Query: +TYPE:"

      {http://www.alfresco.org/model/content/1.0}

      person" AND (+TYPE:"

      {http://www.alfresco.org/model/content/1.0}

      person" +(@cm\:firstName:"miguel" @cm\:lastName:"miguel" @cm\:userName:miguel*) +TYPE:"

      {http://www.alfresco.org/model/content/1.0}

      person" +(@cm\:firstName:"rodriguez" @cm\:lastName:"rodriguez" @cm\:userName:rodriguez*) )

      In Alfresco 4.1.3 the "+" sign has been removed

      Query filter: [(

      {http://www.alfresco.org/model/content/1.0}

      firstName, miguel rodriguez), (

      {http://www.alfresco.org/model/content/1.0}

      lastName, miguel rodriguez), (

      {http://www.alfresco.org/model/content/1.0}

      userName, miguel rodriguez), (

      {http://www.alfresco.org/model/content/1.0}

      firstName, miguel), (

      {http://www.alfresco.org/model/content/1.0}

      lastName, rodriguez)]

      How to reproduce:

      Login to Alfresco explorer
      View Details of any document
      Click on "Start Advanced Workflow"
      Select "Adhoc Workflow (Assign arbitrary task to colleague using Activiti workflow engine)" and click next
      Click on "assign to" and in the box enter the user first name and second name i.e. Miguel Rodriguez and click search

      Expected results:

      In both 3.4.6.45 and 4.1.3 we should get the same user from the search

      Actual results:

      In 3.4.6.45 we get a user matching both first name and last name but in 4.1.3 we get any users matching the first name or any users matching the last name

        Attachments

          Issue Links

            Structure

              Activity

                People

                • Assignee:
                  closedbugs Closed Bugs
                  Reporter:
                  mrodriguez Miguel Rodriguez
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  9 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 - 7 hours, 30 minutes
                    7h 30m

                      Structure Helper Panel