Sort bom list on products is sorted on product ID not alpabetically

[erikvanberkum]

Bug

When sorting the bom_list on the field products alphabetically, it's sorted on the product ID number and not on ABC. The expected behavior must be sorting the product list alphabetically.

Environment

• Versions: 14.0.1 15.0.1 15.0.5 15.0.3 16.0.0 17.0.2 18.0.2 19.0.3, 20.0.3
• OS: Debian
• Web server: Apache
• PHP: 7.4
• Database: mySQL
• URL(s): /bom/bom_list.php?sortfield=t.fk_product&sortorder=asc

Expected and actual behavior

List sort on ID not on text, its expected to sort on text.

Steps to reproduce the behavior

Go to BOM list and sort on product

[erikvanberkum]

I think the issue is related due to missing Foreign Keys:
fk_product on llx_product rowid

same issue is present on MO list
Also not sorting correctly on products or third party.
Same issue here due to expected missing foreign keys on the table

[Hystepik]

Hello,
It works for me in last version of branch 14

[erikvanberkum]

@Hystepik can you check again, maybe my explanation was not clear? I installed a fresh 14.0.1 and made 4 products:

see list -> /product/list.php

A_product which has a technical database ID of 2 etc., I put them in brackets for all products.

Then when sorting the BOM list, on products, we get the following:
/bom/bom_list.php?sortfield=t.fk_product&sortorder=asc

The image shows clearly that the BOM list when sorting on products, it's sorted by product ID and not alphabetically.

Can you remove the label "Works for me / Can't reproduce" and set it to "Bug"? Or guide me what I am doing wrong.

I further have this issue on my production sever running 14.0.2 and in my development version 15 Alpha

[erikvanberkum]

This issue is still not solved

[ksar-ksar]

Hello,

Is it still a relevant issue on V18 ?

[erikvanberkum]

This issue is still relevant in version 18.0.2. Product colum is ordered by product id and not by product name.

[erikvanberkum]

@Hystepik thank you for solving this issue in the mo_list.php but the issue is not solved in bom_list.php

please reopen issue.

[erikvanberkum]

Bug not solved.

[hregis]

@erikvanberkum try with this fix : #32497