Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I was wondering if it is possible to filter a list item based on metadata values from another list item.

I tested it locally but it didn't seem to work althougth another post here said it should work (Pass list item metadata to filter for document library). Created a list with a Term Store field and then created another list using the same term store field. Populated both lists with items and made sure that all lists have items that should match. Then I set up the connection on the one list and created the filter so that the Term Store field from list A should filter the Term Store from list B. But unfortunately this results in no results at all althought it should have any results (if the filter were actually working).

Is this a known issue with SharePoint 2010? It just seems weird that they offer those fields for selection on the filter dialogue when they seem to be not supported.

share|improve this question
    
Interesting, it should work as described but I've never tried specifically with metadata columns. Did you try with another (simpler) type to make sure you have the correct recipe? –  Louis Feb 22 '12 at 11:47
    
Also when two lists are connected, it should give you a new column in the master list indicating which is selected for filter. You have to select one to get some values in the 2nd list, unless you configure the webpart's option to not send a row by default. –  Louis Feb 22 '12 at 11:49
    
Yes, it works with "normal" columns, like single line of text or choice. The lists are (and don't have to be) connected - no lookup exists from list A to B. This isn't needed an isn't a problem when using other column types as I don't want to filter based on the connection lookup but on custom defined column values. –  Shihan Feb 22 '12 at 12:34
add comment

1 Answer

up vote 2 down vote accepted

As it seems this is a limitation of the managed metadata columns in SharePoint 2010. Let's hope a future SharePoint version will improve this behaviour.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.