Hello, i just purchase Search Ordering add-on.. i found a problem.
if you want to create this kind of ordering:
This is where you want to order the Title based on Alphabet... with the above setting, you will likely get only sort by Title Z-A... you will miss the option Title A-Z
WHY ?
because it using the same art_title !
Solution :
At current version (at this time of writing), the field is processed on search_ordering.php in function _getChildren()
If you take a look at the query:
--------------------------------------
$query = 'SELECT a.name, a.label, a.type, a.storage_table, a.storage_field, a.storage_field2'
. ' FROM #__cck_core_fields AS a'
. ' WHERE a.name IN ('.$names.') ORDER BY FIELD(name, '.$names.')'
;
$fields = JCckDatabase::loadObjectList( $query );
----------------------------------------
when the $names are "art_created","art_title","art_title","art_hits"
this query will result only 3 item, since art_title is double