Hi Kael,
I am not saying "Test plan" will have direct relationship with "Test Result".
Test Plan will have relationship with Test Objectives and Test Objectives will have relationship with "Test Session" from Test session we can get the test result.
Finally I have written the code for my requirement
<%beginrelationshipsdetailL2 Completed Test Sessions%>
<tr><td width="100%" colspan="2" style="display:none;"><%RelationshipL2 Tests As Of Date%></td></tr>
<%beginrelationshipsdetailL3 Query[(walktestsession[<%RelationshipL2 ID%>])]%>
<script>
if(!testSessionIds.contains("<%RelationshipL3 ID%>"))
{
testSessionIds[testSessionInd++]="<%RelationshipL3 ID%>";
testCaseDupl=0;
}
else
{
testCaseDupl=1;
}
</script>
<%begintestresultdetailL3%>
<script>
count=0;
if(testCaseDupl==0)
{
for(var k=0;k<testSessionsDetails.length;k++)
{
if("<%testresult Session ID%>".match(testSessionsDetails[k]))
{
count=1;
}
}
if(count==1)
{
testSessionDetails[testSessDeIndex++]="<%testresult Session ID%>";
testSessionDetails[testSessDeIndex++]="<%testresult Test ID%>";
testSessionDetails[testSessDeIndex++]="<%testresult Verdict%>";
}
}
var relatedCount=0;
</script>
<%begintestresultitemdetailL3%>
<script>
if(count==1 )
{
if(relatedCount==0&&!((typeof "<%testresultitem ID%>").match("undefined"))&&("<%testresultitem Type%>".match("Defect")))
{
testSessionDetails[testSessDeIndex]="<%testresultitem ID%>";
relatedCount++;
noDefect=1;
}
else if(!((typeof "<%testresultitem ID%>").match("undefined"))&&("<%testresultitem Type%>".match("Defect")))
{
testSessionDetails[testSessDeIndex]=testSessionDetails[testSessDeIndex]+",<%testresultitem ID%>";
noDefect=1;
}
}
</script>
<%endtestresultitemdetailL3%>
<script>
if(count==1)
{
if(noDefect==0)
{
testSessionDetails[testSessDeIndex]="No Defect Logged";
++testSessDeIndex;
}
else{
++testSessDeIndex;
}
}
noDefect=0;
</script>
<%endtestresultdetailL3%>
<script>
if(testSessionDetails.length>2)
{
if(testSessionDetails[testSessionDetails.length-2]=="Failed" && testSessionDetails.length>0)
{
var defectArr=new Array();
if(!testSessionDetails[testSessionDetails.length-1].match("No Defect Logged"))
{
defectArr=testSessionDetails[testSessionDetails.length-1].split(",");
defectCount=defectCount+defectArr.length;
}
document.write("<tr><td>"+testSessionDetails[testSessionDetails.length-4]+"</td>");
document.write("<td><a href='<%integrityurl%>im/viewissue?selection="+testSessionDetails[testSessionDetails.length-3]+"'>"+testSessionDetails[testSessionDetails.length-3]+"</a></td>");
document.write("<td style='background-color:#d699ad'>"+testSessionDetails[testSessionDetails.length-2]+"</td>");
document.write("<td>"+testSessionDetails[testSessionDetails.length-1]+"</td></tr>");
}
}
testSessionDetails.length=0;
testSessDeIndex=0;
</script>
<%endrelationshipsdetailL3%>
<%endrelationshipsdetailL2%>
Thanks,
Sithik
