What options do you have when you’ve got several lists of data in SharePoint, and wish to present them as a merged, contiguous data set?
Our client had developed several lists of contractor related information on licenses, technical and safety certifications, and medical/vaccination states, all with attached copies of certificates etc. Every time the HR Team needed to check someone's status or current qualifications, they needed to check each of these lists and download the files to desktop or a folder, before they could forward them to prospective clients.
Sharing Minds was approached to assist in developing a SharePoint-based solution to display a single consolidated view of the contractor details, and to allow the selection to be downloaded in a single archive of selected certificate files.
There was also the requirement for a ‘light weight’ solution with few or no libraries to be installed on the server.
Some of the default options such as a content query web part or search results were not suitable, as apart from 2 fields per list (e.g. ID and Name) there wasn't a common content type or data structure.
With no common content types, or other centralising elements that we could use it had become a custom solution, as we did not want to show tuples (i.e. repeated row caused by joining dissimilar lists).
In a database, we could create a query using unions and joins and flatten it out.
But we're using SharePoint.
Add in the further requirement to sort, search and filter by the many columns imported from the lists, and our first trial was with TableFilter.JS.
Available from GitHub, well documented with great examples, Max Guglielmi has provided a great framework which takes our humble HTML table and puts a very handy HTML5 spin on it just by pointing it at the table ID.
Starting out with simple text search on each field (Fig.1) it was able convert selected columns into multiple-checklist, drop down selectors.(Fig.2)