I have a requirement to fetch all the Users Name,Designation,Department and email data in defined customised order in SharePoint web part page.
Could you kindly anyone help me to find the best approach to do the above task.
Actually i am planning to keep one Sharepoint master list for defining the custom order numbers with Designation and order numbers,And after the results fetches from Userprofile services i need to sort based on the order defined in the above sharepoint master list.
master list data can contain around 150 Designations .
Is that above approach correct ? I am worrying about the performance issue ?