Sort properties by number of bedrooms by default

Hi

Can you give me some instructions which file I should edit to sort all property lists by the number of bedrooms (most first).

I have seen sorting/ordering information on this page but the options don't appear to be on the control panel...

Many Thanks
Tim Baker

Sorry I know this post should be in OS Property instead of Pre-Sales Questions, but not sure how to change it now I have saved it!

Hi Tim,
You want to sort properties in the list of properties page by bedroom? Can you send me the url so i can check and let you know where can you make the modification.
Thanks
Dam

Hi Dam

One of the pages is www.metrostudentaccommodation.co.uk/university-locations/bath all the other pages are the same type.

Thank you so much
Tim Baker

Hi

If that page doesn't give you the info you need please let me know and I will try and find it.

Many thanks
Tim Baker

Hi Tim,
To order properties by bedrooms, please follow these steps.
1. Open file
components > com_osproperty > classes > listing.php
2. find
$query .= " ORDER BY a.isFeatured desc, $orderby $ordertype";
and replace it by
$query .= " ORDER BY a.bed_room "; //if you want to sort properties by bed room field from small -> high
or
$query .= " ORDER BY a.bed_room desc"; //if you want to sort properties by bed room field from high-> small
Thanks
Dam

Hi Dang

Sorry to hijack a thread but I want to do almost the same as this but instead of order by number of bedrooms I want to order by 'Region'
Could you tell me how to change the code to achieve this?

I'm using the latest 2.6 version. Many Thanks

Hi Richard,
You mean the State/ Province or Region field of properties?
Thanks
Dam

Hi Dang

The 'Region' field if its possible?

Thanks

Hi there
Sorry to bother you, just wondering if you've had any time to sort my code so that I can sort by 'Region'?

Many thanks

Hi,
In database table : #__osrs_properties. There is the column: region. So you can change
$query .= " ORDER BY a.bed_room "; //if you want to sort properties by bed room field from small -> high
or
$query .= " ORDER BY a.bed_room desc"; //if you want to sort properties by bed room field from high-> small
by
$query .= " ORDER BY a.region "; //if you want region are sorted by aphabetic
or
$query .= " ORDER BY a.region desc";

Good luck
Dam
Thanks
Dam