How to retrieve the latest comments of a defect

  • Questions
  • How to retrieve the latest comments of a defect
Question ID: 104898

Hi Everyone,

How do i retrieve the latest comments for a defect?

I written a query to check the AUDITLOG table for each defect and calculate the length of the old comments and then retrieve the comments from New comments field.

The problem arises when the user deletes existing comments or just updates existing comments.

Any suggestion is greatly appreciated.

I am using quality centre 11.0

Marked as spam
Posted by (Questions: 1, Answers: 0)
Asked on March 14, 2013 6:45 pm
Answers (1)
Private answer

This is the problem when searching by String or Memo fields. It's easy to follow the history of field/menu workflows because it's a linear process that follows a timeline. No such thing with freely entered data in a string or memo field. If you have permissions to create a comment, then you have access to overwrite or delete previous comments. This is a management task and training issue. You can run Defect Reports that capture Comments on whatever time basis you want, but comparing a 'before' and an 'after' is tedious. The whole thing is like finding a needle in a haystack. Better instead to have the PM or QA Manager discipline the team to enter comments without altering existing comments. This is a people issue that cannot be scripted automatically into a solution instead.

Marked as spam
Posted by (Questions: 0, Answers: 8)
Answered on August 23, 2013 6:46 pm
Hi, Seems like you are also in the same boat :) Agree that this is a people issue but i am hoping that HP comes up with some solution for it, until then punishing people who updtes/deletes existing comments ..
( at August 25, 2013 2:52 pm)