Hi James,
You are right, the TestingCycleState column was added in SC 18.0. Quick fix for an older database is to just remove all references to the column from the queries. If you need the testing cycle state then the queries get a bit more complex:
--1
SELECT tcs.TesterLogin, etn.NodeName TestingCycleName, cycleStates.CycleState,
SUM(tcs.PassedCount) PassedCount, SUM(tcs.FailedCount) FailedCount, SUM(tcs.NotExecutedCount) NotExecutedCount
FROM RV_TestingCycleStatus tcs
INNER JOIN TM_ExecTreeNodes etn ON tcs.TestingCycleID = etn.NodeID_pk
INNER JOIN (
SELECT NodeID_pk CycleID,
CASE WHEN MaxStatus = 0 THEN 'Planned' WHEN MaxStatus = 7 THEN 'Running' ELSE 'Finished' END CycleState
FROM (
SELECT cycle.NodeID_pk, MAX(COALESCE(edr.Status, 0)) MaxStatus
FROM TM_ExecTreeNodes cycle
LEFT JOIN TM_ExecTreeNodes cycleChild ON cycleChild.ParentFolderID_fk = cycle.NodeID_pk
LEFT JOIN TM_ExecDefinitionRuns edr ON edr.ExecDefID_fk = cycleChild.NodeID_pk
WHERE cycle.AvailableTimeInCycle IS NOT NULL AND cycle.IsArchived = 0
AND (cycleChild.NodeID_pk IS NULL OR cycleChild.IsArchived = 0)
AND edr.ExecServerID_fk IS NULL AND edr.ExecServerName IS NULL
GROUP BY cycle.NodeID_pk
) statusMapping
) cycleStates ON tcs.TestingCycleID = cycleStates.CycleID
WHERE ProjectID = ${$PROJECTID} AND tcs.TesterLogin IS NOT NULL
GROUP BY TesterLogin, etn.NodeName, cycleStates.CycleState
ORDER BY TesterLogin, etn.NodeName
--2
SELECT enu.UserID_pk_fk TesterID, tc.NodeName TestingCycleName, cycleStates.CycleState,
COUNT(edtd.TestDefID_pk_fk) NrOfTests
FROM TM_ExecNodes_Users enu
INNER JOIN TM_ExecDefs_TestDefs edtd ON enu.ExecNodeID_pk_fk = edtd.ExecDefID_pk_fk
INNER JOIN TM_ExecTreeNodes tcChild ON enu.ExecNodeID_pk_fk = tcChild.NodeID_pk
INNER JOIN TM_ExecTreeNodes tc ON tcChild.ParentFolderID_fk = tc.NodeID_pk
INNER JOIN (
SELECT NodeID_pk CycleID,
CASE WHEN MaxStatus = 0 THEN 'Planned' WHEN MaxStatus = 7 THEN 'Running' ELSE 'Finished' END CycleState
FROM (
SELECT cycle.NodeID_pk, MAX(COALESCE(edr.Status, 0)) MaxStatus
FROM TM_ExecTreeNodes cycle
LEFT JOIN TM_ExecTreeNodes cycleChild ON cycleChild.ParentFolderID_fk = cycle.NodeID_pk
LEFT JOIN TM_ExecDefinitionRuns edr ON edr.ExecDefID_fk = cycleChild.NodeID_pk
WHERE cycle.AvailableTimeInCycle IS NOT NULL AND cycle.IsArchived = 0
AND (cycleChild.NodeID_pk IS NULL OR cycleChild.IsArchived = 0)
AND edr.ExecServerID_fk IS NULL AND edr.ExecServerName IS NULL
GROUP BY cycle.NodeID_pk
) statusMapping
) cycleStates ON tc.NodeID_pk = cycleStates.CycleID
WHERE tc.ProjectID_fk = ${$PROJECTID}
GROUP BY enu.UserID_pk_fk, tc.NodeName, cycleStates.CycleState
ORDER BY enu.UserID_pk_fk, tc.NodeName
Regards,
Hubert
