JungleDocs | Dynamic view feature
In JungleDocs you can use the Dynamic View feature to dynamically sort the information in your SharePoint. In this tutorial you will learn how to do this.
GetView() function is used to resolve items using SharePoint View configuration and allows to use View sorting, grouping and filtering (static filter).
FindItems() function is used to filter items from the list with one “equals” condition specified in the document itself (dynamic filter), but does not support sorting, grouping or more complex filtering.
When sorting or grouping more complex dynamic filtering is needed. Here the GetView() function with “dynamic view” feature can be used.
Specific SharePoint “dynamic” View for JungleDocs should be created and used via GetView() function. JungleDocs 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.
Note: The context of a GetView() function will be used to process formulas in “dynamic” View. It means, if 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.
With JungleDocs 3.6 you can configure dynamic views with additional conditions. For example, GetView("TestList"; "FilteredDatesView"), where FilteredDatesView configured like that:
Note: Additional filter parameters works only as equal condition and they should be combined by and operators.
Dynamic View Example
Imagine we have a Companies List, a Contacts List and a Word Reports Library for storing Word reports.
Contacts List has a Company Lookup Column referring to Companies List.
Word Reports Library also has a Company Lookup Column referring to Companies List.
In order to configure a Word report template in Word Reports Library which will display the list of contacts for specified company use GetView() function and specify Contacts List and Filtered View as parameters: GetView("Contacts";"Filtered").
Next we create Filtered View in Contacts list and set a filter on a Company Column. Value in a Company Column should be equal to the Company Column in Word Reports Library.
After creating new Word report and choosing a company we get the result: