Home › Forums › Product Support Forums › Ajax Search Pro for WordPress Support › No results
This topic contains 5 replies, has 2 voices, and was last updated by Ernest Marcinko 7 years, 2 months ago.
- AuthorPosts
- February 7, 2017 at 4:07 pm #11841
Hi,
How or where can I view the exact query used in a search?
I created Custom Fields, but when I search I always get No results!
Or maybe you can see from my print_r of $args why it doesn’t work (see attachment)?
Thanks,
BarbaraAttachments:
You must be logged in to view attached files.February 7, 2017 at 4:24 pm #11843You cannot access this content.February 7, 2017 at 4:48 pm #11844I only get results when I set Custom Fields connection Logic to OR.
February 9, 2017 at 12:54 am #11862Hi!
The problem is the “prijs” price field. I’ve checked one of the car pages, and that field is not numeric, therefore that filter always fails: https://i.imgur.com/l0CdOzf.png
For example: € 2.950 – MySQL cannot cast a field to numeric for BETWEEN operations if there is other than numbers and decimal points are present. In this case the correct value must be simply 2950
Best,
I recommend formatting the price in the output process, when printing the field value. It’s much better, as you will be able to do queries based on prices.
Ernest Marcinko
If you like my products, don't forget to rate them on codecanyon :)
February 9, 2017 at 11:17 am #11864Thank you, thank you, thank you! I feel so stupid right now 😛
February 9, 2017 at 8:47 pm #11868You cannot access this content. Best,
Ernest Marcinko
If you like my products, don't forget to rate them on codecanyon :)
- AuthorPosts
The topic ‘No results’ is closed to new replies.