What could be the SQL query to find details about rejected attributes associated with a workitem?

What could be the SQL query to find details about rejected attributes associated with a workitem?

book

Article ID: KB0091814

calendar_today

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 = &ltPRODUCTKEYID> AND attributeAction = 'APPROVAL'  AND resultCode = 'REJECT' AND processLogId = &ltPROCESSLOGID>

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?
Powered by Wolken Software