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