I have the main department as "Finance" and under that there are several sub departments like "Finance and Accounts","Economics",etc.,The SharePoint users are allocated with their specific department in user profiles.
I also have a "Finance" page in SharePoint site.In that page I need to display the profile details of SharePoint users whose department matches the Finance and its sub departments.
To achieve this ,I have used search Webpart in the Finance page. I have planned to use a list named "Finance" containing the names of sub departments.Now I need to lookup the values of "Finance" list in the search query of the Webpart. Can anyone say how can I query the values of list in search query box? Can anyone give me suggestions on this? Is there any other better approaches?