The "out of the box" display of products in the Public View Billing module is to display the products in product code order. Whose idea was that?! It ought to be Payment Priority, then Product Title, IMO, and ideally it should be configurable. I'd like to meet the customer whose actual preference is product code order. Anyway, I haven't found a way to change that through any set up options.
So, my initial testing today says that the key stored proc is BAEImisSubscriptionsGetSubscription.
I've altered mine in a test environment and am getting things to sort "correctly", with just a simple alteration:
Original code:
SELECT * FROM Subscriptions
WHERE ID = @UserId AND PROD_TYPE = @ProductType;
My alteration:
SELECT s.* FROM Subscriptions s inner join Product p on s.PRODUCT_CODE = p.PRODUCT_CODE
WHERE s.ID = @UserId AND s.PROD_TYPE = @ProductType
ORDER by p.PAYMENT_PRIORITY, p.TITLE;
I'm hoping this is all I will need to do. I'll be testing this further to see that I haven't caused a problem somewhere else.
Comments