No results

This topic contains 5 replies, has 2 voices, and was last updated by Ernest Marcinko Ernest Marcinko 7 years, 2 months ago.

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #11841
    Barbara
    Barbara
    Participant

    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,
    Barbara

    Attachments:
    You must be logged in to view attached files.
    #11843
    Barbara
    Barbara
    Participant
    You cannot access this content.
    #11844
    Barbara
    Barbara
    Participant

    I only get results when I set Custom Fields connection Logic to OR.

    #11862
    Ernest Marcinko
    Ernest Marcinko
    Keymaster

    Hi!

    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
    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.

    Best,
    Ernest Marcinko

    If you like my products, don't forget to rate them on codecanyon :)


    #11864
    Barbara
    Barbara
    Participant

    Thank you, thank you, thank you! I feel so stupid right now 😛

    #11868
    Ernest Marcinko
    Ernest Marcinko
    Keymaster
    You cannot access this content. Best,
    Ernest Marcinko

    If you like my products, don't forget to rate them on codecanyon :)


Viewing 6 posts - 1 through 6 (of 6 total)

The topic ‘No results’ is closed to new replies.