Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Problem with a loop
Migrateduser
<p>Hi,</p><p> </p><p>my statement looks like:</p><p> </p><p>select distinct tl.starttime, tm.id, tl.verdict, t.module_process_2, t.testlevel, t.patientsafety<br />
from tmconfiguredtestcase tm, tmtestlog tl, parent_child_links pc, tmiteration ti, tmtestcase t<br />
where tm.dbid = TL.CONFIGUREDTESTCASE<br />
and tm.dbid = pc.parent_dbid<br />
and ti.dbid = PC.CHILD_DBID<br />
and tm.testcase = t.dbid<br />
and tl.latest = 'true'<br />
script part:</p><p>this.queryText = this.queryText + "and ("<br />
var parmcount = params["Iteration"].value.length<br />
for( var i=0; i < parmcount; i++ ){<br />
var clause = params["Iteration"].value
;<br />
if (i == 0) {<br />
this.queryText = this.queryText + "(ti.dbid = (select dbid from tmiteration where name = '" + clause + "') and" + "tl.iteration = (select dbid from tmiteration where name = '" + clause + "'))";<br />
}<br />
else {<br />
this.queryText = this.queryText + " or (ti.dbid = (select dbid from tmiteration where name = '" + clause + "') and" + "tl.iteration = (select dbid from tmiteration where name = '" + clause + "'))";<br />
}<br />
} <br />
this.queryText = this.queryText + ")";</p><p> </p><p>the statement works but when i try to run the report i always get an error....</p><p> </p><p>any idea?</p><p> </p><p>thx</p>
Find more posts tagged with
Comments
There are no comments yet