C1.PivotEngine Assembly / C1.PivotEngine Namespace / C1PivotEngine Class / GetUniqueValues Method / GetUniqueValues(String,String,Dictionary<String,Object>,String,CancellationToken) Method
Path in the server's file system where DataEngine data is saved in files.
The name of a DataEngine table.
View definition used for performing aggregation.
The name of the field to provide unique values for.
Enables task cancellation.

In This Topic
GetUniqueValues(String,String,Dictionary<String,Object>,String,CancellationToken) Method
In This Topic
Lists unique values of a field for the server's clients.
Syntax
'Declaration
 
Public Overloads Shared Function GetUniqueValues( _
   ByVal workspace As String, _
   ByVal table As String, _
   ByVal view As Dictionary(Of String,Object), _
   ByVal fieldName As String, _
   ByVal cancelToken As CancellationToken _
) As Task(Of IList)
 

Parameters

workspace
Path in the server's file system where DataEngine data is saved in files.
table
The name of a DataEngine table.
view
View definition used for performing aggregation.
fieldName
The name of the field to provide unique values for.
cancelToken
Enables task cancellation.

Return Value

Collection of objects with properties Name (string) and Type (System.Type)
Remarks

Using this method, a client can show a list of values for the user to choose from.

Specifying the view (and not just a field name) for which values are to be listed is necessary because list of values can depend on the field's format (for example, values can be rounded).

Clients need to be aware that getting value list can take considerable time if number of rows in the source data is very large.

See Also