Create a Simple SharePoint 2013 Employee Directory on Office365 – Part 5 – Sorting & Refiners

This post in the series was sitting in my “outbox” for a long time. Sorry to people like Nigel (@Nigel_Price) who probably gave up on me!

In a company with 100 employees, clicking on once of the letters are the top of the page will probably narrow things down well enough that you’ll see everyone with that letter at the start of their last name on one page. If you have many more employees, you may end up with too many people to see very easily. And since we’re limited to 50 results in the Search Results Web Part, you may need to page and/or scroll a lot, depending on what properties you’ve decided to show for each person (one line vs. two lines or more, for example).

There are a couple of out of the box capabilities we can use to sort or filter our results a bit more. Because we’re using search to drive the directory, we have all of the native search capabilities that SharePoint gives us. Let’s take a look at adding some sorting and improving the refiners.

Sorting

In the Web Part Properties for the Search Results Web Part, there is a checkbox labelled “Show sort dropdown”. It’s in the Settings section (which is full of other options as well).

2015-02-26_12-04-17

By checking the box and adding some of our own JSON into the field below it, we can control what sort options are available. The JSON should be an array of sort options taking this form:

{
    "name": "Last name (A-Z)",
    "sorts": [{
        "p": "RefinableString00",
        "d": 0
    }]
}

The values break down like this:

  • name – The text value you’ll see in the dropdown
  • sorts – The parameters for the sort that apply when the option is selected
    • p – The managed property to sort on
    • d – [0 | 1] If 0, the assort is ascending, if 1 it is descending.

Note that for the Last name sort above, I’m using the RefinableString00 managed property I set up in Part 4. If we tried to do this with the LastName managed property we’d get an error because that property is not Sortable.

Here’s a pretty basic set of sorting options that should at least get you started. I’m giving you four pretty basic sort options:

  • First name (A-Z)
  • First name (Z-A)
  • Last name (A-Z)
  • Last name (Z-A)
[{"name":"First name (A-Z)","sorts":[{"p":"FirstName","d":0}]},{"name":"First name (Z-A)","sorts":[{"p":"FirstName","d":1}]},{"name":"Last name (A-Z)","sorts":[{"p":"RefinableString00","d":0}]},{"name":"Last name (Z-A)","sorts":[{"p":"RefinableString00","d":1}]}]

You should be able to take this and enhance it for your own needs.

Refiners

Next we probably want to adjust the refiners a bit. Out of the box, the Refiners Web Part will display properties that look to a machine like useful ones, but they may not be the most useful in your organization. You may want to show refiners that are part of the search results already or you may want to show refiners that aren’t visible in the results.

Changing which refiners you see and in what order works like this:

  • Edit the page
  • Put the Refinement Web Part into Edit Mode
  • Click on Choose refiners
  • Change the settings
  • Save it

The key action here is to add or subtract from the Selected refiners in the Choose refiners dialog. For each refiner, you can change the settings on the bottom of the page. Note that refiners use Display Templates as well. I’m not going to go into building Refinement Display Templates, but you can see them in _catalog/_masterpage/Display Templates/Filters.

In my case, I’ve got refiners for Department, JobTitle, PeopleKeywords, and BaseOfficeLocation. You will probably want some others which work for you.

Refinement configuration

You should see the impact of these changes immediately upon saving the page. Assuming that the properties you have selected have been indexed, that is.

What Next?

There are a number of different directions we could go from here. We could build a similar page to show a Site Directory [Nigel]. We could enhance the display of each person to show additional information about them or metrics about their recent activities. We could add as second alphabetical listing row below the first so that if you selected the letter B, you could the choose the next letter (only lit up if there are people lurking there). As with most functionality like this, coming up with the innovative ideas can be even harder than good execution on them. In this case, some of the limitations in Office 365 make it even more difficult that it should be.

I’d love to see:

  • Ability to trigger a full crawl of the User Profiles when we change the schema. It wouldn’t have to happen right away, but it would at least remove the need for Powershell.
  • Allow us to build a more intelligible set of “RefinableType” properties so that we can manage them better. If we create more than a handful of these special mappings – as most organizations will do over time – then management is going to be cumbersome at best. We can’t even search by the Alias names.

Then basic process here should work for many different use cases. As you’ve probably gleaned from this series, building good metadata and taxonomy isn’t just an academic exercise. The whole point is to make content easier to find, and a People Directory is no different: it’s a customized page that allows us to perform a certain used case in an optimal way. What “optimal” means is going to vary based upon the characteristics of your organization.

  • How big is it?
  • Why would people be looking for each other (beyond the simple phone list idea)?
  • What information is important for people to see vs. that which must be secured?
  • etc.

I hope you’ve found the series useful. If you’d like to know more or have other ideas, I’d love to hear about them in the comments below.

References

<update date=”2018-01-12″>

Mikael Svenson (@mikaelsvenson) – ever the search guru – just posted a great way to exclude Office 365’s service accounts and other such chaff from the employee directory listings. Check out his post Excluding SharePoint Online service accounts from people search. When I added -accountname:spo* -PreferredName:”Foreign Principal” to my search query in the People Search Core Results Web Part in my Sympraxis tenant employee directory listing, it got rid of all the junk. As Mikael points out, your mileage may vary, but he gives some excellent things to try that should work in most cases.

</update>

Series Navigation<< Create a Simple SharePoint 2013 Employee Directory on Office365 – Part 4 – Search Schema

Similar Posts

17 Comments

  1. A scenario. I have been told by my boss to talk to Christian in Engineering, but Kristian (Scandinavian) and Kristien (Flemish) sound the same. Can SP2013 support me in constructing a query to find all possible people with a name sounding like ‘Christian’?

    Of course just to make matters more difficult if my boss had told me to talk to Chris then Chris can be short for Christian and Christopher, and Kris likewise.

    1. Martin:

      I believe that SharePoint search does that sort of matching out-of-the-box, but it can be tuned for your specific situations. When you search for “Christian” using People Search, do you get the others? I think you should. We used to call this sort of matching “SOUNDEX”, but I don’t know what the buzzword is these days.

      M.

  2. Hey Marc, awesome posts!!….I have a quick question…I get all the available users in Sharepoint showing in the search, but what I really want is to only see the active users, or even a group of users, like i.e: active employees. Could you please help me with that?, thanks in advance :)

    1. @Joe:

      This will depend on how you know an employee is “active”. It’s usually some property on the user profile, and you should be able to filter on it in the queries. Problem is, every organization seems to think about “active” differently.

      M.

  3. Unbelievable. I read the beginning of this series in December 2014, now we have 2016. This must hold a record of some kind :-)

    Thanks for posting the final post, Marc. I feel complete now.

  4. Hey Marc great series,, I am looking for the result as Joe. The way I mark them as active is my having the company name filled out in AD. I can filter for company = not blank? Or better yet = the actual company name?
    Sam

  5. One item that didn’t seem to get touched on (unless I missed it) is how to filter out those service accounts (non humans)

  6. Hi Marc, your post has been extremely helpful. One suggestion, it took me a while to figure out why the new Display Templates were not showing as choices in the webpart dropdown. It is because I had not published them. Probably an obvious thing to a SharePoint admin, but for us reluctant SharePoint types, not so much.

  7. Marc, I’m new to SharePoint but was able to follow the steps, I think. But I can’t seem to get the Alphabet result when I search for names. Also, I can see all users by default in my main search window. What I’m I missing?

    1. Same! I see the drop down, but for some reason the sorting does not work for last name. Not sure what I am doing wrong as I copyed the code to the letter.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.