Uploaded image for project: 'Pentaho Reporting and Pentaho Report Designer'
  1. Pentaho Reporting and Pentaho Report Designer
  2. PRD-2422

When editing query with a parameter that is a date in the MQL Editor, the editor updates the a parameter, {date_parameter} to DATEVALUE([date_parameter]) and the default value can't be set.

    XMLWordPrintable

    Details

    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      Create a MQL Query in the MQL Editor that contain a date field.
      Add constraint to the date field and parameterize it, type in

      {start_date} and a default value of 2005-01-01.
      Hit Ok.
      Now... edit the query... notice that the {start_date}

      is now DATEVALUE([start_date]) and no ability to change the default value.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              gdavid Golda Thomas
              Reporter:
              kcruzada Kurtis Cruzada
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: