Sortorder in options_values_manager.php

[mhu100]

Is there a way to sort the data in options_values_manager.php by Attributname? At this point it looks like there is no sortorder at all.
When I have to change a value it's hard to find the Attributname I need. There is also no search-option to find a Attributename.

What I want is to sort the data by Attributename.

Thanks in advance.

[Ajeh]

They are grouped but the Option Name and then sorted on the Sort Order ...

If you look around line 641 in the options_values_managers.php you will find the SELECT statement:

    $values = "select pov.products_options_values_id, pov.products_options_values_name, pov2po.products_options_id, pov.products_options_values_sort_order from " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov left join " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " pov2po on pov.products_options_values_id = pov2po.products_options_values_id     left join " . TABLE_PRODUCTS_OPTIONS . " po on pov2po.products_options_id = po.products_options_id where pov.language_id = '" . (int)$_SESSION['languages_id'] . "' and po.language_id = pov.language_id and pov2po.products_options_values_id !='" . PRODUCTS_OPTIONS_VALUES_TEXT_ID . "' order by  po.products_options_name, LPAD(pov.products_options_values_sort_order,11,'0'), pov.products_options_values_name"; 

[mhu100]

They are grouped but the Option Name and then sorted on the Sort Order ...

If you look around line 641 in the options_values_managers.php you will find the SELECT statement:

    $values = "select pov.products_options_values_id, pov.products_options_values_name, pov2po.products_options_id, pov.products_options_values_sort_order from " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov left join " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " pov2po on pov.products_options_values_id = pov2po.products_options_values_id     left join " . TABLE_PRODUCTS_OPTIONS . " po on pov2po.products_options_id = po.products_options_id where pov.language_id = '" . (int)$_SESSION['languages_id'] . "' and po.language_id = pov.language_id and pov2po.products_options_values_id !='" . PRODUCTS_OPTIONS_VALUES_TEXT_ID . "' order by  po.products_options_name, LPAD(pov.products_options_values_sort_order,11,'0'), pov.products_options_values_name"; 

Thanks for your answer, but what do I need to change? I want the tabel to sort just by Attributename.

[Ajeh]

You can rearrange the order by and put the three in the order you want them ...

currently it reads as ...
Option Name - po.products_options_name
Option Value Sort Order - LPAD(pov.products_options_values_sort_order,11,'0')
Option Value Name - pov.products_options_values_name

"' order by  po.products_options_name, LPAD(pov.products_options_values_sort_order,11,'0'), pov.products_options_values_name"

You can change those to a different order to alter the display ...

However, as most assign a Sort Order to the Options Values, it is really handy to see them in that order to know how you have them sorted by default ...