14 Posts
Jack Horner
9 years ago
Topic

Hi, I've been trying to noodle this for a while.

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?

Thanks, -Jack

Get a Book for SEBLOD
9 years ago
2
Level 1

Hello Jack,

have you look at the SEBLOD debug ?

Normally, when the checkbox is checked, it's to say "Only content with file".


Best regards.

Lionel

14 Posts
Jack Horner
9 years ago
1
Level 2

Where do I find Seblod debug? I've been using developer tools and the like, but I'm not familiar with this one.

Nevermind, I just found it in Options

14 Posts
Jack Horner
9 years ago
0
Level 3

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.  

21 Posts
Mat-Su Borough
8 years ago
0
Level 1

I never was able to figure this out. Could I be missing something with live value or matching?

7 years ago
0
Level 1

Hi,

You are right.. there was an issue there. And it is now fixed.

It will be available this week in the upcoming SEBLOD 3.8.0 major release.

Thanks,
Saba.

Get a Book for SEBLOD