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.

The following source allows you to delete a file on a users hard disc without having to know if it really exists or not.

On top it provides you with error handling, so you only have to catch its Boolean result instead of having to check and handle these things every time.

Source Code

' @Author - Alexander Bolte
' @ChangeDate - 2014-12-19
' @Description - Using the Scripting API to delete a file,
' if it is existing under provided file path.
' @Returns ture, if file has been deleted or has not existed
' under given file path else false.
Function deleteFileOnHD(filePath)
    Dim fs ' As Scripting.FileSystemObject
    Dim ret ' As Boolean

    On Error Resume Next

    Set fs = createObject("Scripting.FileSystemObject")
    ' Check for a files existance.
    If fs.FileExists(filePath) Then
        ' delete a file.
    End If

    If Err.Number <> 0 Then
        ret = True
    End If
    Set fs = Nothing

    deleteFileOnHD = ret
End Function

Referenced API

Referenced APIs are as follows.

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