Uploaded image for project: 'OpenIDM'
  1. OpenIDM
  2. OPENIDM-13940

Query workflow via REST with non-string parameter

    Details

      Description

      When querying against workflow/process or task instance with -
      ?_queryId=filtered-query&var-startTime=[someTimeStamp]
      it returns 0 results.
      The audit logs show that the input value is being cast as a string but the column is a dateTime type, hence the lack of results:

      2019-09-30T10:29:55.517250Z         3 Query     select RES.*
         from ACT_HI_PROCINST RES
           inner join ACT_HI_VARINST  A0 on RES.PROC_INST_ID_ = A0.PROC_INST_ID_
          WHERE  RES.END_TIME_ IS NULL
               and A0.NAME_= 'startTime'
               and A0.VAR_TYPE_ = 'string'
               and A0.TEXT_ = '2019-09-30 10:48:01.906'
          order by RES.ID_ asc LIMIT 2147483647 OFFSET 0

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                alin Alin Brici
                Reporter:
                becky.maund Becky Maund
                QA Assignee:
                Alexander Dracka
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: