Locate following code in the reportmfreeze wrote:Is there any simple way to change the SKUsearch so it will return non-pulblic products?
Code: Select all
<asp:ObjectDataSource ID="ProductDs" runat="server" DataObjectTypeName="CommerceBuilder.Products.Product"
OldValuesParameterFormatString="original_{0}" SelectMethod="AdvancedSearch" SortParameterName="sortExpression"
TypeName="CommerceBuilder.Products.ProductDataSource">
<SelectParameters>
<asp:ControlParameter Name="keyword" Type="String" ControlID="Keywords" PropertyName="Text" />
<asp:Parameter Name="categoryId" Type="Int32" DefaultValue="0" />
<asp:Parameter Name="manufacturerId" Type="Int32" DefaultValue="0" />
<asp:Parameter Name="searchName" Type="boolean" DefaultValue="True" />
<asp:Parameter Name="searchDescription" Type="boolean" DefaultValue="True" />
<asp:Parameter Name="searchSKU" Type="boolean" DefaultValue="True" />
<asp:Parameter Name="lowPrice" Type="decimal" DefaultValue="0" />
<asp:Parameter Name="highPrice" Type="decimal" DefaultValue="0" />
</SelectParameters>
</asp:ObjectDataSource>
Code: Select all
<asp:ObjectDataSource ID="ProductDs" runat="server" DataObjectTypeName="CommerceBuilder.Products.Product"
OldValuesParameterFormatString="original_{0}" SelectMethod="FindProducts" SortParameterName="sortExpression"
TypeName="CommerceBuilder.Products.ProductDataSource">
<SelectParameters>
<asp:Parameter Name="name" Type="String" DefaultValue="" />
<asp:ControlParameter Name="sku" Type="String" ControlID="Keywords" PropertyName="Text" />
<asp:Parameter Name="categoryId" Type="Int32" DefaultValue="0" />
<asp:Parameter Name="manufacturerId" Type="Int32" DefaultValue="0" />
<asp:Parameter Name="vendorId" Type="Int32" DefaultValue="0" />
</SelectParameters>
</asp:ObjectDataSource>