12 Posts
jfquestiaux
5 years ago
2
Topic

After updating from 3.16.3 to 3.17, ordering items in a list works only for ascending order. The 3.17.1 update did not solve the issue, only reverting to 3.16.3 does.

Is there a new way to implement ordering items in a list?

Get a Book for SEBLOD
4229 Posts
Kadministrator
5 years ago
1
Level 1

What do you use to order the list and what is the output of the list debug (what query is run)?

12 Posts
jfquestiaux
5 years ago
0
Level 2

Hi.

I use an "ordering" type of field.

This is the output:

SELECT t0.id AS pid,t0.pk AS pk,t0.pkb AS pkb,t0.parent_id AS parent,t0.author_id AS author,t0.author_session AS author_session,t0.cck AS cck,t0.storage_location AS loc,tt.id AS type_id,tt.alias AS type_alias,t2.price AS price
FROM `#__cck_core` AS t0
LEFT JOIN `#__content` AS t3 ON t3.id = t0.pk
LEFT JOIN `#__j2store_products` AS t1 ON t1.product_source_id = t3.id
LEFT JOIN `#__j2store_variants` AS t2 ON t2.product_id = t1.j2store_product_id
LEFT JOIN `#__cck_core_types` AS tt ON tt.name = t0.cck
WHERE t3.access IN (1,1,3,6)
AND ( t3.publish_up = '0000-00-00 00:00:00' OR t3.publish_up <= '2019-01-16 09:23' )
AND ( t3.publish_down = '0000-00-00 00:00:00' OR t3.publish_down >= '2019-01-16 09:23' )
AND t0.cck = 'les_visites'
AND t3.state = 1
ORDER BY t3.title ASC
LIMIT 25

SELECT COUNT(t0.id)
FROM `#__cck_core` AS t0
LEFT JOIN `#__content` AS t3 ON t3.id = t0.pk
LEFT JOIN `#__j2store_products` AS t1 ON t1.product_source_id = t3.id
LEFT JOIN `#__j2store_variants` AS t2 ON t2.product_id = t1.j2store_product_id
LEFT JOIN `#__cck_core_types` AS tt ON tt.name = t0.cck
WHERE t3.access IN (1,1,3,6)
AND ( t3.publish_up = '0000-00-00 00:00:00' OR t3.publish_up <= '2019-01-16 09:23' )
AND ( t3.publish_down = '0000-00-00 00:00:00' OR t3.publish_down >= '2019-01-16 09:23' )
AND t0.cck = 'les_visites'
AND t3.state = 1

Get a VIP membership