topic Re: testresult verdict in report in Windchill Systems/Software Engineering (Integrity)https://community.ptc.com/t5/Windchill-Systems-Software/testresult-verdict-in-report/m-p/483543#M5519
<P>Hi&nbsp;<LI-USER uid="245207"></LI-USER>,</P>
<P>&nbsp;</P>
<P>I like to try your report which is looking very interesting but fields and all are according to your solution can you help me little on this ?</P>
<P>&nbsp;</P>
<P>I look forward to hear form you.</P>
<P>&nbsp;</P>
<P>Thanks&nbsp;<LI-USER uid="245207"></LI-USER>.</P>
<P>&nbsp;</P>
<P>Regards,</P>
<P>Kapil</P>Fri, 08 Sep 2017 05:33:12 GMTkjain-22017-09-08T05:33:12Ztestresult verdict in reporthttps://community.ptc.com/t5/Windchill-Systems-Software/testresult-verdict-in-report/m-p/785#M39
Hi all,I'd like to create a "Test Session Details" report that covers the follow content.1. the sessions meta data (run-date, assigned user, test environment , etc.)2. the used test case data (Text, Passed/Failed criteria, Category, etc. )and 2.1 the concrete result (verdict)Wed, 05 Jun 2013 11:48:28 GMThttps://community.ptc.com/t5/Windchill-Systems-Software/testresult-verdict-in-report/m-p/785#M39mrump2013-06-05T11:48:28ZRe: testresult verdict in reporthttps://community.ptc.com/t5/Windchill-Systems-Software/testresult-verdict-in-report/m-p/786#M40
<HTML><HEAD></HEAD><BODY><P>Finally, I found a way to solve this:</P><P></P><P>1. walk the session's test cases to get their content and set a default value for the verdict. Also set the test case ID as ID for the table cell element! </P><P>2. after that iterate the test session's result objects and use javascript (jquery) to "promote" the verdicts value to the according test case's table cell element.</P><P></P><P>&lt;!-- get test cases details--&gt;</P><P>&lt;/table&gt;</P><P> &lt;%beginrelationshipsdetail Query[(walktestsession[&lt;%&lt;%builtin ID%&gt;%&gt;])] %&gt;</P><P> </P><P> &lt;table class="detailcols fullWidth"&gt;</P><P> &lt;tr class="detailheading"&gt; </P><P> &lt;span&gt;</P><P> &lt;td colspan="1" width="10%"&gt;&lt;a href="&lt;%hosturl%&gt;im/WebClient?IssueID=&lt;%Relationship ID%&gt;"&gt;&lt;%Relationship ID%&gt;&lt;/a&gt;&lt;/td&gt;</P><P> &lt;td colspan="3" width="70%"&gt;&lt;%Relationship &lt;%builtin Summary%&gt;%&gt;&lt;/td&gt;</P><P> &lt;td colspan="1" width="10%"&gt;&lt;%Relationship &lt;%builtin Category%&gt;%&gt;&lt;/td&gt; </P><P></P><P> <STRONG>&lt;td colspan="1" class="verdict" id="&lt;%Relationship &lt;%builtin ID%&gt;%&gt;"&gt;-&lt;/td&gt;</STRONG></P><P></P><P> &lt;/span&gt;</P><P> &lt;/tr&gt; </P><P> &lt;tr&gt;</P><P> &lt;span&gt;</P><P> &lt;td style="border: 1px solid grey;" colspan="3" width="50%" &gt;&lt;%Relationship RQ_Text%&gt;&lt;/td&gt;</P><P> &lt;td style="border: 1px solid grey;" colspan="3" width="50%" &gt;&lt;%Relationship TM_PassFail_Criteria%&gt;&lt;/td&gt;</P><P> &lt;/span&gt;</P><P> &lt;/tr&gt;</P><P> &lt;/table&gt;</P><P> </P><P> &lt;%endrelationshipsdetail%&gt;</P><P></P><P>...</P><P>&lt;!-- iterate the result to promote the verdicts --&gt;</P><P>&lt;%beginrelationshipsdetail Query[(field[ID]=&lt;%&lt;%builtin ID%&gt;%&gt;)] %&gt;<BR />&lt;%begintestresultdetail%&gt; </P><P>&lt;script type="text/javascript" charset="utf-8"&gt;<BR /> $(document).ready(function() {<BR /> //run as soon als the document is loaded to the browser <BR /> var verdict = "&lt;%testresult Verdict%&gt;";<BR /> $('#&lt;%testresult Test Case ID%&gt;').text("&lt;%testresult Verdict%&gt;");<BR /> switch(verdict){<BR /> case "Failed": <BR /> $('#&lt;%testresult Test Case ID%&gt;').css('backgroundColor', '#FF3300');<BR /> break; <BR /> case "Passed": <BR /> $('#&lt;%testresult Test Case ID%&gt;').css('backgroundColor', '#66FF66');<BR /> break;<BR /> default:<BR /> $('#&lt;%testresult Test Case ID%&gt;').css('backgroundColor', '#CCCCCC');<BR /> } <BR /> });<BR />&lt;/script&gt;</P><P>&lt;%endtestresultdetail%&gt;</P><P>&lt;%endrelationshipsdetail%&gt;</P><P></P><P>the Report now look like this:</P><P><IMG __jive_id="52267" class="jive-image-thumbnail jive-image" onclick="" alt="screenshot_001.jpg" src="https://community.ptc.com/legacyfs/online/52267_screenshot_001.jpg" width="450" /></P><P></P><P>Just what I wanted:</P><P></P><P>The complete testsession content with only the concrete results from this testsession.</P></BODY></HTML>Wed, 12 Jun 2013 13:50:35 GMThttps://community.ptc.com/t5/Windchill-Systems-Software/testresult-verdict-in-report/m-p/786#M40mrump2013-06-12T13:50:35ZRe: testresult verdict in reporthttps://community.ptc.com/t5/Windchill-Systems-Software/testresult-verdict-in-report/m-p/482093#M5479
<P>Hi&nbsp;<LI-USER uid="245207"></LI-USER>,</P>
<P>&nbsp;</P>
<P>I really appreciate your effort and work done on very interesting report ....<BR />But i have some doubt there is an OOTB report "Test Session Result Status" that also looks like same , correct me if i am wrong...<BR />I just want to know is there any difference in your report as compare with OOTB report..</P>
<P>I look forward to hear from you.<BR /><BR />Thanks <LI-USER uid="245207"></LI-USER>.&nbsp;</P>
<P>&nbsp;</P>
<P>Regards,</P>
<P>Kapil</P>Tue, 22 Aug 2017 04:07:09 GMThttps://community.ptc.com/t5/Windchill-Systems-Software/testresult-verdict-in-report/m-p/482093#M5479kjain-22017-08-22T04:07:09ZRe: testresult verdict in reporthttps://community.ptc.com/t5/Windchill-Systems-Software/testresult-verdict-in-report/m-p/482639#M5498
<P>Hi Kapil,</P>
<P>well there are some differences to the OOTB report "Test Session Result Status".</P>
<P>&nbsp;</P>
<P>The main one would be that&nbsp;the OOTB report "Test Session Result Status"&nbsp;shows only the existing results for the test cases of a session. This is OK if you can&nbsp;guarantee that there is&nbsp;always a result for all planned test cases of a test session, but&nbsp;any planned and "not run" test case won't make it into the report.</P>
<P>That was not what my cutomers wanted; so my report is focused on all the planned test cases, not just the ones that were actually run.</P>
<P>Doing so led to the problem that for each testcase there are several results available (one for each session it was run in). So my result had to deal with that by filtering the ones of interest.</P>
<P>&nbsp;</P>
<P>HTH Matthias</P>Mon, 28 Aug 2017 14:34:52 GMThttps://community.ptc.com/t5/Windchill-Systems-Software/testresult-verdict-in-report/m-p/482639#M5498mrump2017-08-28T14:34:52ZRe: testresult verdict in reporthttps://community.ptc.com/t5/Windchill-Systems-Software/testresult-verdict-in-report/m-p/483388#M5518
<P>Hi&nbsp;<LI-USER uid="245207"></LI-USER>,</P>
<P>&nbsp;</P>
<P>Apologies from my side for delayed in response as i was on holiday.<BR />And this report looks more interesting rather then OOTB report and i want to try it out , can you guide me a little how to enable this and what changes i need to do in your script for me ?&nbsp;</P>
<P>I look forward to hear from you. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span>&nbsp;</P>
<P>&nbsp;</P>
<P>Thanks&nbsp;<LI-USER uid="245207"></LI-USER>.</P>
<P>&nbsp;</P>
<P>Kapil</P>Wed, 06 Sep 2017 06:18:54 GMThttps://community.ptc.com/t5/Windchill-Systems-Software/testresult-verdict-in-report/m-p/483388#M5518kjain-22017-09-06T06:18:54ZRe: testresult verdict in reporthttps://community.ptc.com/t5/Windchill-Systems-Software/testresult-verdict-in-report/m-p/483543#M5519
<P>Hi&nbsp;<LI-USER uid="245207"></LI-USER>,</P>
<P>&nbsp;</P>
<P>I like to try your report which is looking very interesting but fields and all are according to your solution can you help me little on this ?</P>
<P>&nbsp;</P>
<P>I look forward to hear form you.</P>
<P>&nbsp;</P>
<P>Thanks&nbsp;<LI-USER uid="245207"></LI-USER>.</P>
<P>&nbsp;</P>
<P>Regards,</P>
<P>Kapil</P>Fri, 08 Sep 2017 05:33:12 GMThttps://community.ptc.com/t5/Windchill-Systems-Software/testresult-verdict-in-report/m-p/483543#M5519kjain-22017-09-08T05:33:12ZRe: testresult verdict in reporthttps://community.ptc.com/t5/Windchill-Systems-Software/testresult-verdict-in-report/m-p/483802#M5525
<P>Here's a cleaned Version of my recipe.</P>
<P>&nbsp;</P>
<P>I tried to limit it to default ALM solution fields and use as many builtin fields as possible.</P>
<P>&nbsp;</P>
<P>I basically merges a "Document Content" recipy with a test session result recipe.</P>
<P>&nbsp;</P>
<P>Note:</P>
<P>The necessary jquery.js&nbsp;must be hostet on you integrity server.</P>
<P>&nbsp;</P>
<P>HTH</P>
<P>Matthias</P>Mon, 11 Sep 2017 15:43:38 GMThttps://community.ptc.com/t5/Windchill-Systems-Software/testresult-verdict-in-report/m-p/483802#M5525mrump2017-09-11T15:43:38Z