Difference between revisions of "How to change ordering after featured listings"

From JReviews Documentation
Jump to: navigation, search
Line 25: Line 25:
 
'''Ordering by title'''
 
'''Ordering by title'''
  
{| cellpadding="0" cellspacing="0"
+
{| class="wikitable" cellpadding="0" cellspacing="0"
 
|-
 
|-
 
| '''Joomla''' || '''WordPress'''
 
| '''Joomla''' || '''WordPress'''

Revision as of 13:32, 10 April 2016

When you set the default ordering for list pages to Featured in global configuration, the rest of the listings below featured will be ordered by submission date.

If you want to change that, edit this file:

  • /com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php

For older versions the file is:

  • /com_jreviews/jreviews/models/everywhere/everywhere_com_content.php
Be advised that a lot of effort has been put into optimizing the database queries and table indexes for faster performance. If you mix two columns from different database tables, the query can no longer be optimized because a index cannot be used.

Find the code for featured ordering:

case 'featured':
 
   // ... some other lines in between ...
 
   $order = 'Field.featured DESC, Field.contentid DESC';


And change it to one of the below, depending which ordering after featured listings you want:


Ordering by title

Joomla WordPress
$order = 'Field.featured DESC, Listing.title ASC';
$order = 'Field.featured DESC, Listing.post_title ASC';


Ordering by most viewed listings

Joomla WordPress
$order = 'Field.featured DESC, Listing.hits DESC';
$order = 'Field.featured DESC, PostView.meta_value';

Ordering by highest user rating

    $order = 'Field.featured DESC, Totals.user_rating DESC, Totals.user_rating_count DESC';


Ordering by highest editor rating

    $order = 'Field.featured DESC, Totals.editor_rating DESC, Totals.editor_rating_count DESC';


Ordering by number of reviews

    $order = 'Field.featured DESC, Totals.user_comment_count DESC';