HP ALM Workflow VBScript

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

Whenever you are interested in ALM Quality Center audit history you have various choices of getting the information.

One way of extracting history information from the database is using the Excel reporting functionality of the HP ALM Quality Center Dashboard.

First create a new Excel Report in the Analysis View of the Dashboard (see documentation library of HP ALM on details how to create such a report).

In the tab Configuration you will find the Query Builder, which allows querying the underlying database server of ALM Quality Center using SQL.

This is a nice feature, if you have to apply more complex analysis. Especially analysis on history information will require accessing audit tables either through the HP ALM OTA API or through SQL or both.

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 apply filters in HP ALM programmatically the following function allows you to escape characters in filter strings, which cause runtime errors if not handled properly.

Source Code