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