数据库代码：

SELECT 
    log.requestid AS 流程ID,
    log.workflowid AS 流程定义ID,
    workflow.workflowname AS 流程名称,
    log.nodeid AS 退回节点ID,
    from_node.nodename AS 退回节点名称,
    log.destnodeid AS 退回目标节点ID,
    to_node.nodename AS 目标节点名称,
    log.operator AS 操作人ID,
    res.lastname AS 操作人姓名,
    log.receivedPersons AS 接收人,
    log.operatedate AS 操作日期,
    log.operatetime AS 操作时间,
    REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
        CAST(log.remark AS NVARCHAR(MAX)), 
        '<P>', ''), 
        '</P>', ''),
        '<p>', ''),
        '</p>', ''),
        '<br>', ''),
        '<br />', '') AS 退回意见
FROM workflow_requestlog log
JOIN workflow_nodebase from_node ON log.nodeid = from_node.id
JOIN workflow_nodebase to_node ON log.destnodeid = to_node.id
JOIN HrmResource res ON log.operator = res.id
JOIN workflow_base workflow ON log.workflowid = workflow.id
WHERE 
    logtype = '0'  -- 3表示退回操作
    AND log.operatedate like '%2025%'

执行效果：

数据库字段定义：

在workflow_requestlog表的logtype字段中，0代表批准操作，2代表提交操作，3代表退回操作，7代表转发操作，9代表批注操作。