Skip to main content

Posts

Showing posts from December, 2014

Bug: Column filter does not work with Metadata Navigation

Here is another bug. When you are using Metadata navigation for a Library, column filter does not work! This was tested in SharePoint 2013 on-premise and Online versions. Here are simple steps to reproduce this bug.

1. There is a document library which has Managed Metadata column (Locations) and Metadata navigation is enabled for this library.

 2. A value ("Bengaluru") is selected from metadata navigation and corresponding filter is applied in the library.

3. Additionally filter is applied on Title column (selected only Desert). However, items are not filtered.

Note: This works fine in SharePoint 2010.

Embedding Excel in SharePoint is more easy!

Earlier if any Excel need to be embedded in a page, user had to use Excel Web Access Webpart and set the property to point to Excel. Now it has become much simpler and more powerful. Just by copying the URL with adding few parameters and using the URL in  iframe HTML tag is all required to embed it in a page.

I'm going to show you this in simple 3 steps.

Step 1:Prepare an Excel.

I used Microsoft provided Excel template for this demo. I saved this excel directly to a SharePoint library.

Step 2: URL manipulation

Click on the document to open it within browser. Copy the URL from browser and paste it in a Notepad.

Replace the parameter from "action=default" to "action=embedview" and add another parameter wdbipreview=true.

So your URL looks something like this (you have changed only highlighted ones).

http://[your domain]/sites/[your Site Collection]/_layouts/15/WopiFrame.aspx?sourcedoc=xxxxx&file=Project%20timeline%20with%20milestones.xlsx&action=embedview&am…

How to get Search Refiners using REST API

As Title says this blog is about getting SharePoint Search Refiners using REST API. I could not find examples in internet for getting refiners and how to read refiner JSON data. So I did kind of research and trials and finally I was able to get the refiners using REST API. I assume that you are already familiar with fetching search results using REST API. If not, I suggest to read this fantastic post by Chris O'Brien. I have extended the example given in this blog to refiners.

Let us first understand how to frame REST query to get refiners. The syntax of the URL is

http://[your site]/_api/search/query?querytext='SharePoint'&refiners='[refiner]'

To get refiners, refiners keyword should be passed as a parameter along with the actual refiner that we need. Before I show an example, let us first check how XML response would look like if you don't add this keyword.
As marked in Red, if we don't pass refiner as parameter, RefinemenetResults will return NULL.

N…

What is OneDrive in O365?

When I took the trial subscription of O365, the first thing which caught my attention was OneDrive. This post is all about OneDrive, its features, and how it really helps users specifically.

If you are familiar with Google Drive or erstwhile Sky Drive, you already know what OneDrive is! It is a cloud storage drive for your documents. Instead of storing your documents in your laptop/desktop, you can basically store it on OneDrive. The biggest advantages are that you dont have to carry the data with you. It's available somewhere else and you can connect to your data from anywhere and anytime. You don't have to really bother about losing data because of your system crash or virus. Another notable feature is you can decide to keep your data private or share with others.

When you connect to O365, OneDrive link is visible evidently on suite bar as shown below.
When you click on it, you'll be taken to a document library called "Documents".
Few things to be noted here. …