I have an ACF relationship field which i need to be included in the search and i came across this article https://www.relevanssi.com/knowledge-base/indexing-acf-relationship-content/ which i have implemented. if i var_dump and die the function the correct words are outputted but when searching it doesn’t seem to pick up the correct results.
string(491) "SELECT DISTINCT(relevanssi.doc), relevanssi.*, relevanssi.title * 5 +
relevanssi.content * 1 + relevanssi.comment * 0.75 +
relevanssi.tag * 0.75 + relevanssi.link * 0 +
relevanssi.author + relevanssi.category * 0.75 + relevanssi.excerpt +
relevanssi.taxonomy + relevanssi.customfield + relevanssi.mysqlcolumn AS tf
FROM wp_relevanssi AS relevanssi WHERE (relevanssi.term LIKE 'jaywing%' OR relevanssi.term_reverse LIKE CONCAT(REVERSE('jaywing'), '%')) ORDER BY tf DESC LIMIT 500"
And relevanssi_results doesn’t include the ID of the post i am looking for even though the search term is the exact name of what is selected in the field, indexing of ACF fields is enabled and i have also rebuilt the index and cleared all caching
This reply was modified 2 years, 2 months ago by nathanillustrate.