Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-11277 Improve Task Query Performance
  3. CAM-12410

Avoid duplicate joining of ACT_RE_PROCDEF in task query

    XMLWordPrintable

Details

    • Sub-task
    • Resolution: Fixed
    • L3 - Default
    • 7.14.0, 7.14.0-alpha4
    • None
    • engine
    • None

    Description

      When a process definition filter is used and the authorization check is active, then the process definition table is joined twice. This can be consolidate into one join.

      —

      Which join type to use (left join, inner join)?

      • If cmmn and standalone tasks are disabled,
        • inner join (since every remaining task must belong to a process definition)
      • Else
        • If it is an or query
          • left join
        • If it is an and query
          • If authorization is enabled
            • left join (to not lose cmmn tasks for which we do not enforce permissions)
          • If authorization is disabled
            • inner join

      mgm-controller-panel

        This is the controller panel for Smart Panels app

        Attachments

          Activity

            People

              thorben.lindhauer Thorben Lindhauer
              thorben.lindhauer Thorben Lindhauer
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Salesforce