ID_,OBJ_TYPE_,AUTHORIZE_ID_,OWNER_ID_,OWNER_NAME_,RIGHT_TYPE_,AUTH_ORG_,AUTH_ORG_NAME_
AND ID_ =#{id}
AND OBJ_TYPE_ =#{objType}
AND AUTHORIZE_ID_ =#{authorizeId}
AND OWNER_ID_ =#{ownerId}
AND OWNER_NAME_ LIKE #{ownerName}
AND RIGHT_TYPE_ =#{rightType}
DELETE FROM BPM_DEF_USER
WHERE
ID_=#{id}
SELECT
SELECT
order by ${orderField} ${orderSeq}
order by ID_ desc
select AUTHORIZE_ID_ from (
select AUTHORIZE_ID_ from BPM_DEF_USER u where RIGHT_TYPE_ = 'everyone' and OBJ_TYPE_=#{objType,jdbcType=VARCHAR}
union
select AUTHORIZE_ID_ from BPM_DEF_USER u
where RIGHT_TYPE_ = #{key} and OWNER_ID_ in (${value}) and OBJ_TYPE_=#{objType,jdbcType=VARCHAR}
) a ORDER BY a.AUTHORIZE_ID_ DESC
select
union
select
) a ORDER BY a.ID_ DESC
select AUTHORIZE_ID_ from BPM_DEF_USER u where RIGHT_TYPE_ = 'everyone' and AUTHORIZE_ID_=#{authorizeId,jdbcType=VARCHAR}
union
select AUTHORIZE_ID_ from BPM_DEF_USER u
where RIGHT_TYPE_ = #{key} and OWNER_ID_ in (${value}) and AUTHORIZE_ID_=#{authorizeId,jdbcType=VARCHAR}
DELETE FROM BPM_DEF_USER
WHERE AUTHORIZE_ID_=#{authorizeId} AND OBJ_TYPE_=#{objType,jdbcType=VARCHAR}