Support » Plugin: WP-Property - WordPress Powered Real Estate and Property Management » [Plugin: WP-Property – WordPress Powered Real Estate and Property Management] sort issue

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Andy Potanin

    (@andypotanin)

    Visit your Settings page, Developer tab, find the “Price” attribute, and check “Sortable’.

    You have to specify to WPP which attributes are sortable first, otherwise it won’t include them in the dropdown, as in your case.

    I’ve made price sortable and searchable but have a problem when I sort by price. I think it might be the way my SQL is configured because when in phpmysql admin if I:

    SELECT * FROM wp_postmeta WHERE meta_key LIKE ‘price’ ORDER BY ABS(meta_value) ASC

    it orders by a string comparison so the table will go:

    245000
    25000
    280000

    To get a sort by numeric value I need to cast the meta_value as ABS e.g.

    SELECT * FROM wp_postmeta WHERE meta_key LIKE ‘price’ ORDER BY ABS(meta_value) ASC

    oops upgrade to latest version 1.14 and this is fixed

    I am having a problem with price sort. When I select price sort, the screen updates and says 0 items found. I am going to look in the mysql and see if that helps. I will update when I know more.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘[Plugin: WP-Property – WordPress Powered Real Estate and Property Management] sort issue’ is closed to new replies.