ALM Reports — Getting the Full Name for Users
| ♥ 0 |
We are trying to create some reports where we would list the user assigned to a Requirement (author) as well as who updated a Requirement. We want to have the report list the user’s full name as entered in Site Admin. If I create a project report, the project report will display the Author’s full name. How do we display the full name in an EXCEL or Business View report?
Marked as spam
|
Posted by |
Private answer
Looking into the question that you had about how to get the full name in either a Business Views or Excel report I have the following information. The Full Name of the user is no longer stored in the project. It is stored in the Site Admin database. Here is the information from the Project Database reference for the User table. Since this information is not stored in the Project database you would not be able to use Business Views to display the full name in a report. The Business Views feature cannot attach to the Site Admin database and macro enabled excel files cannot be used with the Business Views feature. If you were to use Excel Reports you would need Query the User table of the Project DB to get the username (which is still stored in the Project database) and then on the Post-processing tab use the Site Admin API (which will require that you register a copy of the Site Admin on the workstation) to get the full name associated with the user name that was retrieved in the query on the Project DB. Here is a link to the online documentation for the API References for ALM 12.53 to included the Project DB, ALM OTA API, and the Site Admin API references. Marked as spam
 Posted by jefptman (Questions: 0, Answers: 309) Answered on February 1, 2018 12:59 am
|