GetUniqueItems function

Applies to JungleDocs for SharePoint 2010-2019.
For JungleDocs for Office 365 tutorials, click here.

This article describes the formula syntax and usage of the GetUniqueItems function in JungleDocs.

Description

Returns items with a unique ID from a SharePoint list.

Syntax

GetUniqueItems(recordSet; [fieldName])

The GetUniqueItems function syntax has the following arguments:

• recordSet   Required. Any function that returns a set of items (e.g., GetView(), FindItems(), ReportItems()).
• fieldName   Optional. A SharePoint column name.

Example

GetUniqueItems(GetView("Contacts"; "AllItems"):Company) 

Returns unique items by the Company lookup field values from the Contacts list's AllItems view.

GetUniqueItems(ReportItems; "FullName")

Returns unique items by the FullName field value in the current list.

GetUniqueItems(ReportItems:Company) 

Returns unique items in the lookup list through the Company lookup field.

GetUniqueItems(ReportItems:Company; "Email")

Returns unique items by the Email field values in the lookup list through the Company lookup field.