Hi Joe,

The method SiteUser.GetUserSearchPage will calls dbsiteuser.GetUserSearchPage which in turns call 2 procedures:

mp_Users_CountForSearch, mp_Users_SelectSearchPage

I notice the WHERE clauses in mp_Users_SelectSearchPage is different from the countforsearch.

Is this a bug?

Original SQL:

IF @SearchInput IS NULL OR @SearchInput = ''
BEGIN
INSERT INTO     #PageIndexForUsers (UserID)

SELECT     UserID
FROM         mp_Users
WHERE
SiteID = @SiteID

ORDER BY     [Name]
END
ELSE
BEGIN
INSERT INTO     #PageIndexForUsers (UserID)

SELECT     UserID
FROM         mp_Users
WHERE
SiteID = @SiteID

AND (
([Name]  LIKE '%' + @SearchInput + '%')
OR ([LoginName]  LIKE '%' + @SearchInput + '%')
)

ORDER BY     [Name]

END

Possible correction:

IF @SearchInput IS NULL OR @SearchInput = ''
BEGIN
INSERT INTO     #PageIndexForUsers (UserID)

SELECT     UserID
FROM         mp_Users
WHERE
SiteID = @SiteID

AND ProfileApproved = 1
AND DisplayInMemberList = 1
AND IsDeleted = 0

ORDER BY     [Name]
END
ELSE
BEGIN
INSERT INTO     #PageIndexForUsers (UserID)

SELECT     UserID
FROM         mp_Users
WHERE
SiteID = @SiteID

AND u.ProfileApproved = 1
AND u.DisplayInMemberList = 1
AND u.IsDeleted = 0

AND (
([Name]  LIKE '%' + @SearchInput + '%')
OR ([LoginName]  LIKE '%' + @SearchInput + '%')
)

ORDER BY     [Name]

END