Search orders by BillToEmail

[500lbdev]

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:

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>

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!

[mazhar]

There is no stragiht method to add BillToEmail filter. One possiable workaround could be to add bill to Email as an order note for each order and then use order notes filter and search the BillToEmail.

http://wiki.ablecommerce.com/index.php/ ... yword_part

[triplw]

One possiable workaround could be to add bill to Email as an order note for each order and then use order notes filter and search the BillToEmail.

Mazhar,
I would like to do this so I can search orders by BillToEmail. Could you tell me how to add the BillToEmail to the order notes?

Thanks