Click or drag to resize

GlobalListsFetchList Method (String, String, String, String, 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: 8.1.3.0 (8.1.3.20220620)
Syntax
Copy
public DataTable FetchList(
	string listName,
	string columns,
	string language,
	string filterColumnName,
	string filterComparison,
	string filterValue1,
	string filterValue2,
	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.
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
filterValue1
Type: SystemString
A first value to apply to the filter.
Note: When In or NotIn is used as filterComparison, filterValue1 must follow these formatting rules with comma separators: 'CAD', 'USD', 'EUR', 'A''BC' for string values and 1, 23, 456 for numeric values.
filterValue2
Type: SystemString
A second value to apply to the filter
convertAllColumnsToString
Type: SystemBoolean

Return Value

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