Topic
  • 15 replies
  • Latest Post - ‏2012-04-11T04:35:25Z by SystemAdmin
RYV
RYV
17 Posts

Pinned topic Not able to fetch Test Case Result data from RQM

‏2012-03-26T08:55:46Z |
Hi,

I need to generate report of only failed test cases in RQM.

When I add feed and qm data source using REST, there is no field of test result under TEST CASE in QM data source.

What is the way that I can fetch test case result?

Thanks,
RYV
Updated on 2012-04-11T04:35:25Z at 2012-04-11T04:35:25Z by SystemAdmin
  • OanaHategan
    OanaHategan
    6 Posts

    Re: Not able to fetch Test Case Result data from RQM

    ‏2012-03-27T14:59:56Z  
    Hello,

    I had the same problem, so I decided to write a blog post about it.
    You can read all about it here: http://reportingarena.com/blog/extract-test-case-results-from-jazz-rqm-with-rpe-1-1-2

    Let me know how it went.

    Oana Hategan
    RPE Consultant - Reporting Arena Team Member
    www.reportingarena.com
  • RYV
    RYV
    17 Posts

    Re: Not able to fetch Test Case Result data from RQM

    ‏2012-03-28T06:22:49Z  
    Hello,

    I had the same problem, so I decided to write a blog post about it.
    You can read all about it here: http://reportingarena.com/blog/extract-test-case-results-from-jazz-rqm-with-rpe-1-1-2

    Let me know how it went.

    Oana Hategan
    RPE Consultant - Reporting Arena Team Member
    www.reportingarena.com
    Hi Oana,

    You have correctly understood my RPE issue.

    But using your template guidelines I am still not able to fetch test execution results.

    PFA template and console log.

    Could you please explain URI used for REST_qm. Currently I am giving following URL -
    https://01hw102361:9443/qm/service/com.ibm.rqm.integration.service.IIntegrationService/resources/FIRE+%28Quality+Management%29/executionresult+”?fields=feed/entry/content/testcase/*
    Please let me know where I am going wrong.

    Thanks in advance.

    ROHINI
  • OanaHategan
    OanaHategan
    6 Posts

    Re: Not able to fetch Test Case Result data from RQM

    ‏2012-03-30T10:08:43Z  
    • RYV
    • ‏2012-03-28T06:22:49Z
    Hi Oana,

    You have correctly understood my RPE issue.

    But using your template guidelines I am still not able to fetch test execution results.

    PFA template and console log.

    Could you please explain URI used for REST_qm. Currently I am giving following URL -
    https://01hw102361:9443/qm/service/com.ibm.rqm.integration.service.IIntegrationService/resources/FIRE+%28Quality+Management%29/executionresult+”?fields=feed/entry/content/testcase/*
    Please let me know where I am going wrong.

    Thanks in advance.

    ROHINI
    Hi Rohini,

    The problem is when you set the URI for the first Data Source Configuration element. You should set the URI as a simple value like this:
    https://01hw102361:9443/qm/service/com.ibm.rqm.integration.service.IIntegrationService/resources/FIRE+%28Quality+Management%29/executionresult?fields=feed/entry/content/testcase/*
    In my example, I was setting the URI as a JavaScript expression and that's why it was written differently.

    I attached the modified template.

    Regards,
    Oana

    RPE Consultant - Reporting Arena Team Member
    www.reportingarena.com

    Attachments

  • RYV
    RYV
    17 Posts

    Re: Not able to fetch Test Case Result data from RQM

    ‏2012-04-02T05:54:05Z  
    Hi Rohini,

    The problem is when you set the URI for the first Data Source Configuration element. You should set the URI as a simple value like this:
    https://01hw102361:9443/qm/service/com.ibm.rqm.integration.service.IIntegrationService/resources/FIRE+%28Quality+Management%29/executionresult?fields=feed/entry/content/testcase/*
    In my example, I was setting the URI as a JavaScript expression and that's why it was written differently.

    I attached the modified template.

    Regards,
    Oana

    RPE Consultant - Reporting Arena Team Member
    www.reportingarena.com
    Hi Oana,

    I tried with the URL you mentioned. But no luck Yet!!!

    I am getting same error log. I used the modified template you have given.Can you please test this template at your side.

    Please help. Not able to proceed.

    Thanks,
    ROHINI
  • OanaHategan
    OanaHategan
    6 Posts

    Re: Not able to fetch Test Case Result data from RQM

    ‏2012-04-02T08:58:38Z  
    • RYV
    • ‏2012-04-02T05:54:05Z
    Hi Oana,

    I tried with the URL you mentioned. But no luck Yet!!!

    I am getting same error log. I used the modified template you have given.Can you please test this template at your side.

    Please help. Not able to proceed.

    Thanks,
    ROHINI
    Hi,

    Please verify if the URL you provide for the Data Source Configuration element works in your browser.
    I ran your template with my URL and it worked fine.
    I noticed that you didn't configure the second configuration element with your Jazz credentials. You need to select the second Data Source Configuration element and enter your Jazz user name and password in the Properties panel.
    Also, you don't have to configure the two data sources in the dsx, because the two data source configuration elements you are using have the role of configuring the data sources at run time.
    I attached the template and dsx that worked for me. Please make sure you provide your jazz credentials for both of the data source configuration elements.

    Regards,
    Oana

    RPE Consultant - Reporting Arena Team Member
    www.reportingarena.com
  • RYV
    RYV
    17 Posts

    Re: Not able to fetch Test Case Result data from RQM

    ‏2012-04-02T12:27:01Z  
    Hi,

    Please verify if the URL you provide for the Data Source Configuration element works in your browser.
    I ran your template with my URL and it worked fine.
    I noticed that you didn't configure the second configuration element with your Jazz credentials. You need to select the second Data Source Configuration element and enter your Jazz user name and password in the Properties panel.
    Also, you don't have to configure the two data sources in the dsx, because the two data source configuration elements you are using have the role of configuring the data sources at run time.
    I attached the template and dsx that worked for me. Please make sure you provide your jazz credentials for both of the data source configuration elements.

    Regards,
    Oana

    RPE Consultant - Reporting Arena Team Member
    www.reportingarena.com
    Hey Oana,

    It worked!!

    But only thing is I am getting -
    com.ibm.rqm.execution.common.state.failed instead of just failed.

    I dragged & drop the state(string)attribute(As Value) from Rest_qm schema

    Please correct me if I am going wrong.

    Thanks,
    ROHINI
  • OanaHategan
    OanaHategan
    6 Posts

    Re: Not able to fetch Test Case Result data from RQM

    ‏2012-04-02T13:34:29Z  
    • RYV
    • ‏2012-04-02T12:27:01Z
    Hey Oana,

    It worked!!

    But only thing is I am getting -
    com.ibm.rqm.execution.common.state.failed instead of just failed.

    I dragged & drop the state(string)attribute(As Value) from Rest_qm schema

    Please correct me if I am going wrong.

    Thanks,
    ROHINI
    Hi Rohini,

    I am glad to hear it worked.
    No, you are not wrong. This is how the attribute in retrieved from RQM.
    I used the following JavaScript expression to extract only the last part of the string:

    var pos = state.lastIndexOf(".")
    var status = state
    if (pos > 0)
    {
    status = status.substr(pos+1)
    }
    status

    Regards,
    Oana

    RPE Consultant - Reporting Arena Team Member
    www.reportingarena.com
  • RYV
    RYV
    17 Posts

    Re: Not able to fetch Test Case Result data from RQM

    ‏2012-04-03T09:25:36Z  
    Hi Rohini,

    I am glad to hear it worked.
    No, you are not wrong. This is how the attribute in retrieved from RQM.
    I used the following JavaScript expression to extract only the last part of the string:

    var pos = state.lastIndexOf(".")
    var status = state
    if (pos > 0)
    {
    status = status.substr(pos+1)
    }
    status

    Regards,
    Oana

    RPE Consultant - Reporting Arena Team Member
    www.reportingarena.com
    Hi,

    Since I am not from JAVA background, I am not able to manipulate the Execution result string.

    Could you please tell any link which gives information regarding such manipulation of data retrieved from RPE.

    Thanks,
    ROHINI
  • OanaHategan
    OanaHategan
    6 Posts

    Re: Not able to fetch Test Case Result data from RQM

    ‏2012-04-03T11:32:51Z  
    • RYV
    • ‏2012-04-03T09:25:36Z
    Hi,

    Since I am not from JAVA background, I am not able to manipulate the Execution result string.

    Could you please tell any link which gives information regarding such manipulation of data retrieved from RPE.

    Thanks,
    ROHINI
    Hi Rohini,

    You can find more information and examples on how to use JavaScript functions in RPE here:
    http://reportingarena.com/blog/javascript-functions-to-create-complex-script-expressions-in-rpe/

    For more detailed RPE soultions, please contact our consultant at contact@reportingarena.com

    Regards,
    Oana

    RPE Consultant - Reporting Arena Team Member
    www.reportingarena.com
  • SystemAdmin
    SystemAdmin
    1299 Posts

    Re: Not able to fetch Test Case Result data from RQM

    ‏2012-04-09T07:36:36Z  
    Hi Rohini,

    I am glad to hear it worked.
    No, you are not wrong. This is how the attribute in retrieved from RQM.
    I used the following JavaScript expression to extract only the last part of the string:

    var pos = state.lastIndexOf(".")
    var status = state
    if (pos > 0)
    {
    status = status.substr(pos+1)
    }
    status

    Regards,
    Oana

    RPE Consultant - Reporting Arena Team Member
    www.reportingarena.com
    Hi Oana,

    As suggested by you

    I have tried to fetch execution result using the reference
    (*http://reportingarena.com/blog/extract-test-case-results-from-jazz-rqm-with-rpe-1-1-2/*.)

    I also tried using above defined java script for filteration. but still it is giving the same array of strings ("com.ibm.rqm.execution.common.state.passed") instead of just "passed"

    Please find attached snapshots for how I used the script and
    please let me know for corrections.

    Thanks a lot in Advance
    Sheetal
  • SystemAdmin
    SystemAdmin
    1299 Posts

    Re: Not able to fetch Test Case Result data from RQM

    ‏2012-04-09T09:09:39Z  
    Hi Rohini,

    I am glad to hear it worked.
    No, you are not wrong. This is how the attribute in retrieved from RQM.
    I used the following JavaScript expression to extract only the last part of the string:

    var pos = state.lastIndexOf(".")
    var status = state
    if (pos > 0)
    {
    status = status.substr(pos+1)
    }
    status

    Regards,
    Oana

    RPE Consultant - Reporting Arena Team Member
    www.reportingarena.com
    Hi Oana,

    I got it...

    Thanks Again..
    Sheetal
  • SystemAdmin
    SystemAdmin
    1299 Posts

    Re: Not able to fetch Test Case Result data from RQM

    ‏2012-04-09T09:35:03Z  
    Hi Rohini,

    I am glad to hear it worked.
    No, you are not wrong. This is how the attribute in retrieved from RQM.
    I used the following JavaScript expression to extract only the last part of the string:

    var pos = state.lastIndexOf(".")
    var status = state
    if (pos > 0)
    {
    status = status.substr(pos+1)
    }
    status

    Regards,
    Oana

    RPE Consultant - Reporting Arena Team Member
    www.reportingarena.com
    Hi Oana,

    Please tell me how to fetch report of only failed test cases.
    Thanks

    Sheetal
  • OanaHategan
    OanaHategan
    6 Posts

    Re: Not able to fetch Test Case Result data from RQM

    ‏2012-04-09T10:30:41Z  
    Hi Oana,

    Please tell me how to fetch report of only failed test cases.
    Thanks

    Sheetal
    Hi Sheetal,

    You need to use a JavaScript condition based on the state attribute of each execution result.
    You can learn how to use javascript functions to create complex conditions in RPE here :
    http://reportingarena.com/blog/javascript-functions-to-create-complex-script-expressions-in-rpe

    Regards,

    Oana Hategan
    RPE Consultant - Reporting Arena Team Member
    www.reportingarena.com
  • SystemAdmin
    SystemAdmin
    1299 Posts

    Re: Not able to fetch Test Case Result data from RQM

    ‏2012-04-09T12:44:31Z  
    Hi Sheetal,

    You need to use a JavaScript condition based on the state attribute of each execution result.
    You can learn how to use javascript functions to create complex conditions in RPE here :
    http://reportingarena.com/blog/javascript-functions-to-create-complex-script-expressions-in-rpe

    Regards,

    Oana Hategan
    RPE Consultant - Reporting Arena Team Member
    www.reportingarena.com
    Hi Oana,

    Thanks for reply.

    I have tried to extract test result using

    http://reportingarena.com/blog/extract-test-case-results-from-jazz-rqm-with-rpe-1-1-2/

    I am able to get it perfectly but now I want to generate report of only failed test cases. I have tried some hands on with java script but no luck yet.

    Actually am not aware with Java scripts. can you please direct me in this.

    Thanks and bye

    With Warm Regards

    Sheetal
  • SystemAdmin
    SystemAdmin
    1299 Posts

    Re: Not able to fetch Test Case Result data from RQM

    ‏2012-04-11T04:35:25Z  
    Hi Sheetal,

    You need to use a JavaScript condition based on the state attribute of each execution result.
    You can learn how to use javascript functions to create complex conditions in RPE here :
    http://reportingarena.com/blog/javascript-functions-to-create-complex-script-expressions-in-rpe

    Regards,

    Oana Hategan
    RPE Consultant - Reporting Arena Team Member
    www.reportingarena.com
    Hi Oana,

    I tried to fetch only failed results.
    I tried following script
    state == "com.ibm.rqm.execution.common.state.failed"

    with this it is giving the entries which contain failed result and the entries which are of passed result are coming as an empty cell.

    But the report which I require is only failed entries. That is rows of passed entries should not come into report or we can say rows of passed entries need to be deleted before report generation.

    Please find template for reference.

    Any guidance in this direction would be of great help.
    Thanks & Regards

    Sheetal...