8.3
I’m using rapid setup leaver with a provisioning plan, and adding comments to the plan via the setComments method. I would like those comments to be visible in my Detailed Provisioning Transaction Object Reports, but I’m not certain how to retrieve this information (I don’t have schema access). Can anyone give me a hint?
HI @AJGibson76
The Detailed Provisioning Transaction Object Report is an ootb report that uses the java data source. Adding a column (such as comments) directly to this report will not display the comment data.
To include the comments, you’ll need to create a new custom report using either the Filter or HQL data source. In the new report, implement the logic to retrieve the comments.
<DataSource objectType="ProvisioningTransaction" type="Filter">
Is there anyway to take a copy of the OOTB plan and add a row for the column, and then add a script to retrieve the comment from the appropriate table?
Hi @AJGibson76 ,
The Detailed Provisioning Transaction Object Report using the ProvisioningTransactionObjectDataSource.class file.
To include additional logic such as fetching comments, you can create a custom report using a Java datasource similar to ProvisioningTransactionObjectDataSource.
Package the class into a JAR file, place it under WEB-INF/lib, and restart the application server to apply the changes.
Let me try a different approach: how can I connect a transfer from spt_provisioning_transaction wtih a request in spt_provisioning_request?
I noticed in spt_provisioning_transaction.provisioning_plan there is a field in the root xml tag called trackingId. Can anyone tell me what it does?