What could be the SQL query to find details about rejected attributes associated with a workitem?
Article ID: KB0091814
Updated On:
| Products | Versions |
|---|---|
| TIBCO Collaborative Information Manager | - |
| Not Applicable | - |
Description
Resolution:
Use the following query to find the details of rejected attributes in a workitem.
SELECT * FROM ATTRIBUTELOG WHERE productKeyId = <PRODUCTKEYID> AND attributeAction = 'APPROVAL' AND resultCode = 'REJECT' AND processLogId = <PROCESSLOGID>
You can get the PROCESSLOGID of the workitem activity from the event log.
Use the following query to find the details of rejected attributes in a workitem.
SELECT * FROM ATTRIBUTELOG WHERE productKeyId = <PRODUCTKEYID> AND attributeAction = 'APPROVAL' AND resultCode = 'REJECT' AND processLogId = <PROCESSLOGID>
You can get the PROCESSLOGID of the workitem activity from the event log.
Issue/Introduction
What could be the SQL query to find details about rejected attributes associated with a workitem?
Feedback
Yes
No
Powered by
