Query Role Members

Description

Retrieves the members assigned to a role that match a specified SQL statement.

Syntax

public virtual WFRoleMember[] QueryRoleMembers(string roleName, string sql)

Parameters

Name	Type	Description
roleName	string	A string that contains the name of a role.
sql	string	A string that contains the where clause of the SQL statement you want to query.

Output

Returns array of WFRoleMember members of the role that match the specified SQL statement.

Example

IWFAdminService svc = GetAdminService();
string roleName = ...// for examples, "Users"
string where = ...// for example, "ASSIGNEE_TYPE='User'"

try
	{
    WFRoleMember[] roleMembers = svc.QueryRoleMembers(roleName, where);
    foreach (WFRoleMember member in roleMembers)
        {
        Console.WriteLine("Assignee = '{0}', Created Date = '{1}'",
                       member.Assignee,
                       member.CreatedDate.ToShortDateString());
        }
	}

catch (Exception ex)
	{
    Console.WriteLine("Failed! " + ShUtil.GetSoapMessage(ex));
	}

/*
This example produces the following results:
Assignee = 'DEMO\CONTROLLER' & Created Date = '9/18/2009'
Assignee = 'DEMO\CFO' & Created Date = '9/18/2009'
*/

Supported Versions

3.2.0.4 and higher

Parent topic: Group, Role, and Rights