OS Property support center

Sorting Conveniences

  • Nicholas Johnson
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
4 years 6 months ago #138062 by Nicholas Johnson
Sorting Conveniences was created by Nicholas Johnson
Hi

Is there a way the conveniences can be sorted alphabetically.

Thanks in advance
Mark

Please Log in or Create an account to join the conversation.

More
4 years 6 months ago #138085 by Mr. Dam
Replied by Mr. Dam on topic Sorting Conveniences
Hi Nicholas,
Currently, the conveniences are being sorted based on field: Ordering, in Amenities management page, you can drag & drop them to have the ordering you want.
Thanks
Dam

Please Log in or Create an account to join the conversation.

  • Nicholas Johnson
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
4 years 6 months ago #138088 by Nicholas Johnson
Replied by Nicholas Johnson on topic Sorting Conveniences
Hi
Thank you for getting back to me.
I have been checking the files and the code suggests the amenities are being sorted by the "amenities" column as in property.html.php as follows:

$db->setQuery("Select * from #__osrs_amenities where category_id = '".$k."' and published = '1' order by amenities");

This would be great and seems to work except the sorting seems to get lost. What I mean is it sorts some items and then theres another load of items where the sort starts again.

Please Log in or Create an account to join the conversation.

Moderators: Mr. DamNguyen Phu Quan