Support » Plugins » [Relevanssi Premium] Custom fields in meta_query returning zero posts

  • Resolved demimontalto

    (@demimontalto)


    Hello,
    I’m currently using Relevanssi Premium for my WordPress searches but I’m experiencing some issues with custom fields, specifically ACF Repeaters (subfields).
    I’ve read that Relevanssi supports wildcards in its query but I can’t get it to work properly.

    This is my custom search page: https://pastebin.com/D5ghcgSS

    The query works like a charm until I uncomment those custom fields inside the meta query.
    Thank you for your help, this would be life saving!

    Extra question: is it possible to get all posts when ‘s’ parameter (custom fields will be in a if statement later) is empty? and again, is it possible to get posts filtered by meta query even though ‘s’ parameter is empty?

    • This topic was modified 1 month, 4 weeks ago by  demimontalto.
    • This topic was modified 1 month, 4 weeks ago by  demimontalto.
Viewing 4 replies - 1 through 4 (of 4 total)
  • UPDATE: Wildcard character results to be, in the final query, a random string between brackets for some reason so I managed to fix this using another character $ and replacing it with % in my function.php using relevanssi_where hook.

    This is the final code, if you need it, just replace your field name:

    function add_cond_to_where($where) { 
    
    	$where = str_replace("meta_key = 'repeatername_$", "meta_key LIKE 'repeatername_%", $where);
    	$where = str_replace("meta_key = 'secondrepeatername_$", "meta_key LIKE 'secondrepeatername_%", $where);
    	// ... more fields
    
    	return $where; 
    
    } add_filter('relevanssi_where', 'add_cond_to_where');
     

    This should be added to Relevanssi documentation since I didn’t find anything.

    Still need answer for my extra questions!
    As per documentation I tried this code (https://www.relevanssi.com/knowledge-base/using-relevanssi-without-a-search-term/) to fallback to WordPress search in case search term is missing but meta_query is there and it results in zero posts returned (query with search term and meta query together works)

    • This reply was modified 1 month, 4 weeks ago by  demimontalto.
    • This reply was modified 1 month, 4 weeks ago by  demimontalto.

    I’m not allowed to do Relevanssi Premium support on these forums, please drop me a support request with the Relevanssi Premium support form.

    I solved myself the issue about the premium feature, please consider adding the solution to the doc! I think it would help lots of users.
    Could you help with the other two minor issues that are non-premium feature so I don’t have to struggle with another request? Thank you

    I will mark this as solved and open a new thread for the minor issues.

Viewing 4 replies - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.