How to search test results by test name / ID?

[cirosantilli]

I have a large number of tests and I'm interested in the results for a particular one.

By default, the results are paginated, and clicking "Show all tests on one page" leads to a very large list which takes a very long time to load.

Is there a way to filter the tests by ID to see just the one I want to check?

[Daniel Santos]

Hi @cirosantilli

Bamboo does not have a feature to filter test results and therefore I just opened one to report your need: [BAM-20346] Implement a test result filter.

I worked also on a query as a workaround for this to get the data you need directly from the DB. You should be able to adjust the query to your needs.

SELECT
   BUILD_ID,
   BUILD_TYPE,
   FULL_KEY,
   TC.FIRST_BUILD_NUM,
   TC.LAST_BUILD_NUM,
   TC.QUARANTINING_USERNAME,
   TC.QUARANTINE_DATE,
   TC.LINKED_JIRA_ISSUE,
   TCL.*,
   TCR.*,
   TE.* TITLE

FROM BUILD B
   JOIN TEST_CLASS TCL ON TCL.PLAN_ID=B.BUILD_ID
   JOIN TEST_CASE TC ON TC.TEST_CLASS_ID=TCL.TEST_CLASS_ID
   JOIN TEST_CASE_RESULT TCR ON TCR.TEST_CASE_ID=TC.TEST_CASE_ID
   JOIN TEST_ERROR TE ON TE.RESULT_ID=TCR.TEST_CASE_RESULT_ID

WHERE B.FULL_KEY LIKE 'PLAN-KEY%'

I hope it helps.

[Daniel Santos]

Hi @cirosantilli

I see you voted in this answer. If that solves your issue, please accept the answer so other users can see this question as resolved and use its knowledge.

Thanks!