flowable历史任务查询

 SELECT DISTINCT
        RES.ID_ AS id,
        RES.NAME_ as name,
        DEF.KEY_ AS procDefKey,
        DEF.NAME_ AS procDefName,
        DEF.VERSION_ AS version,
        DEF.DEPLOYMENT_ID_ AS deployment,
        RES.START_USER_ID_ as startUserId,
        RES.START_TIME_ as startTime,
        RES.END_TIME_ as endTime,
        RES.DURATION_ as duration,
        RES.PROC_INST_ID_ as processInstanceId,
        RES.BUSINESS_KEY_ as businessKey,
        DEF.ID_ as processDefinitionId
        FROM
        ACT_HI_PROCINST RES
        LEFT OUTER JOIN ACT_RE_PROCDEF DEF ON RES.PROC_DEF_ID_ = DEF.ID_
        WHERE
        RES.END_TIME_ IS NOT NULL
        AND RES.START_USER_ID_ =#{userNameId}
        ORDER BY
        RES.END_TIME_ DESC