You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I am trying to use the database options to generate a dynamic multi-select, and that is rendering correctly. But, it is not generating the expected query and results. Any ideas?
I am trying to use the database options to generate a dynamic multi-select, and that is rendering correctly. But, it is not generating the expected query and results. Any ideas?
Example header:
-- VARIABLE: {
-- name: "aldest",
-- display: "A/L Dest Airport",
-- type: "select",
-- multiple: true,
-- database_options: {table:"
Example
.active_branches", display:"id", column:"id", where:"1=1"}-- }
Macro:
[aldest] => Array
(
[0] => ABE
[1] => BUF
[2] => CLE
)
Report Options Array:
[aldest] => Array
(
[name] => aldest
[display] => A/L Dest Airport
[type] => select
[multiple] => 1
[database_options] => Array
(
[table] =>
Example
.active_branches[display] => id
[column] => id
[where] => 1=1
)
Relevant line in my query from the .sql file:
-- A/L Dest Airport Range
and aldest = '{{ aldest }}'
Relevant line from Generated Query in Debug:
-- A/L Dest Airport Range
and aldest = 'Array'
The text was updated successfully, but these errors were encountered: