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


Top 5 Contributors of the Month
Lee Hnetinka
mithun
Post New Web Links

Search to lookup fields show id

Posted By:      Posted Date: October 29, 2010    Points: 0   Category :SharePoint
 

Hi all,

I have several fields in document libraries which is a lookup to another lists.

When I try to search to that fields it show the id not the title.

How can I get the title instead of item id?

 

Thank you all..


Best regards,
-- Pingkan --


View Complete Post


More Related Resource Links

Content Type or Lists Lookup Column can't show additional fields which are Choice or lookup columns

  

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 c

How can I prioritise search results to show where document metadata has a hit first and then where t

  

When my users run a search against a site with a bunch of document libraries they will often search for terms that are in the title of the doc, if they do know the title they will put that in. What I would like to do is have the results ordered such that if any hits are on the document metadata (eg Title) then they are presented first and any results that are from hits on the content of the documents are presented later.

So, if they get the title spot on in their search query that document will appear first .... if they don't get it right then the likelyhood is that the title is something like what they entered so similar titled docs are presented first and then those with matching content ....

How can I achieve this?

 


Search result show unauthorized Files Share

  

Hi All,

I configured a FileShare content source, the crawl about this source works very fine, but when a end user perform a search on it ,he can show into the search result files that are no access on the file server, but when he click on it of  course he received an access is denied.

How I can filter the search result about FileShare content source to see only files with authorized access?

Thank you for your help,

 

MIKE

 


MIKE

Is it possible to use multiple date fields to have an event show more than once on a Sharepoint 2007

  
Hello, Is it possible to use multiple sets of start and end times to have events display multiple times in a sharepoint calendar? To clarify: - I have the standard fields of "Start Time" and "End Time" in my calendar list. - Events show on the calendar just fine. - Would like to create additional fields called "Start Time 2" and "End Time 2" within the same record and have the event show multiple times on the calendar. - The recurrence functionality of sharepoint will not meet my needs because the pattern I need to use is not in one of the allowed choices. Thanks in advance, John

NewForm.aspx - Show/Hide fields dynamically

  
I have about 20 + fields in a custom list.  I want to be able to show and hide fields depending on user selection.  Does anyone know a way of accomplishing this? Ive tried some embedded javascript but can't seem to get it working in sharepoint. Please help :)http://lbellows.blogspot.com http://www.ptreviews.net

Move custom list (with lookup fields) to another Web Application

  
Is it possible to move a custom list with lookup fields to other custom lists from one web application to another? Creating list templates does not work and breaks the relationship. Thanks.   Neil

Is there a way to make SPS 2003 search fields search the MOSS indexes?

  
Here's my situation: We're doing a gradual migration from SPS to MOSS. Can anyone tell me if there's an easy way to make the SPS search fields search the MOSS indexes? The easiest way I can think of is to great a web part for SPS which will gather the scope and search param and redirect the user to the MOSS search result page. If there's an easier way. I'm all ears.

workflow lookup between 2 fields in 1 list

  
hi, how can a create a workflow lookup in 1 list between 2 fields. i wan to compare if the 2 fields are in the same row. i create a list with users name and their approvers. the approver must be the unique approver of the user in the same list. can i do this with the workflow in sharepoint designer? thnx

Why does the Search Results show the wrong Title?

  
All my documents have the Title property set, yet when I perform a search, the result result is displaying the first word it finds in the documnet as the Title? For example I have many documents all with unique Titles, yet each of the results show "PROFILE" as the Title of the document because it is the first word in the document..... PROFILE end and the middle tier of the application using C#, ASP.NET, WCF and SQL Server backend. … and facial recognition technologies using C#.NET for Microsoft .NET framework 1.1 and 2.0. … Authors: Brian Shome Date: 8/12/2010 Size: 111KB PROFILE The application was developed using ASP.NET 2.0, C#.NET and SQL Server 2005 served as the … to the end user. He used VS.NET 1.1, C#.NET 1.1 with Microsoft SQL Server 2000 and Oracle … Authors: John Doe, Jxibbons Date: 8/12/2010 Size: 117KB PROFILE The technologies used for the application are C# 2.0, ASP.Net 2.0 and SQL Server 2000. … developed this application using ASP.Net and C# and the backend comprised of both Oracle and … Authors: Paul Scot, Gen Gotti Date: 8/12/2010 Size: 110KB

supported column types that can be used as additional fields with a Lookup column?

  
Can anyone tell me which types of columns can be used as additional fields for a Lookup column? Are they the same as the column types that can be used to create Lookup columns? Choice columns are currently not available (known issue) but I think they are officially supported. What about Managed Metadata columns? Thanks

Show value from Lookup List inside a view

  
I've got a Categories list, a Product list with a Category field defined as lookup value. The Product list is used in an OrderLine List. How can i show the category value from the selected Product in the OrderLine view? I tried calculcated columns, but they don't work on lookup columns. Would this be possible by creating a custom FieldType? (without performance problems, i assume there's a reason why calculated values don't work on lookup columns) Thanks Marco

Search, My Profile fields, and NoCrawl...?

  

We've implemented User Profile Service Application and the Search Service Application. We've added custom fields to My Profile, and tested searching for them. Search doesn't seem to return any results. It doesn't report on any errors, however I've got one warning that might be related:

MySites has got NoCrawl property set to on.

Is this the cause for the Search not finding anything? Can you explain why it seems to be 'best practice' to keep NoCrawl on for the MySites application?


documents didn't show up in search results

  

Hi all,

i'm facing the following problem with a moss 2007 server:

lets say i have a document library with about 20 xlsx and xls files. All are named similiar like "YZ travelexpensereport ...".

When i search for "the exact phrase" "YZ travelexpensereport" the search results only give me one result instead of all the other files.

When i use the "all of these words"-search i still find the same file -beside some other files. But still the other 19 documents didn't show off in the search results. It's always the same file that show off.

I checked the crawl logs and all of the 20 files were crawled successfully.

Now to the funny part: when i search any of the other 19 documents with the full filename i can find it - which seems logical since it is crawled successfully.

Any ideas are appreciated !


Lookup Transformation: Fails to match in full cache mode both fields same case and collation

  

Hi All

I am at wits end trying to resolve a lookup transformation issue where lookups fail to match in full cache mode. 

Details:

1. BIDS 2008

2. Both tables are in the same db with the same collation (Latin1_General_CI_AI)

3. Both columns have the same collation (Latin1_General_CI_AI)

4. Both values are the same case

5. Both columns are varchar(9)

I'm not sure what else there is to check. I would prefer to understand what is causing the lookups to fail vs using partial cache.

Any suggestions welcome!

Thanks


SharePoint 2010 Search Service - does not escape forbidden signs in Managed Metadata fields

  

Hi,

I´m using SharePoint 2010s Search Service to get items from a list. In the list I have managed metadata field for Item. When I search on Item "Item 1 & 2" I get xml that is incorrect. SharePoint does not escape the &. (The mapping is correct so when I search on an item not containg & it returns correct xml.)

But if I in my description field writes "A description & some more text" then & is escaped.

Anyone seen this before? Is there some way to configure the search service to escape forbidden signs to return none broken xml?

Thanks!
/Maria


Hide a measure group in excel 2007 'Show Fields Related to'

  

Hi All,

I know that if a I want to hide a measure group to users I have to set the properties 'Visible' to false for all the measure of the measure group.

But when I open a connection to the cube with Excel 2007 I see again the measure group in the drop down list 'Show Fields Related to' in the 'Pivot Table Fields List'.

I don't see it in the measure group list when I choose 'All' in the 'Show Fields Related to', but i don't want to see it in the list 'Show Fields Related to' too.

 

How I can do to hide permanently the measure group?

 

Thank you all,

SimonaP


Search results doesn't show Word document Title Properties

  

The search result doesn't show the Word document's Title properties.

For example a Office 2007 Word document has Title properties as "Dell, Template (MN 520287) Test Method", the first word in the document is "Opearation".

The Search result shows the search result with the first word of the document as the search result as

Operation
The test sample plan is an general inspection for a normal inspection with a … http://mycorp.company.com/Document Library/MN-0330.00 bala (WN 11100 … Authors: James Wolf Date: 9/29/2010 Size: 169KB
http://mycorp.company.com/Document Library/MN-0330.00 bala (MN 520287) Test Method.docx

instead of

Dell, Template (MN 520287) Test Method
The test sample plan is an general inspection for a normal inspection with a … http://mycorp.company.com/Document Library/MN-0330.00 bala (WN 11100 … Authors: James Wolf Date: 9/29/2010 Size: 169KB
http://mycorp.company.com/Document Library/MN-0330.00 bala (WN 11100) Test Method.docx 


Categories: 
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