Support

Expand all | Collapse all

Unable to find the Result and Status fields in the JAMA database

  • 1.  Unable to find the Result and Status fields in the JAMA database

    Posted 07-16-2018 09:32
      |   view attached
    Hi Team,

    Could you please help me in finding where the "Result" and "Status" columns in the TEST RUN screen are stored in the JAMA Backend Database?
    thumbnail image
    Looking for the highlighted fields in JAMA Database.

    Iam querying the STEPITEM table but these 2 columns are having NULL values in the database though there is a value that I see on the JAMA application screen.
    My JAMA database is on MySQL. Here is a sample query Iam using:


    SELECT document.*,testrunset.* ,stepitem.*
    FROM contour_dryrun.document
    join contour_dryrun.testrunset
    join contour_dryrun.testset
    join contour_dryrun.testsetcase
    join contour_dryrun.stepitem
    where document.globalId=2134933
    and document.documentKey='UHIP-TSTRN-905518'
    and testrunset.testSetId = testset.id
    and testsetcase.testSetId = testrunset.testSetId
    and testsetcase.testcaseid = document.testCaseId
    and testrunset.id = document.testrunsetid
    and document.active = 'T'
    and documentTypeId = 37
    and stepitem.testCaseId = document.testCaseId
    ;

    ------------------------------
    Mukram M
    ------------------------------


  • 2.  RE: Unable to find the Result and Status fields in the JAMA database

    Posted 07-16-2018 12:14
    Mukram:

    I would like to point you to our Jama Schema but, for security reasons, I need you to change your membership email to your business URL email which will confirm that you are a current customer of Jama. Once you do that, you should have access to the information you need on the Community.

    Thank you,

    ------------------------------
    Chloe Elliott
    Business Support Engineer
    ------------------------------



  • 3.  RE: Unable to find the Result and Status fields in the JAMA database

    Posted 07-16-2018 12:52
    Hi Chloe,

    I have updated my email. Could you please refer me to the JAMA schema so that I could access the Result and Status columns in the JAMA Database. I would appreciate if you could also let me know if my SQL here is correct.

    Regards,
    Mukram

    ------------------------------
    Mukram M
    ------------------------------



  • 4.  RE: Unable to find the Result and Status fields in the JAMA database

    Posted 07-16-2018 13:05
    Great, in the Header section in The Community:  Support (dropdown) > Database Schema.

    It might take the system a day to recognize the changes to your email so you may not see it right away. If this is the case, check back in tomorrow morning. It should be available then.

    Happy Queries!

    ------------------------------
    Chloe Elliott
    Business Support Engineer
    ------------------------------



  • 5.  RE: Unable to find the Result and Status fields in the JAMA database

    Posted 07-17-2018 13:24
      |   view attached
    Thanks Chloe.

    I have gone through the schema diagrams but still unable to locate the table/column where I could find the values in the RESULT field in the attached screenshot. I was hoping that I could find this in the STEPITEM table but I was wrong. I have even done a search in the schema for the string "Case # 500727486 in PRODP" but could not find any results.
    Is this field something that is not stored in the database?


    Regards,

    ------------------------------
    Mukram M
    ------------------------------



  • 6.  RE: Unable to find the Result and Status fields in the JAMA database

    Posted 07-17-2018 14:20
    Mukram:

    We do not support direct manipulation of the database. Can I ask why you are doing this?

    ------------------------------
    Chloe Elliott
    Business Support Engineer
    ------------------------------



  • 7.  RE: Unable to find the Result and Status fields in the JAMA database

    Posted 07-17-2018 14:56
    There is an internal project requirement to update the status of each of the test steps in the JAMA test cases whenever our validation batches run successfully. Right now the test steps are manually being marked as PASSED after the batch executions.

    ------------------------------
    Mukram M
    ------------------------------



  • 8.  RE: Unable to find the Result and Status fields in the JAMA database

    Posted 07-18-2018 09:11
    Mukram:

    We really do not support and/or recommend directly manipulating your database to update these test statuses. I strongly recommend, assuming you are in Jama 8.x, that you utilize our REST API instead.

    Thank you,

    ------------------------------
    Chloe Elliott
    Business Support Engineer
    ------------------------------



  • 9.  RE: Unable to find the Result and Status fields in the JAMA database

    Posted 07-18-2018 12:33
    Thank you very much for your help Chloe. I will check out this alternative.

    ------------------------------
    Mukram M
    ------------------------------