SharePoint Blogs: How to create a search page using SharePoint search functionality to search data in a particular list

These are the following steps i used to achieve the same in my project.

I created metadata properties in the search service application to match the fields in the discussion board list and mapped them to crawled properties. Here is a list of properties we are searching on: IssueNumber, Title, Author, SystemImpacted, Status, Priority.
---Central AdminàManage Service applicationsàSearch Service ApplicationàIn the quick launch section, Click ‘Metadata Properties’ under “Queries & Results”àClick “New Managed Property”àProvide ‘Property name’ and ‘Type’àAdd Mapping in “Mapping to Crawled Properties” sectionàSearch for the field name prefixed with “ows_” , select it and press OK.
Then I wrote a quick user control form to construct the query string based on the values for these properties entered by the user in the form. I will add the code to source control as soon as I get access to source safe. The user control itself resides here (Server_name) C:\inetpub\wwwroot\wss\VirtualDirectories\80\UserControls. I did not put it in the 14 hive because the smarts parts solution looks in this directory.

IssueTrackerListSearch.ascx.cs

using System;

using System.Collections.Generic;

using System.Text;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

namespace IssueTrackerSearch

{

public partial class IssueTrackerListSearch : System.Web.UI.UserControl

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected void btnClear_Click(object sender, EventArgs e)

{

ClearControl(this);

}

protected void btnSubmit_Click(object sender, EventArgs e)

{

Response.Redirect(CreateSearchStringQuery());

}

private string CreateSearchStringQuery()

{

StringBuilder queryString = new StringBuilder();

queryString.Append("<SiteUrl>/Search/Pages/IssueTrackerResults.aspx?k=");

if (!String.IsNullOrEmpty(txtIssueNumber.Text))

{

queryString.AppendFormat(" {0}:{1}", "IssueNumber", txtIssueNumber.Text.Trim());

}

if (!String.IsNullOrEmpty(txtIssue.Text))

{

queryString.AppendFormat(" {0}:{1}", "Title", txtIssue.Text.Trim());

}

if(!String.IsNullOrEmpty(txtSubmittedBy.Text))

{

queryString.AppendFormat("{0}:{1}","Author",txtSubmittedBy.Text.Trim());

}

if (!String.IsNullOrEmpty(txtSystemImpacted.Text))

{

queryString.AppendFormat(" {0}:{1}", "SystemImpacted", txtSystemImpacted.Text.Trim());

}

if (!String.IsNullOrEmpty(ddlStatus.SelectedValue))

{

queryString.AppendFormat(" {0}:{1}", "Status", ddlStatus.SelectedValue.Trim());

}

if (!String.IsNullOrEmpty(ddlPriority.SelectedValue))

{

queryString.AppendFormat(" {0}:{1}", "Priority", ddlPriority.SelectedValue.Trim());

}

if (!String.IsNullOrEmpty(txtCustomerName.Text))

{

queryString.AppendFormat(" {0}:{1}", "CustomerName", txtCustomerName.Text.Trim());

}

if (!String.IsNullOrEmpty(txtItemNumber.Text))

{

queryString.AppendFormat(" {0}:{1}", "ItemNumber", txtItemNumber.Text.Trim());

}

if (!String.IsNullOrEmpty(txtItemDescription.Text))

{

queryString.AppendFormat(" {0}:{1}", "ItemDescription", txtItemDescription.Text.Trim());

}

if (!String.IsNullOrEmpty(txtOrderNumber.Text))

{

queryString.AppendFormat(" {0}:{1}", "OrderNumber", txtOrderNumber.Text.Trim());

}

if (!String.IsNullOrEmpty(ddlBusinessSegment.SelectedValue))

{

queryString.AppendFormat(" {0}:{1}", "BusinessSegment", ddlBusinessSegment.SelectedValue.Trim());

}

return queryString.ToString();

}

private void ClearControl(Control control)

{

TextBox textbox = control as TextBox;

if (textbox != null)

textbox.Text = string.Empty;

DropDownList dropDownList = control as DropDownList;

if (dropDownList != null)

dropDownList.SelectedIndex = 0;

foreach (Control childControl in control.Controls)

{

ClearControl(childControl);

}

IssueTrackerListSearch.ascx

<%@ Control Language="C#" AutoEventWireup="true"

CodeFile="IssueTrackerListSearch.ascx.cs"

Inherits="IssueTrackerSearch.IssueTrackerListSearch" %>

.style1

{

height: 26px;

}

.style2

{

height: 30px;

}

</style>

<h3>Search issues based on the following criteria:</h3>

<table>

<tbody>

<tr>

<td colspan="3"><strong>Business Issue</strong></td>

<td>

</td>

<strong>Customer Issue</strong></td>

</tr>

<tr>

<td>Issue Number</td>

<td>

<asp:TextBox ID="txtIssueNumber" runat="server" Width="250px" Wrap="False"></asp:TextBox>

</td>

<td>

 </td>

<td>

Customer Name</td>

<td>

 </td>

<td>

<asp:TextBox ID="txtCustomerName" runat="server" Width="250px"></asp:TextBox>

</td>

</tr>

<tr>

<td>Issue</td>

<td>

<asp:TextBox ID="txtIssue" runat="server" Width="250px" Wrap="False"></asp:TextBox>

</td>

<td>

 </td>

Item Number</td>

<td>

 </td>

<td>

<asp:TextBox ID="txtItemNumber" runat="server" Width="250px"></asp:TextBox>

</td>

</tr>

<tr>

<td>Submitted by</td>

<td>

<asp:TextBox ID="txtSubmittedBy" runat="server" Width="250px" Wrap="False"></asp:TextBox>

</td>

<td>

 </td>

Item Description</td>

<td>

 </td>

<td>

<asp:TextBox ID="txtItemDescription" runat="server" Width="250px"></asp:TextBox>

</td>

</tr>

<tr>

<td class="style1">System Impacted</td>

<asp:TextBox ID="txtSystemImpacted" runat="server" Width="250px" Wrap="False"></asp:TextBox>

</td>

</td>

<td>

Order Number</td>

</td>

<asp:TextBox ID="txtOrderNumber" runat="server" Width="250px"></asp:TextBox>

</td>

</tr>

<tr>

<td>Status</td>

<td>

<asp:DropDownList ID="ddlStatus" runat="server" Width="253px" Height="22px">

<asp:ListItem></asp:ListItem>

<asp:ListItem>Submitted</asp:ListItem>

<asp:ListItem>Open</asp:ListItem>

<asp:ListItem>Close</asp:ListItem>

<asp:ListItem>Reassign</asp:ListItem>

</asp:DropDownList>

</td>

<td>

 </td>

<td>Business Segment</td>

<td>

 </td>

<td>

<asp:DropDownList ID="ddlBusinessSegment" runat="server" Width="253px" Height="22px">

<asp:ListItem></asp:ListItem>

<asp:ListItem>Dated</asp:ListItem>

<asp:ListItem>Office</asp:ListItem>

<asp:ListItem>School</asp:ListItem>

<asp:ListItem>Multiple</asp:ListItem>

</asp:DropDownList>

</td>

</tr>

<tr>

<td>Priority</td>

<td>

<asp:DropDownList ID="ddlPriority" runat="server" Width="253px" Height="22px">

<asp:ListItem></asp:ListItem>

<asp:ListItem>Low</asp:ListItem>

<asp:ListItem>Medium</asp:ListItem>

<asp:ListItem>High</asp:ListItem>

<asp:ListItem>Urgent</asp:ListItem>

</asp:DropDownList>

</td>

<td>

 </td>

<td>

 </td>

<td>

 </td>

</tr>

<tr><td class="style2"><asp:Button ID="btnSubmit" runat="server" Text="Submit"

onclick="btnSubmit_Click" /></td>

<td class="style2"><asp:Button ID="btnClear" runat="server" Text="Clear"

onclick="btnClear_Click" /></td>

</tr>

</tbody>

</table>

3. I attempted to create a user control host web part but was experiencing .Net version issues, so I decided to use SmartPart for SharePoint 2010 CodePlex solution to host the user control. This was much faster and worked great.

Click "open the tool pane". Then select your SmartPart. In this case its "usercontrols_issuetrackerlistssearch.ascx"

Then Check-in and Publish your page.

4. I created a search results page and filtered the core results web part to only show results from the issue list. Configured the search box on the results page to go against the issue list as well.

a) Create a FAST Search center site in the top level site.