Home » Sharepoint

Unable to use Managed Property mapped to Choice Dropdown list column in MOSS 2007

I have a choice list column containing dropdown values. I crawled the content source and created Managed Property to map it.

Also Configured Advanced Search webpart to display the property. But when I pick the property and perform search with values then no results are returned.

Can any one can help me out.?

Thanks in Advance.!


3 Answers Found


Answer 1

Hey Jacky_123,

Unfortunately while SharePoint 2007 will let you map a managed  property to a choice  field it will not return search results for it (which is not very intuitive).  This gets better in SPS 2010 - http://www.sharepointanalysthq.com/2010/07/the-death-of-the-choice-field-in-sharepoint-2010/.

One possible work around is to change your choice column  to a lookup column, SP 2007 will then return search results from the items in the lookup column.


I hope that helps!


Answer 2

Hi Tom,

Thanks for your suggestions. Actually I tried with even lookup columns also. The problem with it is when I search for text items(values in the lookup column) search results is not returning anything.

By investigation I found out that if I search only by numbers i.e id of the lookup list  items then it is returning the required items in the search result. But it is not intuitive in nature.

So as a workaround I created a Calculated field for every dropdownlist column. Then mapped  Managed property  to these column. It is working fine then.


Answer 3

I'm glad it worked out Jacky!


I currently have a Choice column in my List and I would like to create a new Choice Column in my List and "link" it to the values in the original Choice column.  That is to say, I do not want to maintain the Choice selections in both columns, I only want to maintain them in one column and have the values automatically appear in the Linked column as well.

Is there a way to do this inside of a List or Document Library.



Hi, I am trying to map a master connection property in MOSS 2007. And the Data source field to map box just isnt there for the master connection. What do I need to do to add this?

Here's a pic: http://imgur.com/sQ8rl.jpg 



I am trying to delete unmapped Crawled properties by editing Sharepoint Category in Crawled Properties. And i checked the delete all unmapped crawled properties check box. but this is not deleting unmapped properties. Even i tried to delete this by code.. 




                using (SPSite currentSiteCollection = new SPSite("http://server name"))



                    // the schema class actually represents managed and crawled proeperties


                    Schema schema = new Schema(SearchContext.GetContext(currentSiteCollection));




                    // get the sharepoint category


                    Category category = schema.AllCategories["SharePoint"];




                    // delete all unmapped properties






                    // after delete an update is required






Still i am not able to delete the crawled properties. Please help me on this..,



we need to move an application (only a site collection/portal site)  hosted in farm using  WSS 2.0(SharePoint Portal Server 2003 integrated with Project Server 2003) to a new farm where is installed WSS 3.0 and SharePoint Portal Server 2007.

We do not care at all about the part managed by Project Server 2003 . We are interested to obtain all lists, items and users information stored in the application (basically all the content part managed by MOSS 2003).

Which is the best strategy to get the job done ?

We have tried these steps to check if our strategy could work but it didn’t:

·          Create a new virtual server and portal site in the WSS 2.0 as test environment

·          Install and use prescan.exe on the portal site (it didn’t find any error)

·          Backup the portal site (using stsadm)

·          Move the backup to the new farm

·          Restore the backup (using stsadm)

We got a message error warning that the WSS used in the backup is different then the one installed in the farm target and the operation cant be completed. Did we miss something or it isn’t just possible use this procedure to migrate content by MOSS 2003 / WSS 2.0 to MOSS 2007 / WSS 3.0?

Browsing around, I found old topics talking about this operation  like the url linked below:

·          http://shaiju-sp.blogspot.com/2007/08/wss-20-to-wss-30-migration.html

where is suggested basically these steps:

1.     Backup the WSS 2.0 site

2.     Move the backup to a new server

3.     Install WSS 2.0 in the new server and restore the backup

4.     Install WSS 3.0 (upgrading the WSS 2.0)

5.     Execute the prescan tool on the site

6.     If errors are found then run psconfig –cmd upgrade –inplace b2b –wait –force

Now, before going to apply this procedure and ask a new environment at our clients, we would like be sure that this is the right thing to do to solve our problem..

I also read that there are around third party software that can do this operation automatically, any of this tool is freeware and efficient?

Else, anyone can confirm this or suggest another procedure to follow in case you need to move WSS 2.0/MOSS 2003 to a new environment using WSS 3.0/ MOSS 2007 ?

Any help will be really appreciated!



Hi, I've changed the a user profile settings in CA (see below) so it is no longer mapped to AD, but when I edit the user profile in SharePoint MySite I have a yellow triangle with an exclaimation mark that states "indicated a filed that is updated automatically from the corporate directory. Changes to these properties may be lost. But I have removed the mapping as above. Am I missing some thing or is there a job that I need to run to carry the update through.   

I made the change in  - "user profile service application - manage user properties - Work phone" I have removed the "property mapping for Synchronization" so it now displays "There are no items to show in this view" - Do I need to make further changes to carry this through? 


Hi All,

I'm trying to understand how to customise MOSS to achieve the following:

I need to lookup from a list to multiple documents stored in a documetn library.


- List item 1 --------> Lookup to Doc 2

                  --------> Lookup to Doc 5

- List item 2 --------> Lookup to Doc 3

                  --------> Lookup to Doc 5

                  --------> Lookup to Doc 8

- List item 3 --------> Lookup to Doc 1

How can I achieve this? is it possible that in the lookup I have a "search" option?

Thanks all



We have two requirements:

First, we need a column which shows the count of attachments that are for uploaded each item, the list structure is like below:

No. Of Files AttachedTitleCategoryDescriptionOwnerRequested on Attached Files

We have tried the option of creating a webpart using SPD but does not served the purpose as we need this column part of the list not as another list item. Is there any workaround to achieve this?

Second, is there any way to display the attachments in a List item (the same way they are displayed in a document library like if we click on the icon or the title of the file we must be able to access the document) as in a List to view attachments we need to go into the item.

Thanks for the help in advance.


I have a SharePoint site in which I have a photo database (picture library). The photographs are of different types of signs and each have metadata stored about them (for example, what type of materials were used, if the photo is interior or exterior, what type of sign it is, etc. Almost all of these columns are multiple selection fields). I want to be able to search this library by each of these metadata fields in the advanced search as a property restriction. (so look for an exterior monument sign for example).

I have been doing research and know that I need to perform a crawl of this metadata and then create a managed property. I have not been able to find a good step by step description of how to do this and I am looking for some help. I dont have a strong coding background or much familiarity with the sharepoint central administration site. Please help!


Hi, I'm trying to display records from two different document lists in 1 result grid.

I have one managed property caled customernumber and the mapping has the customer numbers from the two different doc libs,

like: customernumber =  customnumdoclib1;customnumdoclib2

now, if there is a record match on both crawled properties, and my webpart has a grid field set to 'customernumber', shoul it return two rows?

one for each mapping? or will that merge the results in 1 row?


I am trying to create some content types, but this also happens when creating new columns in a list.

Ok, here is my setup (which is the most basic way to replicate the issue):

List 1: Department List
Columns: Department Name (Single Line of Text)

List 2: Document Owners
Columns: Document Owner (single line of text), Department (Choice or Lookup from Department List), Email (single line of text), Lookup Field (Calculated).

Content Type: Quality Document
Columns: File Name, Title, Document Owners (Lookup from Document Owners List), Email (pulled in with Document Owner), Then i want to also pull in Department from the Document Owners list.

That is where my problem is.  When i select the Document Owners List as the list to get the information from, there isn't the option under "Add a column to show each of these additional fields" to pull in the Department column.  This occurs if i use a Choice in the Document Owners list, or if i do a lookup from the Department List.

My preferred method of implementing this system would be to have a multi-value lookup field in the Department List for Document Owners so that the Owners are attached to the Department, and if the owners change for the department they also change for the document that is for said department.  But, i run into the same issue that i can't pull those columns from that list either into the content type.

Is this a bug or is this by design that you can't pull in columns via a lookup into another list or content type if they were a choice column or pulled in via a lookup in the source list?

Any help would be appreciated, even other possible solutions.  Let me know if you have any questions.  Thanks.



After upgrading from MOSS 2007 to SharePoint 2010, the following issue is now occurring in the new and edit forms when not displayed in the "dialog" window. 

List of options for a dropdown column in a SharePoint 2010 list when viewed by a link created that pointed to the new or edit form shows the list options in a off-center or skewed location and not direclty under the drop down box.  This could be inches below and inches to the right typically.  When the new or edit form is shown in a dialog window using the "new item" link at the end of the list or in the Ribbon, the dropdown list items are displayed directly below the box appropriately.

Additionally, this appear to happen ONLY with dropdowns with more than 20 options to choose.

Any ideas to what is causing this?


We are not able to open any office 2007 documents in edit mode from a share point site on MOSS2007 platform.

The client machine has Office 2007 and running IE7 version.

We are able to open after saving locally. We need a fix for the problem, as clients deny the workaround.


I need to create a process that will keep data in an Infopath 2007 form field and will also submit that data to a MOSS 2007 list. This needs to happen without the person filling out the form having to enter the data twice - which is where I am at right now:

I have the form designed and there are four fields within it that need to go to the SP list - this data also needs to stay in the form. I have created a Web Service submit (per posted examples on these forums - thanks folks) that works if I enter the data into the repeating table field for that connection.  How do I customize the submit process to grab the data from the regular form fields and submit it to the SP list? Otherwise the person filling out the data in the form twice - once in the form field, once in the web service submit field.

Warning - I am not a programmer (this assignment wasn't supposed to need it) - as there seems to be coding involved here I will either need it described as if to a kindergarden kid, or with a reference to somewhere else (maybe a tutorial) that can walk me through these steps. 




How can i hide columns and rows in SharePoint newform.aspx list based on salected item in dropdown column. Please provide example.




We use Active Directory to manage our userbase. Members in AD get placed into groups setup for Sharepoint, and these AD Groups link to Sharepoint groups, and that is how we manage our permissions (and there are no problems with this).

My issue is:

We are developing a list to manage an employee of the month, and it has cropped up recently about how do we handle staff name changes? The name can be changed in A/D, but this doesn't seem to cascade through to Sharepoint. Our link is done on staff number, so the account is the same, but a different dispaly name (that doesn't update).

Is there a command within stsadm that refreshesa the user list, or any other ideas?


When doing the export, the columns "Item Type" and "Path" are automatically displayed in the sheet.  Is there anyway to suppress these fields from exporting automatically?  I'm sure this has already been asked before, but I couldn't find anything after much searching (perhaps I'm using the wrong keywords).  Any help would be greatly appreciated.

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.

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) 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.


Hi, I would like to get/set a Microsoft Access 2007 accdb file's Summary info properities via some outside program control, like a Windows Form app.   This info must be buried in the accdb file but I am unable to find object model or code samples or docs on how to extract it.  Is this type of info accessible via XML tools?  Thanks for any pointers to this (I would think simple) problem.  Roger.

basicallly the title says it all, is there a way to get a sharepoint list's column's choices using CAML query? i'm trying to get the choices using the sharepoint web service


i had installed moss 2007 in windows server 2008 r2 with 64 bit machine.

now i wanna install sharepoint 2010. will it affect exisiting moss 2007?

please help me since sharepoint 2010 is exciting me and i wanna install it in my server.



<< Previous      Next >>

Microsoft   |   Windows   |   Visual Studio   |   Sharepoint   |   Azure