# C1.FlexPivot.C1FlexPivotEngine.GetUniqueValues

## Content

<div class="doc-site-dotnet-api-container">



<h1 id="C1_FlexPivot_C1FlexPivotEngine_GetUniqueValues_" data-uid="C1.FlexPivot.C1FlexPivotEngine.GetUniqueValues*">GetUniqueValues Method
</h1>
<div class="markdown level0 summary"></div>
<div class="markdown level0 conceptual"></div>



<a id="C1_FlexPivot_C1FlexPivotEngine_GetUniqueValues_" data-uid="C1.FlexPivot.C1FlexPivotEngine.GetUniqueValues*"></a>
<h4 id="C1_FlexPivot_C1FlexPivotEngine_GetUniqueValues_C1_PivotEngine_PivotField_System_Exception__System_Int32_System_Int32_" data-uid="C1.FlexPivot.C1FlexPivotEngine.GetUniqueValues(C1.PivotEngine.PivotField,System.Exception@,System.Int32,System.Int32)">GetUniqueValues(PivotField, out Exception, int, int)</h4>
<div class="markdown level1 summary"></div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">public List&lt;object&gt; GetUniqueValues(PivotField field, out Exception ex, int dataLimit = 1000000000, int uniqueLimit = 1000)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Public Function GetUniqueValues(field As PivotField, ByRef ex As Exception, Optional dataLimit As Integer = 1000000000, Optional uniqueLimit As Integer = 1000) As List(Of Object)</code></pre>
</div>
<h5 class="parameters">Parameters</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="C1.PivotEngine.PivotField.html">PivotField</a></td>
      <td><span class="parametername">field</span></td>
      <td></td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.exception">Exception</a></td>
      <td><span class="parametername">ex</span></td>
      <td></td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">dataLimit</span></td>
      <td></td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">uniqueLimit</span></td>
      <td></td>
    </tr>
  </tbody>
</table>
<h5 class="returns">Returns</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.collections.generic.list-1">List</a>&lt;<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object">object</a>&gt;</td>
      <td></td>
    </tr>
  </tbody>
</table>


<a id="C1_FlexPivot_C1FlexPivotEngine_GetUniqueValues_" data-uid="C1.FlexPivot.C1FlexPivotEngine.GetUniqueValues*"></a>
<h4 id="C1_FlexPivot_C1FlexPivotEngine_GetUniqueValues_System_String_System_String_System_Collections_Generic_Dictionary_System_String_System_Object__System_String_System_Threading_CancellationToken_" data-uid="C1.FlexPivot.C1FlexPivotEngine.GetUniqueValues(System.String,System.String,System.Collections.Generic.Dictionary{System.String,System.Object},System.String,System.Threading.CancellationToken)">GetUniqueValues(string, string, Dictionary&lt;string, object&gt;, string, CancellationToken)</h4>
<div class="markdown level1 summary"></div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">public static Task&lt;IList&gt; GetUniqueValues(string workspace, string table, Dictionary&lt;string, object&gt; view, string fieldName, CancellationToken cancelToken)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Public Shared Function GetUniqueValues(workspace As String, table As String, view As Dictionary(Of String, Object), fieldName As String, cancelToken As CancellationToken) As Task(Of IList)</code></pre>
</div>
<h5 class="parameters">Parameters</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.string">string</a></td>
      <td><span class="parametername">workspace</span></td>
      <td></td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.string">string</a></td>
      <td><span class="parametername">table</span></td>
      <td></td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.collections.generic.dictionary-2">Dictionary</a>&lt;<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.string">string</a>, <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object">object</a>&gt;</td>
      <td><span class="parametername">view</span></td>
      <td></td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.string">string</a></td>
      <td><span class="parametername">fieldName</span></td>
      <td></td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.cancellationtoken">CancellationToken</a></td>
      <td><span class="parametername">cancelToken</span></td>
      <td></td>
    </tr>
  </tbody>
</table>
<h5 class="returns">Returns</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a>&lt;<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.collections.ilist">IList</a>&gt;</td>
      <td></td>
    </tr>
  </tbody>
</table>
</div>