[Resolved] Number field for price on properties – Views filter not sorting properly

[Author]

Posts

[MichaelR9215]

Hello,

I am creating a property listing search, and am having trouble with the price field.

First, I set the types field to number. When I do this, it seems I can't put currency formatting directly into the field.

I tried multiple formats (as shown in screenshots attached), and nothing seems to sort correctly.

Additionally, the custom search filter only returns results when there are no special characters in the field (10000, not $10,000).

Please let me know how I can get the property prices to sort properly, and to be formatted as currency.

Thanks so much!

[MichaelR9215]

Since we are talking about numbers here, it seems that this is a bigger issue.

I have another field for Acreage, and the numbers are not sorting properly here either.

Also, when I select an option and submit the search, the property doesn't come up in the results. I think this is because of the decimal points.

When a number has decimals and/or commas, it should still sort properly, and the results should contain the correct properties.

Please advise.

Thanks!

[MichaelR9215]

Hello,

I decided to use a free form search for the price range (see attached).

I went through every property, and removed the commas and decimals.

When I search the numbers like "100000 - 750000" it shows correct results.

However, people aren't going to know that they can't use commas, and when I tried "100,000 - 750,000" the search has no results.

--------------

In addition to this issue, I still have the issue with acreage not sorting correctly.

Please advise.

[Minesh]

Hello. Thank you for contacting the Toolset support.

Well - the results you are getting is expected one since your custom field "Listing price" contains commas that means it is not a numeric value but a string value, for filter and custom field for your listing price must be setup as numeric field.

Have you changed your "Listing Price" field type to numeric or removed the comma now?

[MichaelR9215]

I switched some things up, but there is still an issue.

First, yes the field is numeric. I am no longer displaying a drop down, I am using a free form search for price.

Second, none of my entries have commas or decimals ... They are all just numbers.

The issue:

I can't control what a person types for a search...They are likely going to put commas in their price entries. When commas are used, no results are found.

hidden link

Notice price min and price max.

[Minesh]

Ok I understand what you mean.

So, the alternate way is to remove the comma from the input before we pass the value to query. You can do that using view's filter: wpv-filter_query

More info:
=> https://toolset.com/documentation/programmer-reference/views-filters/#wpv_filter_query

If you do not know how to do that, I need access details and I'm happy to fix this on your behalf. But I need one test case example with input that what values we should use as input and what should be the expected results. It will help me for testing and to share your required solution.

[Minesh]

Could you please check now.

I've added following code to your said filter.php file:

add_filter( 'wpv_filter_query', 'func_customize_view_query', 10, 3 );
function func_customize_view_query( $query_args,  $view_settings, $view_id  ) {
   
  if ($view_id==1095){
       
	
	  if(!empty($_GET)){
		  
		$min = str_replace(",","",$_GET['wpv-wpcf-property-listing-price_min']);
		$max = str_replace(",","",$_GET['wpv-wpcf-property-listing-price_max']);
	   
	    foreach((array)$query_args['meta_query'] as $k=>$v):
            if(isset($v['key']) and $v['key']=='wpcf-property-listing-price'){
				unset($query_args['meta_query'][$k]['value']);
                                       
                        $query_args['meta_query'][$k]['value'] = "$min,$max";
                              
         }
        endforeach;
	
	}
  }
   
  return $query_args;
 
}

And now I can see that search is working even when you input the comma with price_min and price_max values.

[MichaelR9215]

Minesh,

This solution works wonderfully. Thank you so much for dedicating some time to this.

Have a wonderful weekend!