Vox Populi(x) forum

Alexandria Book Library => Supporto (Support) => Topic started by: lise on 23 March 2016, 09:39:57

Title: Ordering the tagslist
Post by: lise on 23 March 2016, 09:39:57
Hi,

In the tagslist i can only sort my tags based on the tag# and not on the alfabetical order.
check http://j.gebondeninleer.nl/tags.html for the only available sorting option i have, the other options give me a 500 error.

this might be attached to something in the menu structure not being completely sound... (see screenshot)

[ a slight warning: the content (if clicked deeper) of the website, could be considered as 18+. but in essence we are just a few nutcases collecting and showcasing adult books :) ]
Title: Re: Ordering the tagslist
Post by: lise on 23 March 2016, 09:42:28
i forgot to mention some details :)
the webhost is running on linux
joomla is 3.5 (was 3.4.x, but that had the same issue)

kind regards,
lise
Title: Re: Ordering the tagslist
Post by: federica on 17 April 2016, 17:54:19
Hi lisa,
which abook version are you using?
Title: Re: Ordering the tagslist
Post by: lise on 17 April 2016, 18:01:50
Abook 3.1.1 :)
Title: Re: Ordering the tagslist
Post by: lise on 17 April 2016, 18:03:43
maybe i should explain better what i want...
if you look at the attached screenshot, you will see that the order is not alfabetical.
and i would like to have it sorted a to z :)
Title: Re: Ordering the tagslist
Post by: lise on 23 April 2016, 14:34:47
It took me some time and trial and error to get what i wanted.
As you could see in the previous post, the tagslist was not sorted by alphabet..
i solved this by adding a line into the SQL that is executed.

File: com_abook/site/models/tags.php

find: line 110/111
$query->group('t.id');
                $this->_db->setQuery($query);

Change:
Add between 110 and 111:$query->ORDER('name');
$query->group('t.id');
$query->ORDER('name');
                $this->_db->setQuery($query);
Title: Re: Ordering the tagslist
Post by: federica on 27 April 2016, 09:24:49
Many thanks