Kartic's Musings on Corporate Information and Knowledge Management

May 29, 2007

Filtering or Grouping by Multiple Choice fields

Filed under: SharePoint — kartickapur @ 4:28 am

A SharePoint list does not allow users to create a view grouped by or filtered by ‘Multiple Choice’ or ‘Lookup’ fields.  

The reason for this was explained by my senior colleague ‘Ishai Sagi’:

“Multiple selection fields are not indexed, and as such are not “seen” by the SPSiteData query or the search engine when you do filters. This means that the built-in web parts will not group or filter on those fields, and to write a custom one that does it will be complex and reduce performance.” 

Dataview Web Part, however can be used to filter by a multiple choice field. It can only be configured using SharePoint designer. There is still no out of the box option to group by those multiple choice field.

 

There is another option however which can be given to the users.

As shown below, the users have an option to filter by multiple choice field, directly through any view. In the ‘Projects’ list shown below, Practice Group is a lookup field with multiple choice. As shown, you can filter using ‘Information management’ or ‘Enterprise solutions’ choice out of the box.

filtering-example.jpg

Advertisements

4 Comments »

  1. I like the valuable info you supply on your articles.
    I will bookmark your blog and test again right here regularly.

    I am fairly sure I’ll be informed lots of new stuff right here! Good luck for the next!

    Comment by i — April 30, 2013 @ 6:09 am

  2. In case you know the total listing of video game
    titles via checking the Classy Coin area, I suggest extra associate by means of on the net Classy Coin bedrooms testimonials,
    which you’ll want to come across within the world-wide-web. Often, the people in collusion may possibly chat an alternative vocabulary compared to the other avid gamers in the stand.

    Comment by Classy Coin — June 6, 2013 @ 8:59 am

  3. Hmm is anyone else encountering problems with the images on this blog loading?
    I’m trying to determine if its a problem on my end or if it’s the
    blog. Any responses would be greatly appreciated.

    Comment by http://www.blogcoway.com/ — July 14, 2013 @ 12:17 am

  4. I have read so many articles or reviews regarding the blogger
    lovers however this post is genuinely a pleasant piece of writing,
    keep it up.

    Comment by settled — April 21, 2014 @ 5:25 am


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: