ShowResults
Basically launches the "DisplayProductsByFilter" function (below).
This method probably wouldn't need to be modified.
CheckForFilters
Method which builds the where clause.
This method looks for the checkboxes on the form, and includes the appropreate section when the checkboxes are true. To follow this model, you would have to add a checkbox for the user to "enable" that aspect of the filter, as well as a control to contain and pass the value to filter by. You would have to make sure to use the proper table alias (from the modified DisplayProductByFilter function), when referring to the Program field (which holds the pricing level values)
DisplayProductsByFilter(strWhere)
Runs a SQL Query (with the Where of the clause as a parameter) and populates the tree on the products form.
The filtering functionality does not normally consider product pricing information. You would have to include a join to the productprogram table in SalesLogix so that you can be including that tables' Program field in the query.
|