Solved

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

Posted on 2014-09-09
10
300 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 500 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

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 500 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
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...
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
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…

696 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