I have added a custom search view that then displays the results on a new page. It can be seen here:
hidden link
The last filter is for 'Max Price' and this is set to search for values lower than or equal to the value in the custom field. This works until the value is more than 1,000,000 and I'm not sure why. So if I set to maximum 600,000 is filters out all those that are under or equal to 600,000 but not those which are over 1,000,000 is this because of the format of the numbers entered in the field? I do have £ in the field but the same issue remains whether I have that on or not.
Hello. Thank you for contacting the Toolset support.
Basically - for the comparison normally works on numerical content stored in database. Non-numerical content will be treated as text and that is why its not working as expected.
If you can share admin access details, once I will review your setup and how content stored inside the database I will be able go guide you in the right direction.
*** Please make a FULL BACKUP of your database and website.***
I would also eventually need to request temporary access (WP-Admin and FTP) to your site. Preferably to a test site where the problem has been replicated if possible in order to be of better help and check if some configurations might need to be changed.
I have set the next reply to private which means only you and I have access to it.
First thing - you will have to store the price value without the currency symbol that way we will have numeric values to filter on.
Now, I checked the view you created, I see you set your view to query both "Development" post type as well as "Availability & Search" repeating field group. That is wrong.
Please note that when you have repeating field group. It will form a one to many post relationship internally between parent post type ("Development" in your case) and child post type that is repeating field group ("Availability & Search" in your case).
You can add custom field as frontend filters to your view to that is directly belongs to your post type. I can see the price-search custom field belongs to repeating field group (which is treated as post type) "Availability & Search".
On this page: hidden link
You want to display the post belongs to post type "Developments" - right? but still you want to filter using the field "price-search" which is belongs to "Availability & Search".
As far as the price search is set up I'm not sure that is correct, whether I have the currency symbol or not in place exactly the same issue occurs. So if you select Max Price of £200,000 and search all results are filtered out, as they are lower than or equal to 200,000 as per my settings in the view, except the three values of 1,500,000 are not filtered out when they should be as they are more than 200,000 - and that is the case whether I use £1,500,000 or 1,500,000?
As far as the price search is set up I'm not sure that is correct, whether I have the currency symbol or not in place exactly the same issue occurs. So if you select Max Price of £200,000 and search all results are filtered out, as they are lower than or equal to 200,000 as per my settings in the view, except the three values of 1,500,000 are not filtered out when they should be as they are more than 200,000 - and that is the case whether I use £1,500,000 or 1,500,000?
==>
To make the filter work as expected, as shared, first change you will have to make is to remove the currency symbol from your custom field that holds the price.
Another thing that I mentioned is - you can add front-end filter for the field that belongs directly to the post type you set your view to query. I see you set your view to query "Development" post type as well as "Availability & Search" repeating field group. That is wrong. You should set your view to query singe content type that is either "Development" post type or "Availability & Search" repeating field group.
If you do so, lets say you set your view to query "Development" post type then you should not add the frontend filter of Max price for your field "price-search" as that field is belongs to "Availability & Search" repeating field group. If you set your view to query "Development" post type then you should be allowed to add frontend filters using custom fields or taxonomy belongs to your post type "Development".
I hope I made this clear now and once you decide and adjust the structure for your site then we can move ahead.
