Uploaded image for project: 'jBPM'
  1. jBPM
  2. JBPM-9777

Enrich information of jbpmHumanTasksWithAdmin default query

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Done
    • Major
    • 7.56.0.Final
    • None
    • Workbench
    • None

    Description

      Create a new custom query based on jbpmHumanTaskWithAdmin with the information

      task-subject
      task-form
      lastModificationUser

      Created

        {
          "query-name": "jbpmHumanTasksWithAdminExtended",
          "query-source": "${org.kie.server.persistence.ds}",
          "query-expression": "select t.activationTime, t.actualOwner, t.createdBy, t.createdOn, t.deploymentId, t.description, t.dueDate, t.name, t.parentId, t.priority, t.processId, t.processInstanceId, t.processSessionId, t.status, t.taskId, t.workItemId, t.lastModificationDate, pil.correlationKey, pil.processInstanceDescription ,oe.id, nil.sla_due_date, nil.slaCompliance,(select COUNT(errInfo.id) from ExecutionErrorInfo errInfo where errInfo.ACTIVITY_ID = t.taskId and errInfo.PROCESS_INST_ID = pil.processInstanceId and errInfo.ERROR_ACK = 0 and errInfo.ERROR_TYPE = 'Task') as errorCount, i18n.text  as subject, i18n.language as language from AuditTaskImpl t  left join ProcessInstanceLog pil on pil.processInstanceId = t.processInstanceId left join PeopleAssignments_BAs ba on t.taskId = ba.task_id left join OrganizationalEntity oe on ba.entity_id = oe.id left join NodeInstanceLog nil on nil.workItemId=t.workItemId left join I18NText i18n ON i18n.Task_Subjects_Id = t.taskId",
          "query-target": "FILTERED_BA_TASK"
        }
      

      it requires to be filtered by language otherwise there will be one line per language of the same task.

      Attachments

        Activity

          People

            elguardian@gmail.com Enrique González Martínez (Inactive)
            elguardian@gmail.com Enrique González Martínez (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: