现象：

OA \ FIND NOTIFICATION 页面中，通过type、subject等组合条件查询无结果

解决（临时）：

1) PO

       select *
           from wf_notifications ntf
           where MESSAGE_TYPE = 'POAPPRV'
           --AND    MESSAGE_NAME = 'PO_PO_APPROVE'
           --AND    RECIPIENT_ROLE = 'CGB-LXM'
           AND    SUBJECT LIKE '%4075846%'
           --AND    STATUS = 'OPEN'
           ORDER BY 1


2) PR

       SELECT *
       FROM WF_NOTIFICATIONS NTF
       WHERE MESSAGE_TYPE = 'REQAPPRV'
       AND    MESSAGE_NAME = 'PO_REQ_APPROVE'
       --AND    RECIPIENT_ROLE = 'ZCB-SUNLIGHT'
       AND    SUBJECT LIKE '%1027946%'
      -- AND    STATUS = 'OPEN'
       ORDER BY 1

然后用查找出的NOTIFICATION ID 直接查找

ITPub博客

WF-1 FIND NOTIFICATION 下组合条件查找无结果

最新文章