Date:

September 1, 2004

 

Applies to:

Secure Access 2.1 and any later version

 

Summary:

Could you tell me if you have sample of code for SecureAccess (2.3), to find a list of users from either the user's first name, middle name or last name?

 

Solution:

There are no direct functions for getting list of users however you can use DB layer. Here is a sample showing how to get relationship types:

 

Imports Portsight.SecureAccess.ARDataServices

Imports Portsight.SecureAccess.ARDataServices.ARConstants

....

Dim ARDBConn As ARDBConnection = New ARDBConnection()

ARDBConn.ConnectToCatalog()

ARDBConn.Table = "View_AR_RelationshipType"

Dim Params(0, 1) As String

Params(0, 0) = ARConstants.cRELATIONSHIP_TYPE_NAMESPACE

Params(0, 1) = "MyApplication.MyAppPart"

ARDBConn.Parameters = Params

ds = ARDBConn.SelectRecords

 

Getting the users will be similar but you will use different SQL View and different filter parameters. For more samples please see UserList.aspx and ARUIUserList.ascx pages. Regarding the parameters, they are specified as pairs column/value and there can be unlimited number of these pairs. The values can be prefixed with ?lt;##LIKE##>?that will cause listing all the rows whose specified column contains the provided substring, e.g.

Params(0, 1) = "<##LIKE##> MyApplication.MyAppPart"