I have a meeting calendar that allows for agendas to be uploaded. If I add the agenda file upload to the search form, it creates a checkbox with the label 'Only with file', I assume that this should filter out any record where the agenda has not been uploaded. However it does nothing. Is there a trick to formatting this?
So I turned on debug, and I get nothing that I can interpret. Whether the checkbox is checked or not I get the same debug query:
SELECT t0.id AS pid, t0.pk AS pk,t0.pkb AS pkb, t0.cck AS cck, t0.storage_location AS loc, tt.id AS type_id, tt.alias AS type_alias
FROM `#__cck_core` AS t0
LEFT JOIN `#__content` AS t1 ON t1.id = t0.pk
LEFT JOIN `#__cck_core_types` AS tt ON tt.name = t0.cck
LEFT JOIN `#__cck_store_form_meetings` AS t2 ON t2.id = t0.pk
WHERE t1.state = 1 AND t1.access IN (1,1,5) AND
( t1.publish_up = '0000-00-00 00:00:00' OR t1.publish_up <= '2015-03-06 19:54:57' ) AND
( t1.publish_down = '0000-00-00 00:00:00' OR t1.publish_down >= '2015-03-06 19:54:57' ) AND
t0.cck = 'meetings' AND t1.catid LIKE '%26%' AND
t1.introtext REGEXP "(::meeting_year::).*2015.*(::/meeting_year::)"
GROUP BY t0.pk
ORDER BY t2.meeting_date DESC
0.014 seconds (0.014); 8.82 MB (8.816) - afterSearch [Cache=OFF] = 35 results.
0.173 seconds (0.159); 10.75 MB (1.936) - afterRender [Cache=OFF]
Running the query against mysql produces the same all rows.
Here is my search form:
The result, whether or not I check the box is the same:
I would think it would display items with the 'Minutes' files present.