Tag: page

I've added a custom attribute 'screen_size & # 39; and gave it the values ​​as a drop-down list, but when I added it as a sortable field, it does not really take the value of the attribute, but rather the id of the attribute so that the TVs are not for example sorted by the actual size of the screen but by the "id" of the size of the screen. so the results are not the ones expected, that is to say that I will have 20 ", 22", 48 ", 28", 45 ", 24" ??

The query generated by magento is: –

        SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`,
        `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL,
     LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS
     `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`,
     `price_index`.`tier_price`, `stock_status_index`.`stock_status` AS
     `is_salable`, IF(screen_size_option_value_t2.value_id IS NULL,
     screen_size_option_value_t1.option_id, screen_size_option_value_t2.option_id)
     AS `screen_size` FROM `catalog_product_entity` AS `e` INNER JOIN
     `catalog_category_product_index_store1` AS `cat_index` ON
     cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND
     cat_index.visibility IN(2, 4) AND cat_index.category_id=4 INNER JOIN
     `catalog_product_index_price` AS `price_index` ON price_index.entity_id =
     e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id
     = 0 INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON
     e.entity_id = stock_status_index.product_id INNER JOIN
     `search_tmp_5da6661def9111_62199049` AS `search_result` ON e.entity_id =
     search_result.entity_id LEFT JOIN `catalog_product_entity_int` AS
     `screen_size_t1` ON e.entity_id=screen_size_t1.entity_id AND
     screen_size_t1.attribute_id='140' AND screen_size_t1.store_id=0 LEFT JOIN
     `catalog_product_entity_int` AS `screen_size_t2` ON
     e.entity_id=screen_size_t2.entity_id AND screen_size_t2.attribute_id='140'
 AND screen_size_t2.store_id='1' LEFT JOIN `eav_attribute_option_value` 
AS `screen_size_option_value_t1` 
ON screen_size_option_value_t1.option_id=IF(screen_size_t2.value_id > 0,
 screen_size_t2.value, screen_size_t1.value) 
AND screen_size_option_value_t1.store_id=0 
LEFT JOIN `eav_attribute_option_value` AS `screen_size_option_value_t2` 
ON screen_size_option_value_t2.option_id=IF(screen_size_t2.value_id > 0,
 screen_size_t2.value, screen_size_t1.value) 
AND screen_size_option_value_t2.store_id=1 ORDER BY `screen_size` DESC,
 `e`.`entity_id` DESC LIMIT 20 

Which is ridiculous, but if I delete the join to the cached file, it returns the results, but with "id" rather than the size of the screen.

i was just wondering if it was a known bug or how i could overcome it?

Thank you in advance for your help