Sorting Orders

[heinscott]

Hello,

I have added an Item to my orders grid in admin/orders/default.aspx. This Item is a YES/NO field that runs a method to determine whether or not any of the items in that particular order is on "back-ordered" status. Now, I would like to try to (if possible) sort the grid by this new field when the header is clicked.

Is this possible?

Thanks,

Scott

[mazhar]

I don't think so. I think it would be possible in case if your database query is performing this action and you have access on that backorder field in query. Then you can pass this field name in sort expression.

[heinscott]

Thanks Mazhar, but, unfortunately the calculation to determine whether or not something should be considered "back ordered" is a little to complex to handle in SQL. I ended up playing around with setting some custom Statuses based on this before page load, and then just used the built in sort for Order Status.
Thanks for your help, though!

Scott