Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
Praveen_ji Absent Member.
Absent Member.
3532 views

How to find the Field names in TESTSET?

Jump to solution

Hi , 

 

How to retrieve Testset field names from ALM by using C#?

 

I tried like this which is not working..   string a66 = Convert.ToString(test["TC_EXECUTION_TIME"]);

 

its showing the error :  Invalid field name < TC_EXECUTION_TIME >.

 

can any one plz help me to find the field names here.

 

Thank you.

Praveen Ji

 

0 Likes
1 Solution

Accepted Solutions
Absent Member.. Tom_Janouskovec Absent Member..
Absent Member..

Re: How to find the Field names in TESTSET?

Jump to solution

Hi.

 

Follow this Url (you should update it with your alm server first):

http://%youralmurl%/qcbin/Help/doc_library/api_refs/project_db/webframe.html

or

Help -> Documentation Library -> API References - HP ALM Project Database Reference

 

Br, Tomas

 

[If my advice solves your issue or query, please mark the thread as solved. Clicking on KUDOS star is the best way how to say thank you.]

 

[If my advice solves your issue or query, please mark the thread as solved. Clicking on KUDOS star is the best way how to say thank you.]
0 Likes
9 Replies
Absent Member.. Trudy Claspill Absent Member..
Absent Member..

Re: How to find the Field names in TESTSET?

Jump to solution
The names of the underlying database fields can be found through the Tools > Customization > Project Entities interface. That will show you the system defined and user defined fields in the UI, both the label in the UI and the database field name to which it is linked.

The prefix at the beginning of the name indicates what database table it comes from. You will need to look at the Database Reference documentation for more details on that.

The code you provided is not sufficient for us to debug your problem. Please provide the rest of the code that shows how you defined the "test" item.
[If this post solves or helps solve your issue, mark the thread as solved and give KUDOS to the author for their assistance.]

(Opinions expressed in my postings are mine alone, and do not reflect the opinions of my employer.No warranties express or implied for any solution/suggestion posted.)
0 Likes
Praveen_ji Absent Member.
Absent Member.

Re: How to find the Field names in TESTSET?

Jump to solution

Hi Trudy Claspill, 

 

Than you for your reply..

 

Finally i got successfully retrieved all my testset fields .

 

 string a6 = Convert.ToString(test["TC_EXEC_TIME"]); //planned exec date

 

 

Here my another requirement is that also retrieve fields in Defects.. But I didn't find field names in OTA API reference guide(provided by HP).

I tried like this

string b5 = Convert.ToString(bg["BG_PROJECT"]); 
string b6 = Convert.ToString(bg["BG_STATUS"]);

string b7 = Convert.ToString(bg["BG_TARGET_CYCLE"]);

 

Last statement showing Invalid field name error.

 

Please help me to get all field names.

 

Thank you

 

0 Likes
Absent Member.. Tom_Janouskovec Absent Member..
Absent Member..

Re: How to find the Field names in TESTSET?

Jump to solution

Hi.

 

There is a DB Guide provided by HP.

 

You probably mean 

BG_TARGET_RCYC The RELEASE_CYCLES.RCYC_IDof the release cycle in which the defect is planned to be fixed.

 

Be aware because return value is int or cycle object itself.

 

Br, Tomas

 

[If my advice solves your issue or query, please mark the thread as solved. Clicking on KUDOS star is the best way how to say thank you.]

[If my advice solves your issue or query, please mark the thread as solved. Clicking on KUDOS star is the best way how to say thank you.]
0 Likes
Praveen_ji Absent Member.
Absent Member.

Re: How to find the Field names in TESTSET?

Jump to solution

I didnt find the  DB Guide in Hp site. Can you please help me to give the link for DB guide.

 

Really it's irritating me to find the field names..

 

And For better understanding my requirement please take a look my code here.

0 Likes
Absent Member.. Tom_Janouskovec Absent Member..
Absent Member..

Re: How to find the Field names in TESTSET?

Jump to solution

Hi.

 

Follow this Url (you should update it with your alm server first):

http://%youralmurl%/qcbin/Help/doc_library/api_refs/project_db/webframe.html

or

Help -> Documentation Library -> API References - HP ALM Project Database Reference

 

Br, Tomas

 

[If my advice solves your issue or query, please mark the thread as solved. Clicking on KUDOS star is the best way how to say thank you.]

 

[If my advice solves your issue or query, please mark the thread as solved. Clicking on KUDOS star is the best way how to say thank you.]
0 Likes
Highlighted
Praveen_ji Absent Member.
Absent Member.

Re: How to find the Field names in TESTSET?

Jump to solution

Thank you Tom_Janouskovec...... 🙂

 

saves my time a lot.

0 Likes
Praveen_ji Absent Member.
Absent Member.

Re: How to find the Field names in TESTSET?

Jump to solution

Hi,

Project_DB giving all the field names but i couldn't find some fileds here. 

Those fields are: 

 

ApplicationComponent , CausedByCodeChange , ClosedInBuild , DefectType ,  DetectedInBuild , ServiceDeskSystem , SMCLIENT , SMLANGUAGE ,Sync Status SystemID , TransferredRequirement , TransferredTest,

 

Why these fields are not included in Project_DB document? How to retrieve these fields ??

 

 

Thank you in Advance.

0 Likes
Absent Member.. Tom_Janouskovec Absent Member..
Absent Member..

Re: How to find the Field names in TESTSET?

Jump to solution
Hi.

Your are probably asking for used defined fields which are project related. You can get info about these fields from project customization or site admin or maybe from OTA API customizaton fields collection.

Br,
Tomas
[If my advice solves your issue or query, please mark the thread as solved. Clicking on KUDOS star is the best way how to say thank you.]
Praveen_ji Absent Member.
Absent Member.

Re: How to find the Field names in TESTSET?

Jump to solution

Thanks again Tom Janouskovec

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.