HP ALM

This category is a parent category in order to collect all sub categories and according articles.

VBScript or HP ALM APIs do not offer a class or method for getting a file path from a user.

Therefore we have to use a workaround, which consists in using a different application to display a file picker dialog to a user.

A very simple solution would be to provide a user with an InputBox, which is unsatisfactory for me. Also users have to type or copy a path correctly, which they are sometimes not capable of.

I choose to automate Microsoft Excel to display a file picker dialog to a user.

If you have to reference attachments in HP ALM Defects module the following script might give you a hint on how to implement it.

Source Code

 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

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
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

Subcategories

This category is meant to hold all articles regarding HP ALM REST API.

This category will provide articles regarding usage of Visual Basic Script in the workflow module of HP ALM.