Avoid duplicate joining of ACT_RE_PROCDEF in task query

XMLWordPrintable

    • Type: Sub-task
    • Resolution: Fixed
    • Priority: L3 - Default
    • 7.14.0, 7.14.0-alpha4
    • Affects Version/s: None
    • Component/s: engine
    • None

      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

        This is the controller panel for Smart Panels app

              Assignee:
              Thorben Lindhauer
              Reporter:
              Thorben Lindhauer
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: