Grouping SharePoint List Items using Jquery/REST/JSON

In this post, I will share requirement where I need to retrieve SharePoint list data that contains following list items.

                                                          

Below is what I need to from SharePoint list:

1. I need to group below list based on the Title.
2. I need to display the grouped results with sum of Number column.

The end result should be as below:

Name:One- Total 10

Name:Two- Total 7

Name:Three- Total 6

Main issue here is the SharePoint REST API doesn't support grouping. The above requirement can be achieve by grouping the JSON response that is obtained from the REST query. Below is the complete code that does grouping.

Branding SharePoint 2016 Suite bar using SharePoint Jquery/REST API

In this post, I will sharing my recent experience of customizing SharePoint 2016 suite bar branding. As we know SharePoint out of box suite bar looks like below with following elements.

Following tasks can be accomplished on the SharePoint suite bar.

1. We can replace the default SharePoint text with either your company name or company logo. This can be done by accessing SharePoint CSS class ''o365cs-nav-leftAlign" and "o365cs-nav-brandingText" using Jquery.

2. In the center section of the suite bar, we can add text or icon using css class "o365cs-nav-centerAlign".

3. In the right section, I will adding suite bar links using SharePoint css class 'o365cs-nav-rightAlign'.

This post will majorly discuss branding the left and right sections of the SharePoint 2016 suite bar.

The final output will be as follows:

1. On the left side of the suite bar, I will be placing logo using SharePoint Jquery/REST.
2. On the right side of the suite bar, I will be placing suite bar links and when clicked on these suite bar links, I will be displaying additional sub menu links.

Development:

I had created entire solution as farm solution and once I have the wsp I had used the wsp in SharePoint HTML master page so that I can see the suite bar branding elements in every page of my custom master page.

Below is the final structure of my the project:

In the visual studio project, I had created visual webpart, The only purpose of the visual webpart is that it holds all the javascript and css customization. Here is the code for visual webpart designer page.

SuiteBarCustom.js: this file will be generating all the HTML elements for right and left section of the suite bar for adding the logo and adding suite links. Below is the code.

SuiteBarCustom.css

Source: I had used SharePoint list to retrieve the links for suite links in SharePoint suite bar.

Deployment: Build the solution and use the wsp generated from the solution to add it onto custom master page. Below snippet is generated from design manager and used in master page.

The above post showed how I  had developed and deployed custom suite bar links.

Deploying SharePoint 2016 master pages using visual studio farm solution

In this post, I will be sharing my recent experience where I had been working on creating SharePoint 2016 HTML master page for intranet. Initially for my development purpose I was directly creating HTML master page using SharePoint designer but when the time came, I was asked to deploy to different environment such as test environment. I finally ended up creating farm based visual studio code solution. Below are steps I had used for creating the wsp solution.

1. Here is the  final structure of solution.

2. Start your visual studio and select empty SharePoint project with farm based solution approach.

3. Add folder called 'FeatureElements' to the project.

4. Right click on FeatureElements and then add module to the folder as shown below.

5. Now, right under the module start adding your HTML files. In my case, I had all my master pages created using SharePoint designer based on seattle.html and I had imported those HTML files into visual studio solution.

6.In the element.xml under the module, make sure to the entries are present for HTML files.

7. If there are any resource files such as CSS/JavaScript/Images you can add those files to this solution by deploying it to Styles/1033 folder or layout folder of 16 hive as shown in above folder structure.

8. Now, at this stage if we deploy the above solution, html master pages will be available in master page gallery of the site collection and here you need to publish the html master page by using context menu and then it generates .master file. At this stage  you apply the master page to the site. Entire process can be automated by creating a feature receiver as shown below.

9.Now, Right click on feature receiver to add event receiver as shown in the image below.

10. Once the file is created, In feature activated method add the below code

11. Double click on feature receiver to see the below properties.


12. Use the below PowerShell script to deploy the wsp to the environment.

Install-SPSolution -Identity MasterPageCustomSolution.wsp -WebApplication https://abc.com -FullTrustBinDeployment -force

13. Once the solution is deployment, go to site collection feature and activate the feature. The master page will be available for you in master page settings page and can set it as default master page.

Bootstrap Image carousel using SharePoint Jquery REST API

In this blogpost, I am going to create Bootstrap Image carousel using SharePoint Jquery REST API, The basic idea is that images are retrieved from SharePoint list and by using SharePoint Jquery/ REST API I will be retrieving the list items and render it to UI using Boostrap version 3 carousel code.

SharePoint list: I am maintaining images in separate picture library and I am referring the links in below list. Carousel images are clickable and links are indicated in appurl. I am also doing sorting on images so that I can show specific image in order. I had added reference for boostrap.js and bootstrap.css

Bootstrap Carousel:
Here is the link for boostrap carousel version 3.

Usage: Above code can be directly placed in content editor web part.

Result: