Hi guys,
We are stuck in a development nightmare where we have thought of all possible options but still did not find a solution.
Any help is deeply appreciated. Thanks in advance.
Business requirement: Each location can have one or more supervisors. While creating the locations we are using a picker
control to select users from the active directory and we are saving comma separated user login IDs in the database along
with each location.
Data saved:
Location A hcljohn.S,hclPeter.a
Location B hclStephen.p,hclmark.d
Location C hclGeorge.d
Desired output in a list view:
Location A John Smith, Peter A
Location B Stephen Parker, Mark David
Location C George D
Problem: While displaying a list of locations in a list view we need to display the user names (comma separated) against
each location instead of user IDs.
Option 1: User names have to be fetched from Active Directory as per the comma separated user IDs. We have tried to do this but did not find any solution.
Option 2: Save user names also along with user IDs (comma separated). But we didn't find a way to save the display property (comma separated) from a picker control.
Option 3: We tried to split the data so that we get repeating locations with single user ID
Example
Location A hcljohn.S
Location A hclpeter.a.
This way we can get the user names from AD but we didn't find a way to group the data back to get unique location with comma separated user names.