Elxis CMS Forum

Support => Technical support => Topic started by: Amigamerlin on December 30, 2011, 23:04:03

Title: Administration Area - Sort the content by ID number.
Post by: Amigamerlin on December 30, 2011, 23:04:03
Hello you all. I would like to know if there any way to can sort the content by decending id.
I noticed this function in event calendar and is really really usefull when there is a  lot of content.
Ordering the content item by descending Id I can have in the first position always the last content inserted.

Anyone of you expert can hep me? (Ioannis - Webgift - Ivan etc.)

Thank you for all the answers .

Bye
Title: Re: Administration Area - Sort the content by ID number.
Post by: Ivan Trebješanin on December 31, 2011, 01:55:56
You can change ordering of content items form backend. Where you want that ordering to be displayed? Be more specific.
Title: Re: Administration Area - Sort the content by ID number.
Post by: Amigamerlin on December 31, 2011, 02:18:32
You can change ordering of content items form backend. Where you want that ordering to be displayed? Be more specific.

Hello Ivan and thank you for your answer.

In the backend, selecting Show all content item, I can see and edit all site item. Each item has a unique Id number like 4213. What I would like to have is having the availability to order in descending way this item ID in order to have the last added item in the top of the list.

I was not able to find nothing that helped me doing this inside backend.

Ciao
Title: Re: Administration Area - Sort the content by ID number.
Post by: nikos on December 31, 2011, 08:37:11
Hello you all. I would like to know if there any way to can sort the content by decending id.
I noticed this function in event calendar and is really really usefull when there is a  lot of content.
Ordering the content item by descending Id I can have in the first position always the last content inserted.

Anyone of you expert can hep me? (Ioannis - Webgift - Ivan etc.)

Thank you for all the answers .

Bye

Hi Amigamerlin

When your aim is to have to the first position always the last content inserted, then you do not need to sort it by id because Elxis sorts content by default in this way and always shows to the top, the last created content Item. Of course the only thing you have to do when you have a lot of content items in many sections and categories, is to use the category filter which sorts all content items in the way you want.

Happy new Year
Title: Re: Administration Area - Sort the content by ID number.
Post by: Amigamerlin on December 31, 2011, 09:36:49
Hello you all. I would like to know if there any way to can sort the content by decending id.
I noticed this function in event calendar and is really really usefull when there is a  lot of content.
Ordering the content item by descending Id I can have in the first position always the last content inserted.

Anyone of you expert can hep me? (Ioannis - Webgift - Ivan etc.)

Thank you for all the answers .

Bye


Hi Amigamerlin

When your aim is to have to the first position always the last content inserted, then you do not need to sort it by id because Elxis sorts content by default in this way and always shows to the top, the last created content Item. Of course the only thing you have to do when you have a lot of content items in many sections and categories, is to use the category filter which sorts all content items in the way you want.

Happy new Year


Ciao Nikos and thank you.
yes is my case, I've a lot of sections and items.
This site is an information site that was converted from workdpress  to elxis (... I've a customer component that convert site from workdpress and joomla -all the release - to elxis) but when a new item is inserted I can't see the latest item added, I've to help me using sections.
Inside Event calendar component I noticed a litte icons beside the ID (this icons is present for all the field) that let me order the item ascending, descending and unordered..
Maybe Ionnis can add this function to our backend too  ;) :D.

Ciao

Happy new year
Title: Re: Administration Area - Sort the content by ID number.
Post by: nikos on December 31, 2011, 09:46:16
Try filter category and you will see this you need. And i tell you this by experience because i do it every day on a huge site i administrate.
Title: Re: Administration Area - Sort the content by ID number.
Post by: webgift on December 31, 2011, 11:19:39
So you would like the submitted content be displayed as latest content item first. Right ? Here is my solution which is not recommended to use for those who are not sure what they are doing.
---
File : administrator/components/com_content/admin.content.php
Line #189
Change the line :
$order = "\n ORDER BY s.title, c.catid, cc.ordering, cc.title, c.ordering";
Tothis one :
$order = "\n ORDER BY c.created DESC";

This change will affect the content items only instead of autonomous pages.
---
Happy new year ... 2012 wishes.