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.

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

              Created:
              Updated:
              Resolved: