How to get Field Names in ALM ?

Requirement:-We need the field names which are used in ALM , these are required to utilize the cabablities of OTA in ALM.

Fields In Test Lab
Test Lab fields

Solution:-
Approach 1:-

A. In ALM , Dashboard — Analysis View

Dashboard ALM
ALM Tabs


B.Create New Excel Report

Excel Report ALM
Excel Report


C.Under Configuration tab – – Query Builder

Configuration Tab ALM
Configuration Tab 


D. Write the following SQL query  and Run it .We have our required Field Names with Labels in ALM.

SQL Query in ALM
SQL Query


Approach 2:-


This will work incase User have the admin rights in the ALM.

A.Tools – – Customize
Customize in ALM
Customize in ALM

B.Select Project Entities

Project Entities in ALM
Project Entities

C.Under Project Entities — Select the field for which we want to check the field Name

View of Fields in Project Entities ALM
View of Fields in Project Entities

Name and Label suggest the Field Name used by ALM and Displayed to User respectively.

Reader Comments and Recommendations are most welcomed :).

ufthelp

3 thoughts on “How to get Field Names in ALM ?

  1. In Test Lab, I have marked some of the TC’s as N/A. While exporting the test results I could not find the comments given for N/A TC’s.
    Can anyone throw light on how to retrieve the N/A comments given?

  2. There is a simpler way; go to customize –> Project Entities –> Open the entity and click on required field. The "Name" parameter will list the actual filed name in db.

Leave a Reply

Your email address will not be published. Required fields are marked *