This broker provides a method to craft optimized queries that will run against a SharePoint farm and expose them as specific broker objects to K2 Blackpearl.  This broker provides different functionality than the out of the box broker in that queries are pre-defined and optimized at design time so as to provide runtime performance that is more finely tuned to the need of a K2 form or workflow.

This broker can be described as providing ?views? into your SharePoint farm just as you might create highly optimized views or stored procedures in Microsoft SQL Server to only return columns needed for an operation.  So too can you create those CAML / KQL (and FQL) queries using this broker to return just the data you need.

This broker support both CAML and Search queries and can be used to expose an unlimited number of queries using a single instance of the broker.  It additionally supports caching to improve perormance when possible.

Full code is available on Githut at https://github.com/thystonius/NAB.K2

Demo

Part 1 of 3 - Basic Query at https://youtu.be/qnJH8dkaL9U

Part 2 of 3 - Parameters at https://youtu.be/c3QPxUi9XtE

Part 3 of 3 - SharePoint Search at https://youtu.be/RDZQrpLjrOM