Hello Everyone,

I am using the BIRT plugin for RTC to create custom reports for RQM. One report that I am trying to create is the link between Execution Results and Defects. My RQM project is connected to a ClearQuest project which hosts the defects.

All the information I need right now is stored in the com.ibm.rqm.execution.ExecutionResult table under the LIVE_SNAPSHOT.

Data is retrieved from:

stepResults.properties.key (ClearQuest Defect ID and Summary)
stepResults.properties.value (link to CQ defect)
where stepResults.properties.propertyType = "rtcdefectView"

The data shows up fine, except now when I add new defects to Execution Result records, the table doesn't seem to update, and it's already been 24 hours. I have tried to manually update LIVE_SNAPSHOT.

I am certain that the references to the new CQ defects have been created because the com.ibm.team.interop.ExternalState table shows the defect ID and summary under stringExtensions.value where stringExtensions.key = com.ibm.team.interop.xstate.WORKITEM_NAME.

On a side note I have create a SQL query that queries the database (via JDBC connection) that retrieves the same results as the Jazz Data Connection report, but with the new data available:

SELECT 

EXECUTION.EXECUTION_TASK_RESULT.ID,

EXECUTION.EXECUTION_TASK_RESULT.NAME,

LINK2.SOURCE_REF_URI,

EXTENSIONS2.VALUE

FROM 

EXECUTION.EXECUTION_TASK_RESULT,

LINKS.AUDITABLE_LINK LINK1,

LINKS.AUDITABLE_LINK LINK2,

INTEROP.EXTERNAL_STATE_STRING_EXTENSIONS EXTENSIONS1,

INTEROP.EXTERNAL_STATE_STRING_EXTENSIONS EXTENSIONS2



WHERE 

    EXECUTION.EXECUTION_TASK_RESULT.ITEM_ID = LINK1.TARGET_REF_REFERENCED_ITM_TM_D

AND LINK1.SOURCE_REF_REFERENCED_ITM_TM_D = LINK2.TARGET_REF_REFERENCED_ITM_TM_D

AND LINK2.SOURCE_REF_URI = EXTENSIONS1.VALUE

AND EXTENSIONS1.JZ_PARENT_ID = EXTENSIONS2.JZ_PARENT_ID

AND EXTENSIONS2.KEY_COL = 'com.ibm.team.interop.xstate.WORKITEM_NAME'

Why is the com.ibm.rqm.execution.ExecutionResult table not updating properly?

Also, what is the BIRT reference to the "EXECUTION.EXECUTION_TASK_RESULT" table listed in the SQL query? Is it com.ibm.rqm.execution.ExecutionResult, or another one?

Please help!

Thank you in advance.

Best regards,

Andrew