Query Role Members

API Type

Web Services

Description

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

Syntax

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

Parameters

Name	Description
roleName	Definition: The name of a role. Type string Allowed Values: A valid role name.
sqlWhereClause	Definition: The where clause of the SQL statement you want to query. Type string Allowed Values: The where clause of a SQL statement.

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 sqlWhereClause = ...// for example, "ASSIGNEE_TYPE='User'"

try
	{
    WFRoleMember[] roleMembers = svc.QueryRoleMembers(roleName, sqlWhereClause);
    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