Support

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?
<g class="gr_ gr_286 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="286" data-gr-id="286">Iam</g> 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 <g class="gr_ gr_224 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="224" data-gr-id="224">Iam</g> 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
------------------------------

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
------------------------------

Original Message:
Sent: 07-16-2018 12:31
From: Mukram M
Subject: Unable to find the Result and Status fields in the JAMA database

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?

Looking for the highlighted fields in <g class="gr_ gr_187 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar only-ins replaceWithoutSep" id="187" data-gr-id="187">JAMA</g> Database.

<g class="gr_ gr_286 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="286" data-gr-id="286">Iam</g> 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 <g class="gr_ gr_224 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="224" data-gr-id="224">Iam</g> 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
------------------------------

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
------------------------------

Original Message:
Sent: 07-16-2018 15:13
From: Chloe Elliott
Subject: Unable to find the Result and Status fields in the JAMA database

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

Original Message:
Sent: 07-16-2018 12:31
From: Mukram M
Subject: Unable to find the Result and Status fields in the JAMA database

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?

Looking for the highlighted fields in <g class="gr_ gr_187 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar only-ins replaceWithoutSep" id="187" data-gr-id="187">JAMA</g> Database.

<g class="gr_ gr_286 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="286" data-gr-id="286">Iam</g> 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 <g class="gr_ gr_224 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="224" data-gr-id="224">Iam</g> 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
------------------------------

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
------------------------------

Original Message:
Sent: 07-16-2018 15:51
From: Mukram M
Subject: Unable to find the Result and Status fields in the JAMA database

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

Original Message:
Sent: 07-16-2018 15:13
From: Chloe Elliott
Subject: Unable to find the Result and Status fields in the JAMA database

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

Original Message:
Sent: 07-16-2018 12:31
From: Mukram M
Subject: Unable to find the Result and Status fields in the JAMA database

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?

Looking for the highlighted fields in <g class="gr_ gr_187 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar only-ins replaceWithoutSep" id="187" data-gr-id="187">JAMA</g> Database.

<g class="gr_ gr_286 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="286" data-gr-id="286">Iam</g> 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 <g class="gr_ gr_224 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="224" data-gr-id="224">Iam</g> 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
------------------------------

Thanks <g class="gr_ gr_15 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation only-ins replaceWithoutSep" id="15" data-gr-id="15">Chloe</g>.

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 <g class="gr_ gr_198 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="198" data-gr-id="198">PRODP</g>" but could not find any results.
Is this field something that is not stored in the database?


Regards,

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

Original Message:
Sent: 07-16-2018 16:05
From: Chloe Elliott
Subject: Unable to find the Result and Status fields in the JAMA database

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

Original Message:
Sent: 07-16-2018 15:51
From: Mukram M
Subject: Unable to find the Result and Status fields in the JAMA database

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

Original Message:
Sent: 07-16-2018 15:13
From: Chloe Elliott
Subject: Unable to find the Result and Status fields in the JAMA database

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

Original Message:
Sent: 07-16-2018 12:31
From: Mukram M
Subject: Unable to find the Result and Status fields in the JAMA database

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?

Looking for the highlighted fields in <g class="gr_ gr_187 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar only-ins replaceWithoutSep" id="187" data-gr-id="187">JAMA</g> Database.

<g class="gr_ gr_286 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="286" data-gr-id="286">Iam</g> 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 <g class="gr_ gr_224 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="224" data-gr-id="224">Iam</g> 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
------------------------------

Mukram:

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

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

Original Message:
Sent: 07-17-2018 16:24
From: Mukram M
Subject: Unable to find the Result and Status fields in the JAMA database

Thanks <g class="gr_ gr_15 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation only-ins replaceWithoutSep" id="15" data-gr-id="15">Chloe</g>.

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 <g class="gr_ gr_198 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="198" data-gr-id="198">PRODP</g>" but could not find any results.
Is this field something that is not stored in the database?


Regards,

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

Original Message:
Sent: 07-16-2018 16:05
From: Chloe Elliott
Subject: Unable to find the Result and Status fields in the JAMA database

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

Original Message:
Sent: 07-16-2018 15:51
From: Mukram M
Subject: Unable to find the Result and Status fields in the JAMA database

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

Original Message:
Sent: 07-16-2018 15:13
From: Chloe Elliott
Subject: Unable to find the Result and Status fields in the JAMA database

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

Original Message:
Sent: 07-16-2018 12:31
From: Mukram M
Subject: Unable to find the Result and Status fields in the JAMA database

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?

Looking for the highlighted fields in <g class="gr_ gr_187 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar only-ins replaceWithoutSep" id="187" data-gr-id="187">JAMA</g> Database.

<g class="gr_ gr_286 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="286" data-gr-id="286">Iam</g> 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 <g class="gr_ gr_224 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="224" data-gr-id="224">Iam</g> 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
------------------------------

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
------------------------------

Original Message:
Sent: 07-17-2018 17:20
From: Chloe Elliott
Subject: Unable to find the Result and Status fields in the JAMA database

Mukram:

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

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

Original Message:
Sent: 07-17-2018 16:24
From: Mukram M
Subject: Unable to find the Result and Status fields in the JAMA database

Thanks <g class="gr_ gr_15 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation only-ins replaceWithoutSep" id="15" data-gr-id="15">Chloe</g>.

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 <g class="gr_ gr_198 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="198" data-gr-id="198">PRODP</g>" but could not find any results.
Is this field something that is not stored in the database?


Regards,

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

Original Message:
Sent: 07-16-2018 16:05
From: Chloe Elliott
Subject: Unable to find the Result and Status fields in the JAMA database

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

Original Message:
Sent: 07-16-2018 15:51
From: Mukram M
Subject: Unable to find the Result and Status fields in the JAMA database

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

Original Message:
Sent: 07-16-2018 15:13
From: Chloe Elliott
Subject: Unable to find the Result and Status fields in the JAMA database

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

Original Message:
Sent: 07-16-2018 12:31
From: Mukram M
Subject: Unable to find the Result and Status fields in the JAMA database

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?

Looking for the highlighted fields in <g class="gr_ gr_187 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar only-ins replaceWithoutSep" id="187" data-gr-id="187">JAMA</g> Database.

<g class="gr_ gr_286 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="286" data-gr-id="286">Iam</g> 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 <g class="gr_ gr_224 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="224" data-gr-id="224">Iam</g> 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
------------------------------

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
------------------------------

Original Message:
Sent: 07-17-2018 17:55
From: Mukram M
Subject: Unable to find the Result and Status fields in the JAMA database

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

Original Message:
Sent: 07-17-2018 17:20
From: Chloe Elliott
Subject: Unable to find the Result and Status fields in the JAMA database

Mukram:

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

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

Original Message:
Sent: 07-17-2018 16:24
From: Mukram M
Subject: Unable to find the Result and Status fields in the JAMA database

Thanks <g class="gr_ gr_15 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation only-ins replaceWithoutSep" id="15" data-gr-id="15">Chloe</g>.

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 <g class="gr_ gr_198 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="198" data-gr-id="198">PRODP</g>" but could not find any results.
Is this field something that is not stored in the database?


Regards,

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

Original Message:
Sent: 07-16-2018 16:05
From: Chloe Elliott
Subject: Unable to find the Result and Status fields in the JAMA database

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

Original Message:
Sent: 07-16-2018 15:51
From: Mukram M
Subject: Unable to find the Result and Status fields in the JAMA database

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

Original Message:
Sent: 07-16-2018 15:13
From: Chloe Elliott
Subject: Unable to find the Result and Status fields in the JAMA database

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

Original Message:
Sent: 07-16-2018 12:31
From: Mukram M
Subject: Unable to find the Result and Status fields in the JAMA database

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?

Looking for the highlighted fields in <g class="gr_ gr_187 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar only-ins replaceWithoutSep" id="187" data-gr-id="187">JAMA</g> Database.

<g class="gr_ gr_286 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="286" data-gr-id="286">Iam</g> 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 <g class="gr_ gr_224 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="224" data-gr-id="224">Iam</g> 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
------------------------------

Thank you very much for your help <g class="gr_ gr_82 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation only-ins replaceWithoutSep" id="82" data-gr-id="82">Chloe</g>. I will check out this alternative.

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

Original Message:
Sent: 07-18-2018 12:11
From: Chloe Elliott
Subject: Unable to find the Result and Status fields in the JAMA database

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

Original Message:
Sent: 07-17-2018 17:55
From: Mukram M
Subject: Unable to find the Result and Status fields in the JAMA database

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

Original Message:
Sent: 07-17-2018 17:20
From: Chloe Elliott
Subject: Unable to find the Result and Status fields in the JAMA database

Mukram:

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

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

Original Message:
Sent: 07-17-2018 16:24
From: Mukram M
Subject: Unable to find the Result and Status fields in the JAMA database

Thanks <g class="gr_ gr_15 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation only-ins replaceWithoutSep" id="15" data-gr-id="15">Chloe</g>.

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 <g class="gr_ gr_198 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="198" data-gr-id="198">PRODP</g>" but could not find any results.
Is this field something that is not stored in the database?


Regards,

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

Original Message:
Sent: 07-16-2018 16:05
From: Chloe Elliott
Subject: Unable to find the Result and Status fields in the JAMA database

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

Original Message:
Sent: 07-16-2018 15:51
From: Mukram M
Subject: Unable to find the Result and Status fields in the JAMA database

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

Original Message:
Sent: 07-16-2018 15:13
From: Chloe Elliott
Subject: Unable to find the Result and Status fields in the JAMA database

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

Original Message:
Sent: 07-16-2018 12:31
From: Mukram M
Subject: Unable to find the Result and Status fields in the JAMA database

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?

Looking for the highlighted fields in <g class="gr_ gr_187 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar only-ins replaceWithoutSep" id="187" data-gr-id="187">JAMA</g> Database.

<g class="gr_ gr_286 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="286" data-gr-id="286">Iam</g> 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 <g class="gr_ gr_224 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="224" data-gr-id="224">Iam</g> 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
------------------------------