现象:
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 '27946%'
-- AND STATUS = 'OPEN'
ORDER BY 1
然后用查找出的NOTIFICATION ID 直接查找