Sorting by rating

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Tagged: rating, sorting

Author

Posts
February 17, 2017 at 3:49 pm #362293

Jen Cosgrove
Expired Member

Post count: 11

Hi – I have set up GD so that when “Sort by Rating” is selected, the listings with ratings are sorted by average rating, as expected.

But I can’t figure out what order the non-rated listings are being sorted by. It is not the date they were added or any other parameter I can pinpoint. I have published and deleted a lot of ratings/reviews. Any chance some of my deleted ratings are still affecting my sort results?

The default display order for my listings page is set to Random. That is working fine. As is sorting by (number of) Reviews and A-Z.

Thank you for any help you can provide!
Jen

February 17, 2017 at 8:45 pm #362338

Paolo
Site Admin

Post count: 31206

Hi,

i asked to the developers to enlighten us. An answer will come after the week end though, they are already all off.

Thanks for your patience,

February 17, 2017 at 9:25 pm #362356

Jen Cosgrove
Expired Member

Post count: 11

Hi – Sounds good.

Thank you

Jen

February 20, 2017 at 12:49 pm #362628

Stiofan O’Connor
Site Admin

Post count: 22956

Hi Jen,

This is the order query when sorted by rating:
ORDER BY wp_geodir_gd_propertys_detail.overall_rating asc, wp_geodir_gd_propertys_detail.rating_count asc,
wp_geodir_gd_propertys_detail.is_featured asc,
wp_posts.post_date desc,
wp_posts.post_title

Thanks,

Stiofan

February 20, 2017 at 2:29 pm #362669

Jen Cosgrove
Expired Member

Post count: 11

This helps. Thank you!
Jen
Author

Posts