"Dynamic view" feature in JungleDocs 365

The GetView() function is used to resolve items using the SharePoint View configuration and allows the use of View sorting, grouping and filtering (static filter).

When more complex dynamic filtering is needed, the  GetView() function with “dynamic view” feature can be used.  

A specific SharePoint “dynamic” View for JungleDocs 365 should be created and used via the  GetView() function. JungleDocs 365 formulas can be used inside SharePoint View filters. Before using the View filters, JungleDocs will process these formulas and replace them with real values which will be recognized by SharePoint. SharePoint does not understand JungleDocs formulas, this is why normally this view will return zero results in SharePoint, but will work in JungleDocs 365.

Note: The context of a GetView() function will be used to process formulas in “dynamic” View. This means, that if a GetView() is used in a document, the document context (metadata) can be used to process the formulas in View filters. This provides the ability to use document Columns in formulas.

 

Dynamic View Example

Imagine we have a Companies List, a Contacts List and a Word Reports Library for storing Word reports.

The Contacts List has a Company Lookup Column referring to the Companies List.

The  Word Reports Library should also have a Company Lookup Column referring to the Companies List.

Create a View in the Contacts list (in this example we name it "Filtered") and set a filter on a Company Column. The value in the Company Column should be equal to the Company Column in Word Reports Library.   

In order to configure a Word report template in the  Word Reports Library which will display the list of contacts for the specified company use GetView() function and specify Contacts List and Filtered View as parameters:
GetView("https://yoursite.sharepoint.com/Lists/Contacts/";"Filtered")

Note: Use a Rich text content control for your GetView() configuration to be able to insert additional content controls inside. In the example image below, a Rich text content control is inserted into the whole second table row with a GetView() function, and inside that control there are additional content controls inserted in every column to take particular information from the "Contacts" list. Read more about configuring repeating table with GetView() here.

After creating a new Word report and choosing a company in the document properties we get the result:  

  

Still need help? Contact Us Contact Us