nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How can I get the list of tests in a test case in Jira database (induced by the Xray add-on)?

Ioana Slubczakowsky

I am trying to get the list of tests included in a test case through a query in the jira database. I though the connection is made through the jira.issuelink table, but it is not in here. The concept of Test and Test Case are from the addition of the Xray add-on, and I can see the correlation in the interface, but find it hard to create a query that would bring the same results on the database side.

Thank you in advance!

Accepted answers

Sergio Freire - Xblend

Hi @Ioana Slubczakowsky , are you using Jira server or cloud?

I may be a bit confuse because your questions is tagged with "cloud" and "jira-cloud".

You seem to be referring to a hosted database, which does not make sense in the cloud product.

Also, can you please clarify what do you mean exactly with "the list of tests included in a test case", as a test case cannot include other test cases (at least for the time being).

Looking forward for your feedback

Regards,

Sergio

All comments

Sergio Freire - Xblend

Hi @Ioana Slubczakowsky , are you using Jira server or cloud?

I may be a bit confuse because your questions is tagged with "cloud" and "jira-cloud".

You seem to be referring to a hosted database, which does not make sense in the cloud product.

Also, can you please clarify what do you mean exactly with "the list of tests included in a test case", as a test case cannot include other test cases (at least for the time being).

Looking forward for your feedback

Regards,

Sergio

Ioana Slubczakowsky

Hi Sergio, thank you for the answer.

Guess I tagged the wrong things, sorry, it's my first post and wanted to make it visible.

I am particularly interested in the list of tables in jira database where the Xray add-on keeps its info, and in this case I was interested in the connection that exists between a test case and a test. Xray introduced the following concepts as far as I understood:

- tests

-test plans

-test cases, which I can all find in the database as issues and differentiate through issue type.

Since one test case can contain multiple tests (and I can see that in the jira web tool), I wanted to see how I can make that association. Meanwhile I related them through the story (all tests associated to a test case had in the summary the story name).