.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Managed metadata column not displaying data

Posted By:      Posted Date: September 24, 2010    Points: 0   Category :SharePoint


We are in process of rolling out our new intranet on SharePoint. Two days away from the launch we have run into a strange problem. We have various custom content types and within that we have custom columns which are managed metadata. The columns are then exposed in various document libraries and users choose appropriate metadata when adding the documents to the library. Everything was working fine, until yesterday all of a sudden we were not able to see any data in the columns which were managed metadata columns. But if we edit the properties of the document we can see the field is populated.

Another strange thing is that if the user has full permission in central admin they can see the metadata in the columns, but anyone else (including site owners) cannot.

Can anyone please shed some light on this and if someone knows how to resolve this?



View Complete Post

More Related Resource Links

Provision DocumentLibrary with Managed Metadata column

Via the SharePoint 2010 UI I've created a DocumentLibrary and added a new column of type Managed Metadata. I've associated a TermSet with this column and all works fine. Now I need to create a deployment package in Visual Studio 2010. It is easy enough to create the Document Library. I've followed the below steps 1. Create empty SharePoint 2010 project 2. Added new Empty Element to the project. In the Elements.xml I have <Field ID="{15712E76-A603-43AB-885E-CE48BD216381}" Type="TaxonomyFieldTypeMulti" Name="DocTags" DisplayName="DocTags" ShowInDisplayForm="TRUE" ShowInEditForm="TRUE" ShowField="Term1033" Required="FALSE" StaticName="DocTagsInternal" Group="NotSure"/> 3. Added ContentType to the project. Added FieldRef elements to the Element.xml 4. Added List Definition From Content Type and associated it with the above Content Type. 5. Created a List Instance of the above List Definition. 6. Build and Deploy. 7. Associate the column with a Term Set. 8. Add Document to the Document Library. I can select a Term from the applicable TermSet, but when I save the document I get: Failed to get value of the "DocTags" column from the "Managed Metadata" field type control.  See details in log. Exception message: Invalid field name. {00000000-0000-0000-000

search on managed metadata column values

I am trying to search on a managed metadata column in a list.  I have the managed metadata as a mapped property (these are automatically set up actually). I have a column frequency (daily, weekly, monthly, yearly) I can enter a search box owstaxIdFrequency=#a132a333-39f1-4737-9ad4-a932482e025f   //this is the taxonomy guid for Daily.  This shows results. How do I search on the word "Daily" in the frequency column?  (I just want to figure it out on a simple search first meaning just using one search box)   I noticed that there are extra maped columns for managed metadata columns (owstaxIdFrequency also has owstaxIdFrequencyx0020Tag, I tried owstaxIdFrequencyx0020Tag="Daily", but it didn't work)

How to filter managed meta data column using page query string?

I have two managed term sets as follows: Articles:Downloads Projects:Downloads I am trying to use a content query web part to filter a list based on the above manged meta data column. I want to filter out only "Articles:Downloads" Scenario 1: When I edit the web part and directly set the filter option with the managed meta data column to "Articles:Downloads" it works fine. When I export the web part, in the .webpart file, the "FilterValue1" property has a value "Downloads|9096e43b-555d-4879-9acc-b4ada9ea9910". Scenario 2: I want the web part to get the filter information from query string [PageQueryString:pageType]. So I tried using these options: a) pageType=Downloads      This works but returns downloads under 'projects' as well. (i want downloads only under 'articles')  b) pageType=Articles:Downloads     Does not work and shows no records c) pageType = Downloads|9096e43b-555d-4879-9acc-b4ada9ea9910     Does not work. (This value is the same as one found in 'FilterValue1' of the static web part). c) pageType = Articles:Downloads|9096e43b-555d-4879-9acc-b4ada9ea9910     Does not work. d) pageType = 9096e43b-555d-4879-9acc-b4ada9ea9910     Does not work.   What am I missing here? Can some one please help?

Add managed metadata column to list - access denied + terms not visible in lists


Firstly the following is not a problem for users given "Full Control" (and possibly other permission levels might work) at the web application level in central admin.

For any other user with permissions set at site collection level, even "site owners" (full control) , these problems arise.

  1. When adding managed metadata columns to a new document library list, clicking save results in multiple access denied errors getting logged (as seen using UlsViewer) and an exception is raised (sharepoint error page)
  2. In existing document library lists managed metadata column headings are displayed in list views but the terms text is not displayed.
This problem shows up even if the logged on user is the term set owner.  "Available for tagging" is enabled, submissions policy is closed.
Looking at http://<the-site-domain>/Lists/TaxonomyHiddenList/AllItems.aspx and then checking list permissions I can see that "All Authenticated Users" has Read permission level.
Integrated windows authentication - NTLM + Claims Based Authentication is the only authentication method used. It's an intranet site. 

Thanks in advance for any help.

Managed Metadata column not grouping correctly



I'm trying to group a list by a Managed Metadata column, it works fine with my farm admin/site collection admin user account however i can't get it to work for any other user account. I've tried giving one of the other user accounts term store admin but still no luck. With these user accounts all i get is one group which contains all items regardless of what term is selected for the item. The single group displays as an empty term e.g. it looks something like 'MetaData Column: (80)'. However if you look at individual columns you can see what term has been selected.

If it makes any difference I'm experiencing the issue while using an Enterprise Wiki site, I'm trying to group pages in the pages library by the 'Wiki Categories' column. I've set the field to point to a new term set and disabled multiple entries.

Any ideas?

Possible bug in SP2010 - Managed metadata column and STP document library template


Hello I have a problem with managed metadata on two different servers and would like to ask you to try it.

I assume you have managed metadata service running.

1, Open some document library in some site
2, Create column - managed metadata type and select some termset and set it as required.

3, Upload a document and fill in metadata when you will be asked.

4, Then edit properties and check, that metadata are there.

5, Save this library as template.

6, Deploy document library from this template and try steps 3+4.

My problem is, you can select metadata, but they are not saved. e.g. when you check document properties managed metadata are not there.

Can you confirm this behavior ?
Thank you very much.


P.S.: one more weird thing. If you do metadata filling using office 2010 compatible application. Metadata remain there, but they are not visible in document library properties.

Tomas Paulas MCP,MCSA,MCSA-Messaging

Displaying column data from another source?


 I have a gridview databound to a database table, and i want to make a gridview column display data that is accessed using the primary key data from the databound source to address a table which is not the one databound - how would I do this please?

problems with filtering managed metadata column


I like managed metadata in many way, but there´s several things I can´t get "right":

- In a document library I have managed metadata columns. If i filter with one column (say I filter Europe in column Continents) , every other column take´s away unrelevant filtering options (Country column should only show European cuntries) , except the  managed metadata columns, wich show everyting. Why? Can I change that?

- I have a long list of terms in a managed metadata column. When I try to filter that column, I have to press "more" severel times to get the term I want to filter on. Is it posible to see all terms at ones or se more that 20 terms before I have to click on "more"?

Thanks for helping me,


Managed Metadata column in DataSheet View


i am unable to edit managed metadata columns in the DataSheetView, i have other columns which are number, text field type which i am able to edit. So the view is not readonly, it is only when i click cell with the managed metadata column i get the readyonly prompt.

Evironment : Sharepoint 2010, Office 2007 and a pissed off customer

Appreciate any help



I am what i am

Read Only Managed Metadata column in DataSheet View


i am unable to edit managed metadata columns in the DataSheetView, i have other columns which are number, text field type which i am able to edit. So the view is not readonly, it is only when i click cell with the managed metadata column i get the readyonly prompt.

Evironment : Sharepoint 2010, Office 2007 and a pissed off customer

Appreciate any help

I am what i am

displaying row data in a vertical column format


The results of my query display the output in rows.  Each row of data belongs to an entity and contains about 12 fields.  I would like to generate a report that lists the entity and its corresponding data below it, in a column format. 

Instead of:

companyname1  contact1 phone1  email1 address1

companyname2  contact2 phone2  email2 address2

companyname(n) contact(n) phone(n) email(n) address(n)

I would like to have the info reported as follows:













How do I do this?  If I can get the query data displayed this way, I can export it to another program to do the last of the formatting.  I also have tried using Microsoft SQL Server Report Builder with the table/matrix format and with the list option.  The list option sort of works, but doesn't look very good.  Any ideas?




Cannot copy the value of a managed metadata column from one list to another


I have a problem when trying to copy a value of a managed metadata column from one list to another by a Sharepoint Designer (SPD) Workflow

I have two lists. "Locations" and "Employees". "Locations" has a Content Type integrated that has a Site Column of the type managed metadata named "Geographic Location". This Managed Metadata column describes the geographic location from continent down to the city name. I also have a Content Type for the "Employee" list. This one contains a lookup column "Location Abbreviation" on the title column of the "Locations" list and the same managed metadata column "Geographic Location". Now my Workflow is created to work with the Content Type "Employee" and goes like this:

Set current item:Geographic Location to Locations:Geographic Location (where Current Item:Location Abbreviation equals Locations:Location Abbreviation (Lookup Value (As Text)))

But the workflow always reports "Error occured". The message is:

"The workflow could not update the item, possibly because one or more columns for the item require a different type of information."

But is is very unlikely that this message is useful as both columns use the same Site Column. Do you have any Ideas?

Problem updating a managed metadata column value



I have a document library where I've added a managed metadata column that contains a list of city names.
So far so good, I can add documents and set a value for this column.

The problem starts when modifying a city name. E.g. I change New York into Washington.
All items that were linked to New York will still show New York and not Washington.
When adding a new document I can pick Washington from the list of cities, but in my view it will still show New York (even though I picked Washington and there is no sign of New York in the values). When opening "view properties" it will still show New York. When opening "edit properties" it will show Washington.

This is very confusing to users (and also for me)!
Is there a timer job or something that should run before all items will use the correct updated value ?

Using ASP.NET 3.5's ListView and DataPager Controls: Displaying Data with the ListView

Prior to ASP.NET 3.5, developers who needed to display a set of records could choose between the GridView, DataList, and Repeater controls. The GridView provides rich data features, but has a very boxy layout; the DataList and Repeater allow for a more flexible layout, but lack the "point and click" data features found in the GridView, DetailsView, and FormView controls. The ListView bridges the gap between layout flexibility and built-in data features.

This article, the first in a series of articles on the ListView and DataPager controls, looks at the ListView's many available templates and illustrates how to display data. Read on to learn more!

Displaying Data using ASP.NET 2.0 Repeater and C#

This tutorial will show you how to display data using the .NET Repeater Control, ASP.NET 2.0 and C#.NET

The Repeater control is a powerful tool and is easy to use.

First, you will need to import the System.Data.SqlClient namespace.

Rendering data with HTML tags in the DD Gridview for a selected column


I am having trouble finding out where and how to HTML Encode a cell's data on the Dynamic Data (v4.0) gridview of List.aspx.  As a simple case, suppose I have formatted cell data that is A<br/>B in the DB.    Obviously, I want A stacked on B in the cell.

It seems gridView1.HtmlEncode = true has gone away.

So maybe I'll try to catch it on the RowDataBound event:

protected void GridView1_RowDataBound(Object sender, GridViewRowEventArgs e)

            if (e.Row.RowType == DataControlRowType.DataRow)
                // Html Encode the cells


but this event never fires?

Has anyone figured out how to properly render HTML tags data in the List.aspx's GridView1? 

If I figure this out, then I can add a MetaAttribute called something like [EncodeAsHtml(true)] and be on my way.  Thanks!

Vista and Office: View Data Your Way With Our Managed Preview Handler Framework


Stephen Toub shows you how to write your own Preview handlers for Windows Vista and Outlook 2007.

Stephen Toub

MSDN Magazine January 2007

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend