GlobalListsfetchList Method (String, String, String, String, Boolean, String, String, String, String, Boolean)

public DataTable fetchList(
	string listname,
	string columns,
	string language,
	string sortBy,
	bool sortAscending,
	string filterColumnName,
	string filterComparison,
	string filterValue1,
	string filterValue2,
	bool convertAllColumnsToString
)

Public Function fetchList ( 
	listname As String,
	columns As String,
	language As String,
	sortBy As String,
	sortAscending As Boolean,
	filterColumnName As String,
	filterComparison As String,
	filterValue1 As String,
	filterValue2 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.

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

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

Reference