Adding a search parameter to WSS Contact web part

I am using WSS 3.0, and I have a site called "Contacts" that utilizes the Microsoft "Contacts Management" Server Admin Template which can be found here: http://www.microsoft.com/downloads/details.aspx?FamilyId=86EAF23E-7606-4C7A-BD45-3A9FCF861183.  On the main page web part, you can search via First Name, Last Name, or Full Name.  I want to add another search parameter, to be able to search via "Office" etc.  I have tried going through, and just adding another search parameter that mimics the others, but every time I do, it breaks my data source and returns an error.  I have attached the code form my Results.aspx page.  Can anyone help me figure out how to add another search parameter?
<%@ Page Language="C#" inherits="Microsoft.SharePoint.WebPartPages.WebPartPage, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<%@ Register tagprefix="WebPartPages" namespace="Microsoft.SharePoint.WebPartPages" assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<%@ Register tagprefix="SharePoint" namespace="Microsoft.SharePoint.WebControls" assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<html>
<head runat="server">
<META name="WebPartPageExpansion" content="full">
<meta name="ProgId" content="SharePoint.WebPartPage.Document">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title></title>
<meta name="Microsoft Theme" content="Granite 1011, default">
</head>
<body>
<form id="form1" runat="server">
	<WebPartPages:SPWebPartManager runat="server" id="WebPartManager">
	</WebPartPages:SPWebPartManager>
<WebPartPages:WebPartZone runat="server" FrameType="None" ID="Main" Title="loc:Main"><ZoneTemplate>
	<WebPartPages:DataFormWebPart runat="server" ShowWithSampleData="False" AllowRemove="True" AllowHide="True" SuppressWebPartChrome="False" Default="FALSE" PartImageLarge="" ViewContentTypeId="" ExportMode="All" Dir="Default" DisplayName="Contacts" MissingAssembly="Cannot import this Web Part." ID="g_e90bdecd_f5d4_44bf_ac06_54ea94055578" DataSourceID="" IsIncludedFilter="" DetailLink="" AllowEdit="True" UseSQLDataSourcePaging="True" HelpMode="Modeless" IsIncluded="True" Description="" NoDefaultStyle="TRUE" FrameState="Normal" AllowConnect="True" ViewFlag="0" AllowZoneChange="True" AllowMinimize="True" Title="Contacts" PartOrder="1" PageSize="-1" ListName="{AAC0072E-1C49-4D31-B784-40F86854798E}" FrameType="None" HelpLink="" PartImageSmall="" ConnectionID="00000000-0000-0000-0000-000000000000" ExportControlledProperties="True" ChromeType="None" IsVisible="True" __MarkupType="vsattributemarkup" __WebPartId="{E90BDECD-F5D4-44BF-AC06-54EA94055578}" __AllowXSLTEditing="true" WebPart="true" Height="" Width=""><ParameterBindings>
		<ParameterBinding Name="dvt_apos" Location="Postback;Connection"/>
		<ParameterBinding Name="UserID" Location="CAMLVariable" DefaultValue="CurrentUserName"/>
		<ParameterBinding Name="Today" Location="CAMLVariable" DefaultValue="CurrentDate"/>
		<ParameterBinding Name="ListID" Location="None" DefaultValue="{AAC0072E-1C49-4D31-B784-40F86854798E}"/>
		<ParameterBinding Name="SearchQS" Location="QueryString(Search)" DefaultValue="a"/>
		<ParameterBinding Name="_1" Location="QueryString(ReturnAll)" DefaultValue="<Where><Or><Or><Or><BeginsWith><FieldRef Name='Title'/><Value Type='Text'>"/>
		<ParameterBinding Name="_2" Location="QueryString(ReturnAll)" DefaultValue="</Value></BeginsWith><BeginsWith><FieldRef Name='FirstName'/><Value Type='Text'>"/>
		<ParameterBinding Name="_3" Location="QueryString(ReturnAll)" DefaultValue="</Value></BeginsWith></Or><BeginsWith><FieldRef Name='Company'/><Value Type='Text'>"/>
		<ParameterBinding Name="_4" Location="QueryString(ReturnAll)" DefaultValue="</Value></BeginsWith></Or><BeginsWith><FieldRef Name='FullName'/><Value Type='Text'>"/>
		<ParameterBinding Name="_5" Location="QueryString(ReturnAll)" DefaultValue="</Value></BeginsWith></Or></Where>"/>
	</ParameterBindings>
<DataFields>


@ID,ID;@ContentType,Content Type;@Title,Last Name;@Modified,Modified;@Created,Created;@Author,Created By;@Editor,Modified By;@_UIVersionString,Version;@Attachments,Attachments;@File_x0020_Type,File Type;@FileLeafRef,Name (for use in forms);@FileDirRef,Path;@FSObjType,Item Type;@_HasCopyDestinations,Has Copy Destinations;@_CopySource,Copy Source;@ContentTypeId,Content Type ID;@_ModerationStatus,Approval Status;@_UIVersion,UI Version;@Created_x0020_Date,Created;@FileRef,URL Path;@FirstName,First Name;@FullName,Full Name;@Email,E-mail Address;@Company,Company;@JobTitle,Job Title;@WorkPhone,Business Phone;@HomePhone,Home Phone;@CellPhone,Mobile Phone;@WorkFax,Fax Number;@WorkAddress,Address;@WorkCity,City;@WorkState,State/Province;@WorkZip,ZIP/Postal Code;@WorkCountry,Country/Region;@WebPage,Web Page;@Comments,Notes;</DataFields>
<DataSources>
<SharePoint:SPDataSource runat="server" DataSourceMode="List" SelectCommand="&lt;View&gt;&lt;Query&gt;{_1}{SearchQS}{_2}{SearchQS}{_3}{SearchQS}{_4}{SearchQS}{_5}&lt;OrderBy&gt;&lt;FieldRef Name='Title'/&gt;&lt;FieldRef Name='FirstName'/&gt;&lt;/OrderBy&gt;&lt;/Query&gt;&lt;/View&gt;" UseInternalName="True" ID="Contacts1"><SelectParameters><WebPartPages:DataFormParameter ParameterKey="ListID" PropertyName="ParameterValues" DefaultValue="{AAC0072E-1C49-4D31-B784-40F86854798E}" Name="ListID"></WebPartPages:DataFormParameter><WebPartPages:DataFormParameter ParameterKey="SearchQS" PropertyName="ParameterValues" DefaultValue="r" Name="SearchQS"></WebPartPages:DataFormParameter><WebPartPages:DataFormParameter ParameterKey="_1" PropertyName="ParameterValues" DefaultValue="&lt;Where&gt;&lt;Or&gt;&lt;Or&gt;&lt;Or&gt;&lt;BeginsWith&gt;&lt;FieldRef Name='Title'/&gt;&lt;Value Type='Text'&gt;" Name="_1"></WebPartPages:DataFormParameter><WebPartPages:DataFormParameter ParameterKey="_2" PropertyName="ParameterValues" DefaultValue="&lt;/Value&gt;&lt;/BeginsWith&gt;&lt;BeginsWith&gt;&lt;FieldRef Name='FirstName'/&gt;&lt;Value Type='Text'&gt;" Name="_2"></WebPartPages:DataFormParameter><WebPartPages:DataFormParameter ParameterKey="_3" PropertyName="ParameterValues" DefaultValue="&lt;/Value&gt;&lt;/BeginsWith&gt;&lt;/Or&gt;&lt;BeginsWith&gt;&lt;FieldRef Name='Company'/&gt;&lt;Value Type='Text'&gt;" Name="_3"></WebPartPages:DataFormParameter><WebPartPages:DataFormParameter ParameterKey="_4" PropertyName="ParameterValues" DefaultValue="&lt;/Value&gt;&lt;/BeginsWith&gt;&lt;/Or&gt;&lt;BeginsWith&gt;&lt;FieldRef Name='FullName'/&gt;&lt;Value Type='Text'&gt;" Name="_4"></WebPartPages:DataFormParameter><WebPartPages:DataFormParameter ParameterKey="_5" PropertyName="ParameterValues" DefaultValue="&lt;/Value&gt;&lt;/BeginsWith&gt;&lt;/Or&gt;&lt;/Where&gt;" Name="_5"></WebPartPages:DataFormParameter>
</SelectParameters><UpdateParameters><WebPartPages:DataFormParameter ParameterKey="ListID" PropertyName="ParameterValues" DefaultValue="{AAC0072E-1C49-4D31-B784-40F86854798E}" Name="ListID"></WebPartPages:DataFormParameter>
</UpdateParameters><InsertParameters><WebPartPages:DataFormParameter ParameterKey="ListID" PropertyName="ParameterValues" DefaultValue="{AAC0072E-1C49-4D31-B784-40F86854798E}" Name="ListID"></WebPartPages:DataFormParameter>
</InsertParameters><DeleteParameters><WebPartPages:DataFormParameter ParameterKey="ListID" PropertyName="ParameterValues" DefaultValue="{AAC0072E-1C49-4D31-B784-40F86854798E}" Name="ListID"></WebPartPages:DataFormParameter>
</DeleteParameters>
</SharePoint:SPDataSource>
</DataSources>
<Xsl>


<xsl:stylesheet xmlns:x="http://www.w3.org/2001/XMLSchema" xmlns:d="http://schemas.microsoft.com/sharepoint/dsp" version="1.0" exclude-result-prefixes="xsl msxsl ddwrt" xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" xmlns:asp="http://schemas.microsoft.com/ASPNET/20" xmlns:__designer="http://schemas.microsoft.com/WebParts/v2/DataView/designer" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:SharePoint="Microsoft.SharePoint.WebControls" xmlns:ddwrt2="urn:frontpage:internal">
	      <xsl:output method="html" indent="no"/>
	      <xsl:decimal-format NaN=""/>
				<xsl:param name="dvt_apos">'</xsl:param>
	      <xsl:param name="ListID">{AAC0072E-1C49-4D31-B784-40F86854798E}</xsl:param>
	      <xsl:param name="SearchQS" >r</xsl:param>
	      <xsl:param name="_1"></xsl:param>
	      <xsl:param name="_2"></xsl:param>
	      <xsl:param name="_3"></xsl:param>
	      <xsl:param name="_4"></xsl:param>
        <xsl:param name="_5"></xsl:param>
				<xsl:variable name="dvt_1_automode">0</xsl:variable>
				<xsl:template match="/" xmlns:x="http://www.w3.org/2001/XMLSchema" xmlns:d="http://schemas.microsoft.com/sharepoint/dsp" xmlns:asp="http://schemas.microsoft.com/ASPNET/20" xmlns:__designer="http://schemas.microsoft.com/WebParts/v2/DataView/designer" xmlns:SharePoint="Microsoft.SharePoint.WebControls">
					<xsl:call-template name="dvt_1"/>
	      </xsl:template>
				<xsl:template name="dvt_1">
					<xsl:variable name="dvt_StyleName">Table</xsl:variable>
					<xsl:variable name="Rows" select="/dsQueryResponse/Rows/Row"/>
          <xsl:variable name="dvt_RowCount" select="count($Rows)"/>
          <xsl:variable name="dvt_IsEmpty" select="$dvt_RowCount = 0"/>
          <xsl:choose>
            <xsl:when test="$dvt_IsEmpty">
              <xsl:call-template name="dvt_1.empty" />
            </xsl:when>
            <xsl:otherwise>
              <div>
			          <xsl:call-template name="dvt_1.body">
				          <xsl:with-param name="Rows" select="$Rows"/>
			          </xsl:call-template>
		          </div>
            </xsl:otherwise>
          </xsl:choose>
	</xsl:template>
	<xsl:template name="dvt_1.body">
		<xsl:param name="Rows"/>
		<xsl:for-each select="$Rows">
			<xsl:call-template name="dvt_1.rowview"/>
		</xsl:for-each>
	</xsl:template>
	<xsl:template name="dvt_1.rowview">
		<table style="float:left; width:45%; border:1px gray solid; margin:3px; padding:2px;">
			<tr>
			<td class="ms-vb" style="width: 20%;">
				<img border="0"  style="height: 70px;" src="{substring-before(@Contact_x0020_Photo, ', ')}" alt="{substring-after(@Contact_x0020_Photo, ', ')}" /></td>
				<td class="ms-vb" style="width:50%; white-space:nowrap;">
			<a href="Lists/Contacts/DispForm.aspx?ID={@ID}" target="_parent" onclick="this.href = unescapeProperly(escape(this.href)); FrameGoToLink(this); return false;" >
      <strong><xsl:value-of select="@Title"/><xsl:if test="@Title != '' and @FirstName != ''">, </xsl:if><xsl:value-of select="@FirstName"/></strong></a> <br />
			<xsl:value-of select="@JobTitle" disable-output-escaping="yes"/> <br />
			Branch/Region: <xsl:value-of select="@Branch_x002f_Region" /><br />
			<strong><xsl:value-of select="@Office" disable-output-escaping="yes"/> Office</strong>
				</td>
				<td class="ms-vb" style="white-space:nowrap;">			
      <xsl:value-of select="@Email" /><br />
      Work: <xsl:value-of select="@WorkPhone" /><br />
      Cell: <xsl:value-of select="@CellPhone" /><br />
      4-digit Ext: <strong><xsl:value-of select="@Extension" disable-output-escaping="yes"/></strong>
				</td></tr>
		</table>
	</xsl:template>

  <xsl:template name="dvt_1.empty">
    <xsl:variable name="dvt_ViewEmptyText">No records were found matching your query.</xsl:variable>
		<table border="0" width="100%">
			<tr>
				<td class="ms-vb">
			    <xsl:value-of select="$dvt_ViewEmptyText"/>
				</td>
			</tr>
		</table>
	</xsl:template>
</xsl:stylesheet></Xsl>
</WebPartPages:DataFormWebPart>

</ZoneTemplate></WebPartPages:WebPartZone>
	<SharePoint:CssLink runat="server"/>
	<SharePoint:ScriptLink language="javascript" name="core.js" Defer="true" runat="server"/>
	<script type="text/javascript">
	function FrameGoToLink(elm) {
		if (elm.href==null) return;
		var targetUrl=elm.href;
		var ch=elm.href.indexOf("?") >=0 ? "&" : "?";
		var srcUrl=ch+"Source="+window.top.location;
		var targetUrl=elm.href+srcUrl;
		window.top.location = targetUrl;
	}
	</script>
</form>
</body>
</html>

Open in new window

Jake PrattAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jake PrattAuthor Commented:
Anyone have any ideas on this?
0
zephyr_hex (Megan)DeveloperCommented:
you should be able to achieve this at the code level.  i've done something similar... however, it's not a matter of just entering in one line of code.  as i recall, i had my search field to several places.

the way i did it was to use an existing search field as an example.  find every instance of that field in the code, and decide whether or not that line of code might be related to the search... and if so, add your new parameter.

you might also need to adjust your SQL query from within the code.

an example of how i changed my SQL query:
http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/MS-SharePoint/Q_24738230.html
0
Jake PrattAuthor Commented:
Thanks for your reply.  It was nice to get a little feedback on this neglected topic.  I have tried doing exactly what you are saying, and tried duplicating and renaming some of the search query parameters.  Every time I do, it breaks the data source and produces an error.  I'm not sure if I'm just doing it wrong, or going down the wrong road entirely.

Your SQL query information doesn't really help all that much, because this page gathers its information from a SharePoint list rather than a SQL database, as you can see in the code above.
0
Jake PrattAuthor Commented:
Ok, after a lot of messing around, I was able to figure this out.  I had to make several changes of code that I had previously tried, but a few others I had not noticed before.

Where all the <ParameterBinding> tags are, you have to add a new parameter.  In this case, I added one called 4, then bumped 4 and 5 up a number to 5 and 6.

So I added this tag for the "Office" search parameter:
<ParameterBinding Name="_4" Location="QueryString(ReturnAll)" DefaultValue="</Value></BeginsWith></Or><BeginsWith><FieldRef Name='Office'/><Value Type='Text'>"/>

Then, in the data source, I had to add the "{_4}{SearchQS}" and bump up the numbers on 4 and 5 to 5 and 6.

Then, of course, in the data source, I also had to add a new parameter called 4, change its value to office, and bump up the numbers on 4 and 5.  So, basically, I added this tag:
<WebPartPages:DataFormParameter ParameterKey="_4" PropertyName="ParameterValues" DefaultValue="</Value></BeginsWith></Or><BeginsWith><FieldRef Name='Office'/><Value Type='Text'>" Name="_4"></WebPartPages:DataFormParameter>

Then, down in the xsl:stylsheet, I had to add another parameter, and increase the numbers of 4 and 5 again.  I added this line:
<xsl:param name="_4"></xsl:param>

Ok, now the part I was missing was adding an "Or" statement for the new parameter.  So, on the first parameter on line 23, I had to add an additional <Or> tag, to match up with the </Or> closing tag in my new parameter.  Then, in the data source, I had to add another "Or><" into the line.

Once I added the new parameter, and the extra "Or" statements, my new search parameter worked great.  

So, below is the code (for the relevant sections) that I had to update.

I really hope this will help someone else out, since I had such a hard time finding any articles, or getting any specific help on the problem.
<WebPartPages:WebPartZone runat="server" FrameType="None" ID="Main" Title="loc:Main"><ZoneTemplate>
	<WebPartPages:DataFormWebPart runat="server" ShowWithSampleData="true" AllowRemove="True" AllowHide="True" SuppressWebPartChrome="False" Default="FALSE" PartImageLarge="" ViewContentTypeId="" ExportMode="All" Dir="Default" DisplayName="Contacts" MissingAssembly="Cannot import this Web Part." ID="g_e90bdecd_f5d4_44bf_ac06_54ea94055578" DataSourceID="" IsIncludedFilter="" DetailLink="" AllowEdit="True" UseSQLDataSourcePaging="True" HelpMode="Modeless" IsIncluded="True" Description="" NoDefaultStyle="TRUE" FrameState="Normal" AllowConnect="True" ViewFlag="0" AllowZoneChange="True" AllowMinimize="True" Title="Contacts" PartOrder="1" PageSize="-1" ListName="{AAC0072E-1C49-4D31-B784-40F86854798E}" FrameType="None" HelpLink="" PartImageSmall="" ConnectionID="00000000-0000-0000-0000-000000000000" ExportControlledProperties="True" ChromeType="None" IsVisible="True" __MarkupType="vsattributemarkup" __WebPartId="{E90BDECD-F5D4-44BF-AC06-54EA94055578}" __AllowXSLTEditing="true" WebPart="true" Height="" Width=""><ParameterBindings>
		<ParameterBinding Name="dvt_apos" Location="Postback;Connection"/>
		<ParameterBinding Name="UserID" Location="CAMLVariable" DefaultValue="CurrentUserName"/>
		<ParameterBinding Name="Today" Location="CAMLVariable" DefaultValue="CurrentDate"/>
		<ParameterBinding Name="ListID" Location="None" DefaultValue="{AAC0072E-1C49-4D31-B784-40F86854798E}"/>
		<ParameterBinding Name="SearchQS" Location="QueryString(Search)" DefaultValue=""/>
		<ParameterBinding Name="_1" Location="QueryString(ReturnAll)" DefaultValue="<Where><Or><Or><Or><Or><BeginsWith><FieldRef Name='Title'/><Value Type='Text'>"/>
		<ParameterBinding Name="_2" Location="QueryString(ReturnAll)" DefaultValue="</Value></BeginsWith><BeginsWith><FieldRef Name='FirstName'/><Value Type='Text'>"/>
		<ParameterBinding Name="_3" Location="QueryString(ReturnAll)" DefaultValue="</Value></BeginsWith></Or><BeginsWith><FieldRef Name='Company'/><Value Type='Text'>"/>
		<ParameterBinding Name="_4" Location="QueryString(ReturnAll)" DefaultValue="</Value></BeginsWith></Or><BeginsWith><FieldRef Name='Office'/><Value Type='Text'>"/>
		<ParameterBinding Name="_5" Location="QueryString(ReturnAll)" DefaultValue="</Value></BeginsWith></Or><BeginsWith><FieldRef Name='FullName'/><Value Type='Text'>"/>
		<ParameterBinding Name="_6" Location="QueryString(ReturnAll)" DefaultValue="</Value></BeginsWith></Or></Where>"/>
	</ParameterBindings>
<DataFields>@Title,Last Name;@FirstName,First Name;@Full_x0020_Name,Full Name;@Email,E-mail Address;@Company,Company;@JobTitle,Job Title;@Branch_x002f_Region,Branch/Region;@Office,Office;@Extension,Extension;@WorkPhone,Business Phone;@HomePhone,Home Phone;@CellPhone,Mobile Phone;@WorkFax,Fax Number;@WorkAddress,Address;@WorkCity,City;@WorkState,State/Province;@WorkZip,ZIP/Postal Code;@WorkCountry,Country/Region;@WebPage,Web Page;@Comments,Contact Me About;@Contact_x0020_Photo,Contact Photo;@FullName,Full Name OLD;@Supervisor,Supervisor;@ID,ID;@ContentType,Content Type;@Modified,Modified;@Created,Created;@Author,Created By;@Editor,Modified By;@_UIVersionString,Version;@Attachments,Attachments;@File_x0020_Type,File Type;@FileLeafRef,Name (for use in forms);@FileDirRef,Path;@FSObjType,Item Type;@_HasCopyDestinations,Has Copy Destinations;@_CopySource,Copy Source;@ContentTypeId,Content Type ID;@_ModerationStatus,Approval Status;@_UIVersion,UI Version;@Created_x0020_Date,Created;@FileRef,URL Path;</DataFields>
<DataSources>
<SharePoint:SPDataSource runat="server" DataSourceMode="List" SelectCommand="&lt;View&gt;&lt;Query&gt;{_1}{SearchQS}{_2}{SearchQS}{_3}{SearchQS}{_4}{SearchQS}{_5}{SearchQS}{_6}&lt;OrderBy&gt;&lt;FieldRef Name='Title'/&gt;&lt;FieldRef Name='FirstName'/&gt;&lt;/OrderBy&gt;&lt;/Query&gt;&lt;/View&gt;" UseInternalName="True" ID="Contacts1"><SelectParameters><WebPartPages:DataFormParameter ParameterKey="ListID" PropertyName="ParameterValues" DefaultValue="{AAC0072E-1C49-4D31-B784-40F86854798E}" Name="ListID"></WebPartPages:DataFormParameter><WebPartPages:DataFormParameter ParameterKey="SearchQS" PropertyName="ParameterValues" DefaultValue="a" Name="SearchQS"></WebPartPages:DataFormParameter><WebPartPages:DataFormParameter ParameterKey="_1" PropertyName="ParameterValues" DefaultValue="&lt;Where&gt;&lt;Or&gt;&lt;Or&gt;&lt;Or&gt;&lt;Or&gt;&lt;BeginsWith&gt;&lt;FieldRef Name='Title'/&gt;&lt;Value Type='Text'&gt;" Name="_1"></WebPartPages:DataFormParameter><WebPartPages:DataFormParameter ParameterKey="_2" PropertyName="ParameterValues" DefaultValue="&lt;/Value&gt;&lt;/BeginsWith&gt;&lt;BeginsWith&gt;&lt;FieldRef Name='FirstName'/&gt;&lt;Value Type='Text'&gt;" Name="_2"></WebPartPages:DataFormParameter><WebPartPages:DataFormParameter ParameterKey="_3" PropertyName="ParameterValues" DefaultValue="&lt;/Value&gt;&lt;/BeginsWith&gt;&lt;/Or&gt;&lt;BeginsWith&gt;&lt;FieldRef Name='Company'/&gt;&lt;Value Type='Text'&gt;" Name="_3"></WebPartPages:DataFormParameter><WebPartPages:DataFormParameter ParameterKey="_4" PropertyName="ParameterValues" DefaultValue="&lt;/Value&gt;&lt;/BeginsWith&gt;&lt;/Or&gt;&lt;BeginsWith&gt;&lt;FieldRef Name='Office'/&gt;&lt;Value Type='Text'&gt;" Name="_4"></WebPartPages:DataFormParameter><WebPartPages:DataFormParameter ParameterKey="_5" PropertyName="ParameterValues" DefaultValue="&lt;/Value&gt;&lt;/BeginsWith&gt;&lt;/Or&gt;&lt;BeginsWith&gt;&lt;FieldRef Name='FullName'/&gt;&lt;Value Type='Text'&gt;" Name="_5"></WebPartPages:DataFormParameter><WebPartPages:DataFormParameter ParameterKey="_6" PropertyName="ParameterValues" DefaultValue="&lt;/Value&gt;&lt;/BeginsWith&gt;&lt;/Or&gt;&lt;/Where&gt;" Name="_6"></WebPartPages:DataFormParameter>
</SelectParameters><UpdateParameters><WebPartPages:DataFormParameter ParameterKey="ListID" PropertyName="ParameterValues" DefaultValue="{AAC0072E-1C49-4D31-B784-40F86854798E}" Name="ListID"></WebPartPages:DataFormParameter>
</UpdateParameters><InsertParameters><WebPartPages:DataFormParameter ParameterKey="ListID" PropertyName="ParameterValues" DefaultValue="{AAC0072E-1C49-4D31-B784-40F86854798E}" Name="ListID"></WebPartPages:DataFormParameter>
</InsertParameters><DeleteParameters><WebPartPages:DataFormParameter ParameterKey="ListID" PropertyName="ParameterValues" DefaultValue="{AAC0072E-1C49-4D31-B784-40F86854798E}" Name="ListID"></WebPartPages:DataFormParameter>
</DeleteParameters>  
</SharePoint:SPDataSource>
</DataSources>
<Xsl>


<xsl:stylesheet xmlns:x="http://www.w3.org/2001/XMLSchema" xmlns:d="http://schemas.microsoft.com/sharepoint/dsp" version="1.0" exclude-result-prefixes="xsl msxsl ddwrt" xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" xmlns:asp="http://schemas.microsoft.com/ASPNET/20" xmlns:__designer="http://schemas.microsoft.com/WebParts/v2/DataView/designer" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:SharePoint="Microsoft.SharePoint.WebControls" xmlns:ddwrt2="urn:frontpage:internal">
	      <xsl:output method="html" indent="no"/>
	      <xsl:decimal-format NaN=""/>
				<xsl:param name="dvt_apos">'</xsl:param>
	      <xsl:param name="ListID">{AAC0072E-1C49-4D31-B784-40F86854798E}</xsl:param>
	      <xsl:param name="SearchQS" >a</xsl:param>
	      <xsl:param name="_1"></xsl:param>
	      <xsl:param name="_2"></xsl:param>
	      <xsl:param name="_3"></xsl:param>
	      <xsl:param name="_4"></xsl:param>
	      <xsl:param name="_5"></xsl:param>
        <xsl:param name="_6"></xsl:param>

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.