FindItems function

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

This article describes the formula syntax and usage of the FindItems function in JungleDocs for Office 365.


Description

Returns items from a SharePoint list, filtered by specific values.

Syntax

FindItems(listTitleOrUrl; columnName; value; [additionalParameter; additionalParameterValue])

The FindItems function syntax has the following arguments:

  • listTitleOrUrl   Required. A SharePoint list name. List URL is also supported to specify the list on another site.
  • columnName   Required. A SharePoint column name (internal column name is recommended).
  • value   Required. The value to find items by.
  • additionalParameter   Optional. An additional parameter: a SharePoint column name (lookup columns, choice columns, and Boolean columns are also supported) or a date condition.
  • additionalParameterValue   Optional. The value of the additional parameter (text or number).

Remarks

  • To use the FindItems function, you need to create a repeated section by adding content controls to a template.
  • Additional parameters are supported in JungleDocs 3.6 and later.
  • You can use an unlimited number of additional parameters in a formula.
  • Additional parameters work only as an equal condition and they are combined by and operators. For Boolean columns, use 0 to filter No values, and 1 to filter Yes.

Example

FindItems("Contacts";"Company";"Contoso")

Finds items in the Contacts list, matching the Contoso value in the Company column.

FindItems("TestList"; "ChoiceColumnName"; "ChoiceColumnValue"; "BooleanColumnName"; "0")

Finds items in the TestList, matching ChoiceColumnValue in the ChoiceColumnName and matching the Boolean column No value.

FindItems("TestList"; "ExpirationDate"; Today())

Finds items in the TestList, matching a dynamic date (today) in the ExpirationDate column.

FindItems("TestList"; "ExpirationDate"; "01/10/2016")

Finds items in the TestList, matching a static date in the ExpirationDate column.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us