Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-12043

As a cockpit user, I want to filter process instances with multiple values for one search parameter

    XMLWordPrintable

Details

    • Feature Request
    • Status: Closed
    • L3 - Default
    • Resolution: Fixed
    • None
    • 7.17.0, 7.17.0-alpha2, 7.16.3
    • None
    • None

    Description

      User Story (Required on creation):

      As a cockpit user, I want to filter process instances with multiple values for certain filters such as process variables, business key, or process instance id. As an operator, this helps me get a single view on all instances that share a common trait (e.g., are in an error state, belong to a certain customer, ...).

      Functional Requirements (Required before implementation):

      • On the process dashboard (https://docs.camunda.org/manual/7.16/webapps/cockpit/bpmn/dashboard/#deployed-processes) I can add search parameters with multiple values so that they have IN semantics (i.e., a process instance is in the result if one of the values is matched)
      • The IN operator is available for the following parameters:
        • Variable value
        • Business Key
        • Process Instance ID
        • Process Definition Key
      • The search works the same on the batch operation page. Especially, when clicking Execute Batch on the process dashboard, the search criteria should be applied just as they were.

      Technical Requirements (Required before implementation):

      Backend

      • Filter criterion processInstanceBusinessKeyIn is exposed in HistoricProcessInstanceQuery
      • SQL complexity of variable value criteria is improved by ...
        • performing a LEFT JOIN only for distinct variable names
        • removing condition duplicates

      Limitations of Scope (Optional):

      • Exposing the API's OR queries in Cockpit is not in the scope of this ticket (see hints)

      Hints (optional):

      • Exposing OR queries similar to the task filtering view in Tasklist (toggling search from matching ALL to matching ANY criteria) is not sufficient to solve this ticket. It is important that users can express a query like unfinished = true AND (variable value = foo OR variable value = bar)

      mgm-controller-panel

        This is the controller panel for Smart Panels app

        Attachments

          Issue Links

            Activity

              People

                hariharan.parasuraman Hariharan Parasuraman
                andre.bappert Andre
                Tassilo Weidner Tassilo Weidner
                Hariharan Parasuraman Hariharan Parasuraman
                Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  Salesforce