Solved

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

Posted on 2014-09-09
10
281 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
  • 5
  • 5
10 Comments
 
LVL 31

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 31

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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 31

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 31

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 31

Expert Comment

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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

773 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