php-reports
php-reports copied to clipboard
ALL flag in variable header not working
-- VARIABLE: { -- name: "topic", -- type: "select", -- database_options: { -- table: "ost_help_topic", -- column: "topic_id", -- display: "topic", -- all: true -- }
builds the following query:
SELECT * FROM ost_ticket where topic_id = 'ALL' ...
so it litterally passes 'ALL' instead of omitting the condition.
Addidionally, as noted in #260 , this property cannot be turned off
This is why I do in the report: {% if facility != 'ALL' %} AND facilities.id = {{facility}} {% endif %}