chris.paschen
Chris Paschen
I've got a rather unique configuration (although I would think common for anyone pushing Fabrik just a bit).
3 Tables related to location and events at those locations (along with a contact person link to a table of people)
* locations (primary data source in the table)
* classes (join)
* courses (join)
They are joined together in the table joins area on locations.id->classes.location and classes.course->courses.id.
I've created a custom view in /com_fabrik/views/list/tmpl/bootstrap_CIYMS_classes.master (copied from the bootstrap view and modified for layout).
There is a field in the classes table "published". I need to display all the data for classes that are published.
I have a prefilter:
WHERE cmd_ciyms_classes.Published EQUALS 1 NO QUOTES Public
However, that doesn't appear to have any effect.
HOWEVER, if I add this to the pre-filter:
AND id EQUALS 26 NO QUOTES Public
(where id is from the locations table and 26 is the id of one of the locations that presently has a published class)
The display works properly (although obviously only showing the classes for location 26).
I've tried changing that to
AND id GREATER THAN OR EQUAL TO 1 NO QUOTES Public
But then it starts showing all the unpublished classes again - effectively ignoring the other pre-filter.
You can see the page here:
https://www.cmdnet.org/index.php?option=com_fabrik&view=list&listid=49&fabrikdebug=1
(this is presently using the GREATER THAN OR EQUAL TO 1 filter in addition to the 'published' filter)
I thought that maybe somehow the Fabrik List got messed up, so I created a completely new list with the same links and elements, and got almost identical results:
https://www.cmdnet.org/index.php?option=com_fabrik&view=list&listid=110&fabrikdebug=1
(although the published field is now displaying X and check instead of 0 and 1)
I temporarily added the "Available:" area just to allow easy the status of the related entries in the display.
Can you tell where this is going wrong, and why it works properly if I select a specific location, but not if I try to select multiple locations?
3 Tables related to location and events at those locations (along with a contact person link to a table of people)
* locations (primary data source in the table)
* classes (join)
* courses (join)
They are joined together in the table joins area on locations.id->classes.location and classes.course->courses.id.
I've created a custom view in /com_fabrik/views/list/tmpl/bootstrap_CIYMS_classes.master (copied from the bootstrap view and modified for layout).
There is a field in the classes table "published". I need to display all the data for classes that are published.
I have a prefilter:
WHERE cmd_ciyms_classes.Published EQUALS 1 NO QUOTES Public
However, that doesn't appear to have any effect.
HOWEVER, if I add this to the pre-filter:
AND id EQUALS 26 NO QUOTES Public
(where id is from the locations table and 26 is the id of one of the locations that presently has a published class)
The display works properly (although obviously only showing the classes for location 26).
I've tried changing that to
AND id GREATER THAN OR EQUAL TO 1 NO QUOTES Public
But then it starts showing all the unpublished classes again - effectively ignoring the other pre-filter.
You can see the page here:
https://www.cmdnet.org/index.php?option=com_fabrik&view=list&listid=49&fabrikdebug=1
(this is presently using the GREATER THAN OR EQUAL TO 1 filter in addition to the 'published' filter)
I thought that maybe somehow the Fabrik List got messed up, so I created a completely new list with the same links and elements, and got almost identical results:
https://www.cmdnet.org/index.php?option=com_fabrik&view=list&listid=110&fabrikdebug=1
(although the published field is now displaying X and check instead of 0 and 1)
I temporarily added the "Available:" area just to allow easy the status of the related entries in the display.
Can you tell where this is going wrong, and why it works properly if I select a specific location, but not if I try to select multiple locations?