IHostManagementGetDataTableAsync Method

Task<DataTable> GetDataTableAsync(
	string tables,
	string fields,
	string condition,
	string order = null,
	string group = null,
	int maxRecords = 0,
	bool generateSchema = false,
	bool useSettings = false,
	List<string> excludeUserConditions = null
)

Function GetDataTableAsync ( 
	tables As String,
	fields As String,
	condition As String,
	Optional order As String = Nothing,
	Optional group As String = Nothing,
	Optional maxRecords As Integer = 0,
	Optional generateSchema As Boolean = false,
	Optional useSettings As Boolean = false,
	Optional excludeUserConditions As List(Of String) = Nothing
) As Task(Of DataTable)

Parameters

tables  String

Table or tables on which the query is performed.

fields  String

Fields to return the value.

condition  String

Query data selection criteria.

order  String  (Optional)

Fields and query ordering expression.

group  String  (Optional)

Fields and grouping expression of the query.

maxRecords  Int32  (Optional)

Maximum number of records (unlimited if value less than or equal to zero).

generateSchema  Boolean  (Optional)

Indicates whether the information container should contain the schema of the queried tables.

useSettings  Boolean  (Optional)

Indicates whether the table settings are used (links, conditions per user, ...).

excludeUserConditions  ListString  (Optional)

List<String> with the table aliases to exclude from per-user conditions.

Return Value

Reference