?
Solved

Hierarchy List Filter - Should I use Managed Metadata or not?

Posted on 2014-09-09
10
Medium Priority
?
306 Views
Last Modified: 2014-09-15
I need to create a SharePoint page that displays four lists that are filtered on an 'Item'. Mockup
The structure that I need to filter on is in a hierarchy with three levels (An example is shown in :
* Group (Currently 4 groups)
   * Area (Currently ~100 areas)
      * Item (Currently ~400 items)

Hierarchy example
Each of the four lists has 'Item' in each list (Each of the 400 items are unique).

First I tried using Managed Metadata
Since the hierarchy is used in multiple places across the site, I tried using the term store to create a Managed
Metadata column. This provided an effective navigating structure when using the column headings at the top of a single list. But I was unable to select this column as an option when filtering. Our SharePoint functionality is fairly 'locked down' (Searching is also locked down in our organisation) and I don't appear to have access to the Content Query Web Part.

Then I tried using a Flat Structure
I also tried using a flat structure with columns Group, Area and Item, then looking up these columns in the other list. Item was the main column (where the hyperlink is). When I did this Item is no longer available in the List Filter. It would also mean that there would need to be three connected filters, rather than simply one which would make the page even busier.

What should I be doing?

Regards,
Nikki
0
Comment
Question by:NikkiGu
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
10 Comments
 
LVL 32

Assisted Solution

by:Jamie McAllister MVP
Jamie McAllister MVP earned 2000 total points
ID: 40313892
First question; CQWP appeared unavailable. Was the Publishing feature enabled on the site? This is required for CQWP.
0
 

Author Comment

by:NikkiGu
ID: 40314326
Hi Jamie,
The publishing feature is not enabled. I have requested for it to be enabled, but it doesn't look likely. There are some strange things locked down in this organisation. Including search scopes, office services, etc.
Thanks,
Nikki
0
 
LVL 32

Expert Comment

by:Jamie McAllister MVP
ID: 40314643
I think you'll need to use something like SP Services for the filter value;

http://spservices.codeplex.com/wikipage?title=%24().SPServices.SPCascadeDropdowns

After that, it is possible to connect multiple List Views to a single filter. My best bet would be to re-write the URL with javascript to include a querystring parameter for the filter value.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:NikkiGu
ID: 40316240
Hi Jamie,

Does that mean that you don't recommend using Managed Metadata for the column?

Thanks,
Nikki
0
 
LVL 32

Accepted Solution

by:
Jamie McAllister MVP earned 2000 total points
ID: 40316313
I'm not convinced mm will enable the multiple filtering you need.
0
 

Author Comment

by:NikkiGu
ID: 40316345
Thank you so much for your help.

My preference is for the multiple filtering to simply be in the one box. Rather than three separate fields as the higher levels in the hierarchy are not helpful in their own right - only to navigate to the lower level. Do you think mm will provide this?
0
 
LVL 32

Expert Comment

by:Jamie McAllister MVP
ID: 40316488
You can create a hierarchy 4 levels deep in mm, certainly.
0
 

Author Comment

by:NikkiGu
ID: 40322186
Hi Jamie,
I have been able to get site publishing turned on and now have access to the Content Query Web Part.

You have mentioned that 'I'm not convinced mm will enable the multiple filtering you need.'

Why do you think this?

Regards,
Nikki
0
 

Author Comment

by:NikkiGu
ID: 40322480
Hi Jamie,
Your comment 'I'm not convinced mm will enable the multiple filtering you need.' was exactly right. It's not providing the filtering I need. But I'm able to use CQWP to create multiple entry points based on different attributes.

Then I used a Content Query URL String in the main page for the unique identifier that linked all the lists (intead of a filter at the top of the page). This worked and the CQWP links to the page with the identifier in the URL.

Thank you very much for your help. I wouldn't have been able to achieve it without your assistance.
Regards,
Nikki
0
 
LVL 32

Expert Comment

by:Jamie McAllister MVP
ID: 40322548
Thanks Nikki. I'm glad you got the results you needed.
0

Featured Post

What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question