ARB Security Solutions » Using the KeywordQuery Class to Get a List of Department Employees

Latest Free SharePoint Software

ARB Security Solutions regularly releases free SharePoint software, including WebParts, Client Applications, Framework Extensions, and other Miscellaneous Components.
The most recent freeware is:

Title: Simple SharePoint Rollup WebPart
Date Published: 10/22/2009

Previous Two Free WebPart Releases:

SharePoint Security Assurance Program™

For externally facing SharePoint deployments, security is an acutely important deployment concern. Learn how through daily security scanning, you can ensure external business users and partners that they can collaborate in confidence!

Security Assurance WebPart:

Start Audit Process With The SharePoint Security Assurance Program™

Using the KeywordQuery Class to Get a List of Department Employees

Along the same lines as this post, once one has located the relevant department that they desire from a collection, how is it possible to use that department string name in order to get a list of the relevant employees? As we used the KeywordQuery class the last time, we are going to take the same approach in order to return a new DataTable with those values.

Here is the code in order to execute that:

PLAIN TEXT

C#:

public static DataTable BuildDepartmentEmployees(string url, string deptName, int queryLimit)
{
using (var result = new DataTable())
{
using (var site = new SPSite(url))
{
using (var query = new KeywordQuery(site))
{
query.ResultTypes = ResultType.RelevantResults;
query.EnableStemming = true;
query.TrimDuplicates = true;
query.StartRow = 0;
query.RowLimit = queryLimit;
string str =
query.QueryText = string.Format("scope:\"{0}\"", "people") + string.Format(" department:\"{0}\"", deptName);
query.SortList.Add("Rank", SortDirection.Ascending);
query.SelectProperties.Add("AccountName");
query.SelectProperties.Add("FirstName");
query.SelectProperties.Add("LastName");
query.SelectProperties.Add("JobTitle");
query.SelectProperties.Add("WorkEmail");
query.SelectProperties.Add("Department");
query.SelectProperties.Add("WorkPhone");
query.SelectProperties.Add("Fax");
query.SelectProperties.Add("UserProfile_GUID");
query.SelectProperties.Add("UserName");
query.SelectProperties.Add("PreferredName");
query.SelectProperties.Add("OfficeNumber");
query.SelectProperties.Add("MobilePhone");
query.SelectProperties.Add("PIctureURL");
query.SelectProperties.Add("WebSite");
query.SelectProperties.Add("PublicSiteRedirect");
using (ResultTable reader = query.Execute()[ResultType.RelevantResults])
{
result.Load(reader, LoadOption.OverwriteChanges);
}
}
}
return result;
}
}

Article Or Research Filed Under SharePoint| SharePoint Development.

1 Comment »

[...] Using the KeywordQuery Class to Get a List of Department Employees (Adam Buenz)Along the same lines as this post, once one has located the relevant department that they desire from a collection, how is it possible to use that department string name in order to get a list of the relevant employees? As we used the KeywordQuery class the last time, we are going to take the same approach in order to return a new DataTable with those values. [...]

Pingback by SharePoint Daily for November 10, 2008 - SharePoint Daily — November 10, 2008 @ 8:39 am

RSS feed for comments on this post. TrackBack URL

Articles & Research

Latest Free SharePoint Software

SecureCenter For SharePoint

SharePoint Security Assurance Program™

Free Online SharePoint Security Tools

Using the KeywordQuery Class to Get a List of Department Employees

1 Comment »

Leave a comment