Filtered results are not showing
💡 New on Gravity Guide: an Advanced Filter extension course with step-by-step instructions and videos. Check it out ➡
If your View that uses Advanced Filter is not returning any results, it could be due to a number of reasons:
- Incorrect filter conditions.
- Failed database query.
- Interference by other plugins.
Make sure that you properly specify filter values and group them using the appropriate
When you have multiple filter conditions and a large number of entries, the database may reject the query if the number of potential records being examined exceeds the value configured in database settings. One of these settings is
max_join_size that prevents long queries from being run in order to preserve server resources. The best way to find out if the issue is due to database query is to install the Query Monitor plugin and review its output on the View page. You will see all queries made when loading the page along with any errors reported by the database.
Advanced Filter hooks to Gravity Forms’ GF_Query class by adding additional
join clauses. When other plugins also modify the database query performed by
GF_Query, that may lead to unexpected results. Again, you can use the Query Monitor plugin to review the query being performed to confirm the presence of extra clauses (e.g.,
WHERE foo = "bar") that should not be there. To find the culprit, you can use the elimination method by disabling one plugin at a time and refreshing the page, then contacting the culprit plugin's author to inquire about a potential solution.
Once you have established that none of these 3 reasons apply to you, please contact our support for further troubleshooting.