"Share" on Document Library has userid, not Full Name

[ccoulson]

egenesis[CodePlex]
Hi, So I installed SP2013 and configured FBA. When I add user, I am adding userid as well as full name using this tool. When I log in, I can see my full name on the top right menu. However when I try to do quotSharequot on document library, the quotinvite peoplequot box does not search for full name, it searches for user id, hence the results show only user id ... Is there a work around for this?

[ccoulson]

egenesis[CodePlex]
Well it seems like on that search module, it is calling stored procedure aspnet_Membership_FindUsersByName] to autopopulte the drop down. The return type that sharepoint is using is UserName instead of the full name. Now all I need to do is create a job that will pull the full name from sharepoint and sync into a new column called ProfileNames on aspnet_Users. Then I can replace the return select statement on that stored proc by using this ...

SELECT u.ProfileNames as UserName, m.Email, m.PasswordQuestion, m.Comment, m.IsApproved, m.CreateDate, m.LastLoginDate, u.LastActivityDate, m.LastPasswordChangedDate, u.UserId, m.IsLockedOut, m.LastLockoutDate FROM dbo.aspnet_Membership m, dbo.aspnet_Users u, #PageIndexForUsers p WHERE u.UserId = p.UserId AND u.UserId = m.UserId AND p.IndexId = @PageLowerBound AND p.IndexId = @PageUpperBound ORDER BY u.UserName

[ccoulson]

ccoulson[CodePlex]
I don't think so. The asp.net membership provider that SharePoint uses actually only handles username and email address. The full name is stored in SharePoint, in the user's profile. SharePoint must only be searching the membership database and not the user profiles for the site collection.