Search orders by BillToEmail
Posted: Fri Feb 13, 2009 6:51 pm
Hi there,
I'm trying to implement the capability on the Order Manager to search (filter) by BillToEmail. I've been able to easily add the ability to search by BillToFirstName and BillToLastName by adding these items to the KeywordSearchField:
I've noticed that these filters are added to the criteria parameter of the Search method of the ObjectDataSource. I ran SQL Profiler to determine what generated search query was being passed to the database and noticed that both BillToFirstName and LastName were appended as filters. However, BillToEmail was not.
Is there any easy way to add BillToEmail as a filter?
Thanks!
I'm trying to implement the capability on the Order Manager to search (filter) by BillToEmail. I've been able to easily add the ability to search by BillToFirstName and BillToLastName by adding these items to the KeywordSearchField:
Code: Select all
<asp:DropDownList ID="KeywordSearchField" runat="server">
<asp:ListItem Value="BillToFirstName" Text="Bill To First Name"></asp:ListItem>
<asp:ListItem Value="BillToLastName" Text="Bill To Last Name"></asp:ListItem>
<asp:ListItem Value="BillToEmail" Text="Bill To Email Address"></asp:ListItem>
<asp:ListItem Value="BillToCompany" Text="Bill To Company"></asp:ListItem>
<asp:ListItem Value="BillToAddress1" Text="Bill To Address"></asp:ListItem>
<asp:ListItem Value="ShipToFirstName" Text="Ship To First Name"></asp:ListItem>
<asp:ListItem Value="ShipToLastName" Text="Ship To Last Name"></asp:ListItem>
<asp:ListItem Value="ShipToCompany" Text="Ship To Company"></asp:ListItem>
<asp:ListItem Value="ShipToAddress1" Text="Ship To Address"></asp:ListItem>
<asp:ListItem Value="OrderNotes" Text="Order Notes"></asp:ListItem>
</asp:DropDownList>Is there any easy way to add BillToEmail as a filter?
Thanks!