[6.0] sales analysis - can not sort group by product

[Ferdinand]

currently only the partner can be sorted

product is not sortable - neither as main group nor as subgroup of partner

IMHO this is NOT enterprise ready

see screenshot

also in
./stock/report/report_stock_view.xml: <field name="name">Last Product Inventories</field>
Products can't be sorted by name - big usability issue

BTW for inventory it is necessary to group by stock location - if not how shall someone count the real quantities which might be distributed ibn stock locations over the country....?
if the company uses lots it should be groupable by lots too.

[Ferdinand (office-chricar)]

same for accounting entry analysis - group by products gives an unsorted list

suggestion
to get sorted results I have created a funtion field which stores the product_template.name in product_product.name
(actually I used product_product.name_template but shouldn't it work out nicely if product_product.name is used?)

unsorted products are absolutely unusable in day to day business.....(sorry to be harsh ...)

[Ferdinand (office-chricar)]

i just tried this patch, but it seems not to work

[Olivier Dony (Odoo) (odo-openerp)]

Hello,

This was a tricky one, due to the way the natural order of objects are used indirectly when referenced by a m2o in reporting group-by's.

We have added the name_template field to product.product, but as a fields.related (stored) instead of a function field.
This is available as of addons revision 4036 <email address hidden>.

A server-side fix was needed as well to support multiple clauses for _order of m2o relationships. This is fixed as of server revision 3140 <email address hidden>.

Thanks for reporting and for the suggested patch (which should have worked with the server-side fix)

[Ferdinand (office-chricar)]

i am on server r 3145 and addons 4044 and can't see the announced results
do I miss something ?
To reproduce
Sales Analysis
click filter year + group by products
can not sort products

[Azazahmed Saiyed (OpenERP) (saz-openerp)]

Hello,

I have checked the issue with the addons(4054) and server(3149) with the suggested patch of DR Ferdinand. But problem still persists at my end. So I am confirming this bug again.

Thanks.

[Husen Daudi (husendaudi)]

Hello SAZ and Ferdinand,

In attached screenshot by SAZ products are in sorted order only.
I checked by clicking on product column and it is working with ascending and descending sorted orders.

[Ferdinand (office-chricar)]

not working in addons r 4067
or does it need the "code" to sort ?