- Posts: 15
COMMUNITY FORUM
Secondary sorting of K2 items
- Ilya Kushliansky
-
Topic Author
- Offline
- New Member
Less
More
9 years 9 months ago #146046
by Ilya Kushliansky
Secondary sorting of K2 items was created by Ilya Kushliansky
I am trying to find a way to sort items by title AFTER they are sorted by FEATURED. In my k2 category, the soring is FEATURED FIRST. But other (non featured) items don't display by title after the featured ones.
Where can I set secondary (tertiary) sorting of K2 items?
Where can I set secondary (tertiary) sorting of K2 items?
Please Log in or Create an account to join the conversation.
- Krikor Boghossian
-
- Offline
- Platinum Member
Less
More
- Posts: 15920
9 years 9 months ago #146108
by Krikor Boghossian
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by Krikor Boghossian on topic Secondary sorting of K2 items
By default this is not possible.
You can however 'hack' the itemlist model and add a secondary ORDER BY option ( stackoverflow.com/questions/10212430/mysql-double-sort ). Just be extra careful and backup before editing the file.
You can however 'hack' the itemlist model and add a secondary ORDER BY option ( stackoverflow.com/questions/10212430/mysql-double-sort ). Just be extra careful and backup before editing the file.
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.
- Ilya Kushliansky
-
Topic Author
- Offline
- New Member
Less
More
- Posts: 15
9 years 8 months ago #146333
by Ilya Kushliansky
Replied by Ilya Kushliansky on topic Secondary sorting of K2 items
ok, could you tell me what secondary sorting criteria does joomla apply when the category is set to Featured First? It seems that Joomla looks at the subcategory sorting (hotels has subcategories 5-star hotels, then 4-star hotels etc...). But what if both 5-star hotels are featured? Will Joomla then look at their name and sort alphabetically?
Please Log in or Create an account to join the conversation.
- Krikor Boghossian
-
- Offline
- Platinum Member
Less
More
- Posts: 15920
9 years 8 months ago #146445
by Krikor Boghossian
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by Krikor Boghossian on topic Secondary sorting of K2 items
It would sort them by ID, this means in general that the newest item will appear first.
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.
- Emmanouil
-
- Offline
- Senior Member
Less
More
- Posts: 58
9 years 2 months ago #151474
by Emmanouil
Hi krikor,
is it possible to change this behavior? So it will sort them alphabetical insteed of ID.
This would be a nice solution for displaying featured items first and all the rest alphabetical.
Thanks!
Replied by Emmanouil on topic Secondary sorting of K2 items
Krikor wrote: It would sort them by ID, this means in general that the newest item will appear first.
Hi krikor,
is it possible to change this behavior? So it will sort them alphabetical insteed of ID.
This would be a nice solution for displaying featured items first and all the rest alphabetical.
Thanks!
Please Log in or Create an account to join the conversation.