Uploaded image for project: 'Red Hat Process Automation Manager'
  1. Red Hat Process Automation Manager
  2. RHPAM-4664

Date filter is not working as expected

    XMLWordPrintable

Details

    • 2023 Week 27-29 (from Jul 3), 2023 Week 30-32 (from Jul 24), 2023 Week 33-35 (from Aug 14), 2023 Week 24-26 (from Jun 12)

    Description

      After resolution of JBPM-10164, the code is moving forward and the sql date query is executed, but no data is returned.
      The query being executed is
      SELECT TO_CHAR(start_date, 'YYYY-MM-DD HH24:MI:SS.MS') AS "START_DATE", COUNT(processname) AS "PROCESSNAME" FROM (select * from processinstancelog) AS "dbSQL" WHERE start_date = '2022-03-04' GROUP BY "START_DATE" ORDER BY "START_DATE" ASC

      Since date filter is performes using milliseconds, not the day, the query returns no data.
      The query needs to be changed,. Either by using between or by adding date funcion (or adding extra char column with the right range, which is also wrong, because it should be day and is milliseconds)

      Attachments

        Issue Links

          Activity

            People

              david.magallanes David Gutierrez
              rhn-support-alazarot Alessandro Lazarotti
              Tomas David Tomas David
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: