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

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

Display the list column values along with the search result

Posted By:      Posted Date: September 06, 2010    Points: 0   Category :SharePoint
Hi All, i created custom Scope (to search on specific list) and i need to display all list columns on my search results.  Say i have 2 columns in the list and i have created a scope to search in only in that list. If i do a search in tat scope i would like to get the list values which fits in the search along with the columns as well. thanks jayaraja

View Complete Post

More Related Resource Links

How to filter the search result based on a column value?

I do have search scope scoped at a list which contains attachment. I will use this scope to search (full text search) on this list then I need to filter the result based on a column which is in the same list. How do I do that? Thank you.

Sharepoint list group by column data ,display in webcontrol like panel or label


I  have a sharepoint list[Managers] with groupby sector column. like below




Each Sector group by column data i want to display in label or panel control.

How to do that ? how to write the logic?



Regards, Mansoor

wss2.0 update/delete/hide lookup column that does not display any values


Hi All,

I have a document library that contains a Category column that is a lookup field. This is a default column that is a required field when uploading documents to the document library. The Category column is empty and I am unable to amend, hide, make it not required or delete it.

I have gone to Modify settings and columns -> clicked on the Category field to edit, but there is no option to amend the content or delete it. I am only able to amend the Column name and Description.

Since then, I have amended the column name to eg. Category1 and created a new Category field as a lookup and linked it to the correct list.

The problem I am facing now, is that I cannot hide, delete or make the Category1 (old Category) field NOT required. Either I would like to update the original field to display the correct values or alternately hide, delete or make the column not required.

Please help.

Best way to display data of a single column from a Sharepoint Custom List

I'm trying to create pages that will automatically populate with data pulled from a sharepoint list (like title, department, contact info, etc.).   I'm using publishing pages. What would be the easiest way to do this, and how would I specify which data to pull from the list? For example, the page would be set up like this: [Title:biology] [Department:biology] [Contact Info:biology]   and when the page loads, it would look like this: Biology Lab Biology Department 123-456-7890   I want it to just pull the data -- I don't want a list view or anything like that.  I need this page to look pretty, and I need the each column's data to show up in a very specific place. How could I make pages that would do that?

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)

Display Version History in List View Column


I am working with a multitext line for comments and I have enabled versioning.  The version history shows in each item within the View Form.  I was wondering if I can have the comments field list in the List View as a column with all the version history.  Right now, it shows as a link "View Entries...".  I would like to be able to view all versioin history in the list view under the comments column.

Is is there a feasible solution?

Thanks in advance.


How to get approver comments from OOTB workflow and display as a column in Tasks list



My problem is simple, although solution can be complex. If you know, when you start OOTB approval workflow, it creates a task item in Tasks list. An approver can click the task and open the page where he can approve/reject, also, where he can leave his comments in the "Type comments to include with your response:" textbox. These comments are included in the email which is sent after approval/rejection. Well, I looked at the columns in the Tasks list (Workflow Tasks list too) and I couldn't find any column that specifically stores these comments. I'm sure they are stored somewhere, they just can't be gone with an email.

My question is where are the comments and how to get and display them as a column in the Tasks list. I hope there is a UI way to do this. But if not, I'm ready to develop something like event handler for that.

Thank you!

Regards, R.D.M.

List view search and results - No Column view?



Recently we have moved from Portal server 2003 to Sharepoint Server 2010 and can't seem to find how to search a particular list vie(filtered view) and also how to have the search results return in column view.
Previously in Portal server 2003, our end users had the ability to do full text search in any list view. This allowed our end users to easily search a subset of a list. The returned results were also in a column view

In Sharepoint Server 2010, the list view search, searches all items in the lists(instead of the filtered list view) and also does NOT return the results in column view.

Is there anyway around this?

Michael M

How to list comma separated values in column to multiple rows




I need to list comma seperated values form one to column in multiple rows..ex:

id                           call_rec 

1                            508190,737079,1004618,1075562,1272753,1390841,1544201,2591141

 2                           335395,359380,741049,1113212,2283999,2908851,2001205615 

3                            1212358,2451853,2795175,2001196872 

4                            2283999,2451853 

I want the call_rec for each bug ID to be listed



show search result as default parameters when initiation of business data list



I want to show search result as default parameters when initiation of business data list.

Is there any solution to solve this problem. Thanks.

People search result -- how to display more fields



After user perform a people search, a list of people will be displayed with a summary, like name, title...and the picture. Is there a way that I can add more fields to this display, that is to display more information? Is this something to do with the User Properties that I set up in Central Admin. e.g moving those the properties that I want to show to the top? And I want to display a total of 9 properties for each person in the search result list. Is that possible?

Please advice. Thanks in advance.

How to retrieve list of values from an XML / Varchar(MAX) column along with main column?



I have a table with columns like ContactID, MainEmailAddress, OtherEmails  (as of type varchar(Max)). 
{At this point of project , cannot convert column to type XML}

Column OtherEmails may be either null  or may contain data in structure shown below.  

<bpDataSet xmlns="http://tempuri.org/bpDataSet.xsd">

I want to write a SQL Query to retrieve data in following manner

CotnactID  MainEmailAddress   Others
       1        main@main.com     abc@abc.com

wroking on datatable to fetch only distinct values of particular column to assign to dropdown list.


As I kept my fetched datatables into session and accessing it on another page there I am

wroking on datatable to fetch only distinct values of particular column to assign to dropdown list.

Display column from child table. Possible ?



I'am using dnamic entity with EF4. On a list page of a table, I would like to display a column containing information from a child table of the current element. Sample :

Order List :

Order Data | Required Date | Shipped Date | etc... | ... | Customer Name (foreign key with tostring() method override) | Customer Postal Code (Column that I want to add) |

I don't known how to do that. Is it possible ? Maybe I have to to create my own Metadata proxy that will add dynamicly a column on the MetaColumn list of the table.

Does someone have an easier or better idea ?

Thank you for any help.

Active Directory and .NET: paging the search result

Hi everybody!

I have a question about Active Directory in .NET
For my project I need to fetch results from Active Directory search page by page, because later I would need to bind it to the pageable DataGrid.

I tried to use .NET library DirectoryServices for that, but paging provided by this library is transparent to the user and is used only to increase the efficiency of searching, when results are too big. I.e. I cannot tell the DirectorySearcher to give me first page, then the next or previous page, it returns me all resulting pages in one bundle.

However, what I need is to explicitely get page after page directly from the AD searcher and to be able to go at least one page forward or backward.

The solution with copying all results to the DataBase and then do the paging is not accepeted by the clent, since it is too inefficient. And since it's a Web app, I cannot keep results in memory either.

I found some hints about COM Interface, but I could not find good and detailed examples or explanations. I aslo found this line of code: DirectoryServices.Interop.IDirectorySearch.ExecuteSearch(), but I don't know which libraries should i add to be able to compile this code.

If somebody could help me out with that problem, any suggestion is welcome, 'cause this issue is eating me alive :)

Thank you!

How to display a count of search results with keywords in a label?


Sorry for a basic post here; I am very new to VB!

I am currently building a search page, which includes a textbox and two drop-down lists, a search button, and a datagrid. If results are found and displayed, I would like a label to display:

(e.g.) "24 results found for 'blue sky clouds' "

...where the integer represents the results count, and the keywords and/or drop-down list selections are included in the string.

If no results are found I would like the label to display:

(e.g.) "No results were found that match your selection. Please try again"

I would also like the label to be invisible until a search occurs.

Thanks in advance!

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,




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