I’ve recently begun exploring the use of Access Services with O365 just to see what this new capability offers to businesses and developers. Overall, I’m really impressed with some of the complex things that can be done with Access Services.
Recently, I was working with a colleague in a SharePoint 2013 On-Primesis environment to troubleshoot an issue when attempting to use the SQL Report View Web Part and a Content By Search or Search Results Web Part on the same page. To our surprise, the report viewer web part would not work with both web parts on the page.
The new display templates in SharePoint 2013 allow for some great flexibility for designers and web developers in presenting search results in almost any format desired. For a proof of concept, a client wanted to aggregate tasks from across SharePoint. The company manages multiple assets and would like to roll up all tasks for all users across all locations in SharePoint in a single location. We were able to accomplish this goal fairly easily thanks to the new search display templates available in SharePoint 2013. This project also makes use of jQuery and DataTables.
A recent client desired to have selected refiners automatically collapsed on their search pages. This is because the resulting search results could have between 5 and 15 refiners, each showing up to 15 individual refinement options. The end result was a page that had a refiner list falling below the core results, resulting in a lot of scrolling to find a specific refiner. The client wanted to see if some of the refiners that were known to have longer refinement options could be collapsed by default to reduce the amount of scrolling needed.
SharePoint 2013 introduces the concept of Display Templates, specifically for search based web parts. This replaces the need to make use of XSLT to modify the way search results appear. However, one of the challenges I faced with a client is the ability to show the key terms in a record that caused it to show in the results. Following the limited guidance and several blog posts, I was able to create my own display template for an external content type.