Click or drag to resize

GlobalListsFetchList Method (String, String, String, String, Boolean, String, String, String, Boolean)

Get list's items from its name. Doesn't apply the filter or sort or throw an exception if you pass an invalid parameter.

Namespace:  WorkflowGen.My.Integration
Assembly:  WorkflowGen.My (in WorkflowGen.My.dll) Version: 9.0.3.0 (9.0.3.20240719)
Syntax
public DataTable FetchList(
	string listName,
	string columns,
	string language,
	string sortBy,
	bool sortAscending,
	string filterColumnName,
	string filterComparison,
	string filterValue,
	bool convertAllColumnsToString
)

Parameters

listName
Type: SystemString
List's name
columns
Type: SystemString
CSV of the columns you want to get.
language
Type: SystemString
Language in which you want to get the items.
sortBy
Type: SystemString
The name of a column of the list to sort
sortAscending
Type: SystemBoolean
Sort the items ascending.
filterColumnName
Type: SystemString
The name of a column of the list
filterComparison
Type: SystemString
A comparison to apply to the filter.
Possible values: Equals, DoesNotEqual, GreaterThan, GreaterThanOrEquals, LowerThan, LowerThanOrEquals, Contains, BeginsWith, EndsWith, IsNull, IsNotNull, In, NotIn, Between, RelatesTo, Exists
filterValue
Type: SystemString
A value to apply to the filter.
Note: When In or NotIn is used as filterComparison, filterValue must follow these formatting rules with comma separators: 'CAD', 'USD', 'EUR', 'A''BC' for string values and 1, 23, 456 for numeric values.
convertAllColumnsToString
Type: SystemBoolean

Return Value

Type: DataTable
A DataTable of items from the list
See Also