Change to Procedure Central.dbo.GN_RetrieveTeamEmploy
When searching for owners in the Responsibility tab, it is currently not possible to enter a combined first and last name.
Could you please update the stored procedure responsible for returning these results to support combined name searches? For reference, I’ve included a snippet of the SQL procedure currently in use, along with two additional lines that illustrate how I would approach filtering results to support this functionality as if I was the change owner.
Let me know if you need further clarification or a full example.
PROCEDURE [dbo].[GN_RetrieveTeamEmploy]
Where
(@CompanyId = 0 OR Stationed.CompanyId = @CompanyId)
and (@OfficeId = 0 OR Stationed.OfficeId = @OfficeId)
and (@DeptId = 0 Or Stationed.DepartmentId = @DeptId)
and (@CentreId = 0 Or Stationed.CentreId = @CentreId)
and (Employee.Inactive = 0 or Employee.Inactive Is Null or @IncludeDisableTimesheet=1)
and (Employee.DisabledEmployee = 0 or Employee.DisabledEmployee Is Null or @IncludeDisableLogin=1)
and (Employee.EmployeeId Not In (5,6,7))
and ( (Contact.LName LIKE @SearchText + '%')
Or (Contact.FName Like @SearchText + '%')
Or (Contact.FName+' '+Contact.LName Like @SearchText + '%') -- New Line - check first + last
Or (Contact.LName+' '+Contact.FName Like @SearchText + '%') -- New Line - check last + first
Or (Employee.EmployeeCode Like @SearchText + '%'))
and Employee.EmployeeId Not In.....
THERE IS MORE CODE AFTER THIS

Thank you for submitting your idea to us!
We’ve received your suggestion and our team will be reviewing it shortly. We truly appreciate your input.
Important: If you wish you remain informed of the progress of your submitted idea, please 'Subscribe to Updates on the Idea' which will then keep you updated on it's progress.
Best regards,
Product Development
Wolters Kluwer UK TAA