If you ever wanted to filter requirements or other entities in HP ALM Quality Center by follow ups set for a user the below can give you a hint on how to do it.

Unfortunately I have not yet found a way to filter entities with follow up flags / alerts using a standard function in HP ALMs web interface.

The below SQL has been developed and used by one of my collegues who asked me how he could filter for all his requirements, which do have a follow up / alert set.

I told him I do not know any standard function but that there must be a way using the HP ALM Dashboard and SQL. We searched for the correct tables in the documentation and found the 'ALERT' table.

However this can be nice for power users, it is not yet a solution which I would hand to less skilled users since the user name has to be hard coded.

I will look into this and maybe provide a little script, which can do the trick using the HP ALM REST or OTA API but it is a shame that HP does not seem to provide a standard function for this simple task.

SQL

SELECT
at_entity_type as entity,
RQ_REQ_ID as ID,
RQ_REQ_NAME as item,
at_description as follow_up,
rq_req_reviewed,
REL_NAME as release,
TPR_NAME as req_type,
rq_user_template_02 as module
FROM Alert
join REQ on at_entity_type = 'REQ' and AT_KEY1 = RQ_REQ_ID
join REQ_TYPE on rq_type_id = tpr_type_id
join REQ_RELEASES /*Requirements to Releases Link*/ on RQRL_REQ_ID = RQ_REQ_ID
join RELEASES /*Release*/ on RQRL_RELEASE_ID = REL_ID
where at_user = 'aUserName'
and at_entity_type = 'REQ'
and at_alert_type = 1
and rq_req_reviewed != 'Rejected'
order by 1, 3

Last Updated: 13 September 2015

Hits: 4827

In case you have to append a comment to an HP ALM memo field, the following method might be of help.

Source Code

Last Updated: 01 January 2018

Hits: 3887

Recently I had to remove the history from some fields in HP ALM Quality Center.

In order to do that go to a projects customization and uncheck the History checkbox in a fields customization details.

However, I recently learned this will not always delete the Audit records in the underlying database :0).

Last Updated: 17 November 2016

Hits: 4226