TestRun Template query

Description
thomas.boll
Posts: 7
Joined: Wed Sep 02, 2015 12:34 pm

TestRun Template query

Postby thomas.boll » Mon Nov 16, 2015 12:30 pm

Hello,

I have a little problem to query all TestRuns which are not templates.

With following query I get all template testruns:

Code: Select all

SELECT TR.C_PK FROM POLARION.TESTRUN TR INNER JOIN LUCENE_QUERY('TestRun', '$preCond', 'id') TR_PRE ON TR.C_PK=TR_PRE.C_PK WHERE TRUE AND TR.C_ISTEMPLATE = true

But when I change the TR.C_ISTEMPLATE = true to TR.C_ISTEMPLATE = false I didn't get all testruns not being a template

Code: Select all

SELECT TR.C_PK FROM POLARION.TESTRUN TR INNER JOIN LUCENE_QUERY('TestRun', '$preCond', 'id') TR_PRE ON TR.C_PK=TR_PRE.C_PK WHERE TRUE AND TR.C_ISTEMPLATE = false


Hope someone can help me.

Kind regards
Thomas Boll

pasco84
Posts: 4
Joined: Wed Oct 21, 2015 7:07 am

Re: TestRun Template query

Postby pasco84 » Mon Nov 23, 2015 1:05 pm

maybe it helps

Code: Select all

SELECT TESTRUN.C_PK FROM (TESTRUN inner join PROJECT on TESTRUN.FK_PROJECT = PROJECT.C_PK)  WHERE PROJECT.C_ID='your_project_name' AND C_ISTEMPLATE IS NULL


Return to “Polarion Application Lifecycle Management (ALM)”

Who is online

Users browsing this forum: No registered users and 10 guests