Hello,
Thanks, i've placed your code on 'Page_Load" event of list page and it works:
$this->setSessionOrderByList("EV__id_product
ASC");
If i place the code on page render, i must refresh (F5) the page after load to see the order works.
The field 'id_product' (inventory table) is looked up to field 'id' of table 'products' in edit tag.
Allow sort / search is enabled.
In tables list, the sort field for the table 'Inventory' is 'id_product' ASC
Please see the Mysql Debug below.
Thanks,
Enrique
0.967494: (mysqli): SET NAMES 'utf8'. Error: (0)
1.159961: (mysqli): SELECT COUNT(*) FROM products
ORDER BY product
ASC. Error: (0)
1.367336: (mysqli): SELECT COUNT(*) FROM inventory
. Error: (0)
1.552883: (mysqli): SELECT * FROM inventory
ORDER BY quantity_downey
ASC LIMIT 0, 20. Error: (0)
1.745743: (mysqli): SELECT id
AS lf
, product
AS df
, '' AS df2
, '' AS df3
, '' AS df4
FROM products
WHERE id
= 49 ORDER BY product
ASC. Error: (0)
1.930284: (mysqli): SELECT id
AS lf
, product
AS df
, '' AS df2
, '' AS df3
, '' AS df4
FROM products
WHERE id
= 295 ORDER BY product
ASC. Error: (0)
2.116236: (mysqli): SELECT id
AS lf
, product
AS df
, '' AS df2
, '' AS df3
, '' AS df4
FROM products
WHERE id
= 293 ORDER BY product
ASC. Error: (0)
2.299793: (mysqli): SELECT id
AS lf
, product
AS df
, '' AS df2
, '' AS df3
, '' AS df4
FROM products
WHERE id
= 292 ORDER BY product
ASC. Error: (0)
2.485180: (mysqli): SELECT id
AS lf
, product
AS df
, '' AS df2
, '' AS df3
, '' AS df4
FROM products
WHERE id
= 286 ORDER BY product
ASC. Error: (0)
2.669993: (mysqli): SELECT id
AS lf
, product
AS df
, '' AS df2
, '' AS df3
, '' AS df4
FROM products
WHERE id
= 37 ORDER BY product
ASC. Error: (0)
2.854577: (mysqli): SELECT id
AS lf
, product
AS df
, '' AS df2
, '' AS df3
, '' AS df4
FROM products
WHERE id
= 35 ORDER BY product
ASC. Error: (0)
3.039051: (mysqli): SELECT id
AS lf
, product
AS df
, '' AS df2
, '' AS df3
, '' AS df4
FROM products
WHERE id
= 72 ORDER BY product
ASC. Error: (0)
3.223175: (mysqli): SELECT id
AS lf
, product
AS df
, '' AS df2
, '' AS df3
, '' AS df4
FROM products
WHERE id
= 46 ORDER BY product
ASC. Error: (0)
3.414119: (mysqli): SELECT id
AS lf
, product
AS df
, '' AS df2
, '' AS df3
, '' AS df4
FROM products
WHERE id
= 73 ORDER BY product
ASC. Error: (0)
3.600094: (mysqli): SELECT id
AS lf
, product
AS df
, '' AS df2
, '' AS df3
, '' AS df4
FROM products
WHERE id
= 294 ORDER BY product
ASC. Error: (0)
3.786520: (mysqli): SELECT id
AS lf
, product
AS df
, '' AS df2
, '' AS df3
, '' AS df4
FROM products
WHERE id
= 34 ORDER BY product
ASC. Error: (0)
3.971751: (mysqli): SELECT id
AS lf
, product
AS df
, '' AS df2
, '' AS df3
, '' AS df4
FROM products
WHERE id
= 47 ORDER BY product
ASC. Error: (0)
4.155434: (mysqli): SELECT id
AS lf
, product
AS df
, '' AS df2
, '' AS df3
, '' AS df4
FROM products
WHERE id
= 45 ORDER BY product
ASC. Error: (0)
4.346919: (mysqli): SELECT id
AS lf
, product
AS df
, '' AS df2
, '' AS df3
, '' AS df4
FROM products
WHERE id
= 48 ORDER BY product
ASC. Error: (0)
4.535632: (mysqli): SELECT id
AS lf
, product
AS df
, '' AS df2
, '' AS df3
, '' AS df4
FROM products
WHERE id
= 36 ORDER BY product
ASC. Error: (0)
4.735929: (mysqli): SELECT id
AS lf
, product
AS df
, '' AS df2
, '' AS df3
, '' AS df4
FROM products
WHERE id
= 71 ORDER BY product
ASC. Error: (0)
4.921047: (mysqli): SELECT id
AS lf
, product
AS df
, '' AS df2
, '' AS df3
, '' AS df4
FROM products
WHERE id
= 41 ORDER BY product
ASC. Error: (0)
5.104573: (mysqli): SELECT id
AS lf
, product
AS df
, '' AS df2
, '' AS df3
, '' AS df4
FROM products
WHERE id
= 289 ORDER BY product
ASC. Error: (0)
5.288761: (mysqli): SELECT id
AS lf
, product
AS df
, '' AS df2
, '' AS df3
, '' AS df4
FROM products
WHERE id
= 285 ORDER BY product
ASC. Error: (0)