Low Search Returning No Results
I'm running ExpressionEngine 2.6.1 and Low Search 4.4.2 on a client's site. Everything seems to be set-up properly, but the search doesn't return any results. There are known results for the terms I've been testing against.
I've ran the searches directly against the MySQL ex_low_search_index table and the data is there. So the index is fine. Based on turning 'view queries' on, I can see that it looks like results are being found (see below)
SELECT t.entry_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1454970109 AND (t.expiration_date = 0 OR t.expiration_date > 1454970109) AND t.entry_id IN ('52068','51466','53044') AND t.status = 'open' ORDER BY FIELD(t.entry_id, 52068,51466,53044) LIMIT 0, 10
But in the display results, it always says, no results found, blah, blah, blah.
Replies
Low 9 Feb 2016 14:55
If you turn on Template Debugging, you should be able to pinpoint where/when it returns no results.
Most of the times, this happens after LS passes on its found entries to the native channel:entries tag, due to other native filtering like status, future/expired entry dates.
Does that help you?
nonprofit_tech 22 Feb 2016 18:24
Hi Low- Yes, that's where discovered the issue. How can I test? Can I ask search results to return all statuses or to just *not returned* 'closed'. This is an area, where we are using statuses differently, to document where in the legal process a case is. I believe only the 'Closed' status is being used as expected by EE.
Low 23 Feb 2016 07:38
You can try and add status="not closed" to the Results tag, just like you would with the channel:entries tag.