GlobalListsFetchList Method (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 public DataTable FetchList(
string listName,
string columns,
string language,
string filterColumnName,
string filterComparison,
string filterValue,
bool convertAllColumnsToString
)
Public Function FetchList (
listName As String,
columns As String,
language As String,
filterColumnName As String,
filterComparison As String,
filterValue As String,
convertAllColumnsToString As Boolean
) As DataTable
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 - 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:
DataTableA DataTable of items from the list
See Also