Retrieves a collection of Activities from the database using the supplied SQL FROM and WHERE criteria and parameters. The starting SQL is: SELECT Activity.* FROM Activity {0} WHERE 1 = 1 {1}. So any additional FROM criteria should look something like: ", Product" or "INNER JOIN Product ON Activity.PRODUCT_CODE = Product.PRODUCT_CODE" etc. Any additional WHERE criteria should start with AND, like: "AND Activity.PRODUCT_CODE = Product.PRODUCT_CODE" etc.

Namespace: Asi.iBO.ContactManagement
Assembly: Asi.iBO (in Asi.iBO.dll) Version: 15.1.3.0

Syntax

C#
public static CActivity[] GetActivities(
	IiMISUser user,
	string additionalFrom,
	string where,
	SqlParameter[] parameters
)
Visual Basic
Public Shared Function GetActivities ( _
	user As IiMISUser, _
	additionalFrom As String, _
	where As String, _
	parameters As SqlParameter() _
) As CActivity()
Visual C++
public:
static array<CActivity^>^ GetActivities(
	IiMISUser^ user, 
	String^ additionalFrom, 
	String^ where, 
	array<SqlParameter^>^ parameters
)

Parameters

user
Type: Asi.iBO..::..IiMISUser
The IiMISUser object providing the security credentials of the logged in user.
additionalFrom
Type: System..::..String
Any additional FROM criteria tacked onto "FROM Activity ", or string.Empty if no additional tables are required.
where
Type: System..::..String
Any additional WHERE criteria tacked onto "WHERE 1 = 1 ", or string.Empty if no additional WHERE criteria is required.
parameters
Type: array<System.Data.SqlClient..::..SqlParameter>[]()[][]
Bind variables for the WHERE criteria. Using bind variables is preferred over strings imbedded in the where criteria. Send NULL if no bind variables are needed.

Return Value

An array of CActivity records that match the supplied criteria.

See Also