In my EQM site my client uses the start/finish publish filters all the time for their regular content. I setup a new list for a gallery of images that also need to be published each month. There is an element called publish_date in the list.
I have a details layout menu item setup called 'View Current Issue' in the 'User Menu' /current-issue.html. I would like only the most recent item to show but only AFTER the publish date. I tried adding a prefilter to the list with LESS THAN NOW() NO QUOTES. This works fine for the list view but not the details link. Below is the error I am getting on the details link page.
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'eqm3_fabrik_currentissue``.``id``) FROM `eqm3_fabrik_currentissue`WHERE ( eqm3' at line 1 SQL=SELECT MAX(``eqm3_fabrik_currentissue``.``id``) FROM `eqm3_fabrik_currentissue`WHERE ( eqm3_fabrik_currentissue.publish_date < (NOW()) )
I have a details layout menu item setup called 'View Current Issue' in the 'User Menu' /current-issue.html. I would like only the most recent item to show but only AFTER the publish date. I tried adding a prefilter to the list with LESS THAN NOW() NO QUOTES. This works fine for the list view but not the details link. Below is the error I am getting on the details link page.
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'eqm3_fabrik_currentissue``.``id``) FROM `eqm3_fabrik_currentissue`WHERE ( eqm3' at line 1 SQL=SELECT MAX(``eqm3_fabrik_currentissue``.``id``) FROM `eqm3_fabrik_currentissue`WHERE ( eqm3_fabrik_currentissue.publish_date < (NOW()) )