Report.xml: use constant value instead of variable in select statement

XMLWordPrintable

    • Type: Bug Report
    • Resolution: Fixed
    • Priority: L3 - Default
    • 7.5.0, 7.5.0-alpha1
    • Affects Version/s: None
    • Component/s: engine
    • None

      Follow up to CAM-5158.

      The new statement in Report.xml introduced with CAM-5158 contains a placeholder/variable in the select list as a column for the result set.
      IBM Informix does not like it and gives sends a "Syntax error".
      I found a working solution (checked against H2 and Informix) to replace the variable with a constant text based on the report type without doubling the statement.

      Using directly the include "periodUnitFunction" with apostrophes around it (' ') did not work, because it also puts additional wide spaces between the apostrophes.

        This is the controller panel for Smart Panels app

              Assignee:
              Roman Smirnov
              Reporter:
              Frank Langelage
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: