Unsupported
Thumb_database

SQL Query for Test Runs

 This Wiki snippet will add Test Cases to your Test Run based on a SQL query

Description

share this page via facebook share this page via LinkedIn share this page via Twitter share this page via Google+ share this page via email More sharing services

You can also decide if Test Cases should only be added during creation of a Test Run like Polarion's Test Run functionallity "By Query on create" or if it should be possible to add Test Cases till execution of your Test Run "By Query on execute" (HowTo is added as comment in SQL Run.txt)

Examples:

Get all Test Cases of project playground:

SELECT WORKITEM.C_PK FROM polarion.WORKITEM INNER JOIN polarion.PROJECT ON WORKITEM.FK_PROJECT=PROJECT.C_PK WHERE PROJECT.C_ID =  'playground'  AND C_TYPE='testcase'

Get all Test Cases linked to work items via verifies link role in project playground:

SELECT WORKITEM.C_PK FROM Polarion.WORKITEM INNER JOIN polarion.STRUCT_WORKITEM_LINKEDWORKITEMS ON WORKITEM.C_PK = STRUCT_WORKITEM_LINKEDWORKITEMS.FK_P_WORKITEM INNER JOIN polarion.PROJECT ON WORKITEM.FK_PROJECT=PROJECT.C_PK WHERE PROJECT.C_ID =  'playground'  AND STRUCT_WORKITEM_LINKEDWORKITEMS.C_ROLE = 'verifies' AND C_TYPE = 'testcase'

How to install:
  • Download SQL Run.txt
  • Create Test Run Custom field: "id: sql , type: string"
  • Go Into Test Run templates
  • Select template you want to use
  • Paste Wiki content into your Test Run template
  • Add SQL query you want to use to custom field of your Test Run template 
  • Create new Test Run and select previously chosen Test Run template
 
Feel free to add your own SQL examples as comments below.

Information

Vendor Dan Mors (Siemens PLM)
Published Version 1.0 - January 2014
Categories
Price Free
142 Downloads
Unsupported Extension This extension is not supported by Siemens PLM.
Requirements