GetView function

Applies to JungleDocs for SharePoint 2010-2019.
For a similar tutorial for JungleDocs for Office 365, click here.

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


Description

Returns items from a SharePoint list view and allows you to use view sorting, grouping, and filtering.

Syntax

GetView(listTitleOrUrl; viewTitleOrUrl; [additionalParameter; additionalParameterValue])

The GetView function syntax has the following arguments:

  • listTitleOrUrl   Required. A SharePoint list name. List URL is also supported to specify the list on another site.
  • viewTitleOrUrl   Required. A SharePoint list view name.
  • 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 GetView function, you need to create a repeated section.
  • 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 column, use 0 to filter No values, and 1 to filter Yes.

Example

GetView("TestList"; "All Items"; "BooleanColumnName"; "1") 

Returns items from the All Items view in the TestList, filtered by the Boolean column "Yes" value.

GetView("TestList"; "All Items"; "TestChoice"; "Category1") 

Returns items from the All Items view in the TestList, filtered by the additional choice column value.

GetView("TestList"; "TestView"; "TestChoice"; "Category1"; "BooleanColumnName"; "0") 

Returns items from the All Items view in the TestList, filtered by Boolean and choice column values.

GetView("TestList"; "All Items"; "ExpirationDate"; Today() 

Returns items from the All Items view in the TestList, filtered by dynamic date.

GetView("TestList"; "All Items"; "ExpirationDate"; "01/10/2016") 

Returns items from the All Items view in the TestList, filtered by static date.

GetView("TestList"; "FilteredDatesView") 

Returns items from the TestList, filtered by dynamic view.

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