I have a page (one of many) that use JFilters/Yootheme/Grid Pro. On one in particular I'm having an issue I need help with.
On the page https://www.cnvc.org/events, when you select any filter condition, it goes to the filter results page which has a Grid Pro element with one content source--the jFilters results (obviously). I have a Yootheme Essentials condition to select only records whose event end date is greater than today's date. The End Date is a Joomla custom field of type calendar.
So this all works fine, but I need to change the filtering to filter on a different custom field--the event Start Date.
When I make this change, I find that if I select a filter condition with a relatively large number of records (>150), the page returns with zero records. However if I select a smaller filter item, or if I add an additional filter item to reduce the set, then records are returned and they display properly.
The attached video shows this in action.
I don't see any errors in everything.php, nor any other log. My server has 16GB of memory and plenty of processor power. And, of course, JFilters can easily handle displaying this amount of records when I use the End Date filter condition.
I can do a manual query that simulates fetching this same data, and it returns what it should, so I have no reason to think it is an issue with the article or field data. (see data below).
I've tried everything I can think of. Can you help me figure out what is going wrong?
Thanks, Jeff
On date 3 Feb 2026, using query: c.alias, f15.value AS start_date, f16.value AS end_date FROM fvdd8_content AS c LEFT JOIN fvdd8_fields_values AS f15 ON f15.item_id = c.id AND f15.field_id = 15 LEFT JOIN fvdd8_fields_values AS f16 ON f16.item_id = c.id AND f16.field_id = 16 WHERE c.catid = 14 AND c.state = 1 AND f15.value > CURDATE() - INTERVAL 1 DAY ORDER BY start_date ASC; I get (only the first 25 records displayed below) titlealiasstart_date
1end_date
Level 2: Empowerment Processes - Empowerment Thera...
level-2-empowerment-processes-empowerment-therapy-...
2026-02-04 00:00:00
2026-02-04 01:30:00
First Generation NVCers quarterly zoom gathering
first-generation-nvcers-quarterly-zoom-gathering-2...
2026-02-04 15:00:00
2026-02-04 17:00:00
Introducción a la Comunicación No Violenta
introduccion-a-la-comunicacion-no-violenta-2026-02...
2026-02-05 00:00:00
2026-02-19 01:30:00
Monthly practice group for Nonviolent communicatio...
monthly-practice-group-for-nonviolent-communicatio...
2026-02-05 00:30:00
2026-02-05 02:30:00
Level 1: Foundation - Empowerment Therapy
level-1-foundation-empowerment-therapy-2026-02-05-...
2026-02-05 14:00:00
2026-02-05 15:30:00
Free 1-hour NVC online event on Community Building
free-1-hour-nvc-online-event-on-community-building...
2026-02-05 23:00:00
2026-02-06 00:00:00
Seven Steps Toward Clarity
seven-steps-toward-clarity-2026-02-05-19-00-00
2026-02-06 05:00:00
2026-03-06 07:00:00
Nonviolent Communication Teen Parenting Group
nonviolent-communication-teen-parenting-group-2026...
2026-02-06 13:15:00
2026-02-06 14:45:00
Atelier intermédiaire en CNV : Empathie
atelier-intermediaire-en-cnv-empathie-2026-02-06-0...
2026-02-06 14:00:00
2026-02-08 22:00:00
Introduction to Nonviolent communication
introduction-to-nonviolent-communication-2026-02-0...
2026-02-06 14:30:00
2026-02-06 21:30:00
Responding to the Call of Our Times: A Leadership ...
responding-to-the-call-of-our-times-a-leadership-c...
2026-02-06 17:00:00
2026-12-11 19:00:00
Compassionate Communication (NVC) Retreat in Nanai...
compassionate-communication-nvc-retreat-in-nanaimo...
2026-02-06 23:30:00
2026-02-08 21:30:00
NVC Integration Program
nvc-integration-program-2026-02-06-18-30-00
2026-02-06 23:30:00
2027-01-09 22:30:00
Auto-empathie et responsabilité
auto-empathie-et-responsabilite-2026-02-07-09-30-0...
2026-02-07 14:30:00
2026-02-08 23:00:00
Module 1 d’introduction à la CNV sur la relation à...
module-1-dintroduction-a-la-cnv-sur-la-relation-a-...
2026-02-07 14:30:00
2026-02-08 21:30:00
Angst schuld en schaamte
angst-schuld-en-schaamte-2026-02-07-10-00-00
2026-02-07 15:00:00
2026-02-07 22:00:00
Van macht naar kracht
van-macht-naar-kracht-2026-02-07-10-00-00
2026-02-07 15:00:00
2026-02-07 22:00:00
Introduction to Nonviolent Communication
introduction-to-nonviolent-communication-2026-02-0...
2026-02-07 18:00:00
2026-02-07 20:00:00
Nonviolent Communication (NVC) for Couples
nonviolent-communication-nvc-for-couples-2026-02-0...
2026-02-08 18:30:00
2026-03-01 20:30:00
Bases de communication bienveillante basée sur la ...
bases-de-communication-bienveillante-basee-sur-la-...
2026-02-09 14:00:00
2026-02-16 22:30:00
Pratique en ligne - S'offrir de la compassion
pratique-en-ligne-soffrir-de-la-compassion-2026-02...
2026-02-09 23:30:00
2026-02-10 01:30:00
Foundations of Trust and Connection
foundations-of-trust-and-connection-2026-02-09-19-...
2026-02-10 00:00:00
2026-05-12 00:45:00
Deepening the Legacy, Supporting the Journey
deepening-the-legacy-supporting-the-journey-2026-0...
2026-02-10 14:00:00
2026-02-10 16:00:00
Laboratorio de Escucha Empática - Febrero 2026
laboratorio-de-escucha-empatica-febrero-2026-2026-...
2026-02-10 23:30:00
2026-02-11 00:45:00
Level 2: Empowerment Processes - Empowerment Thera...
level-2-empowerment-processes-empowerment-therapy-...
2026-02-11 00:00:00
2026-02-11 01:30:00
