How to Pull deisgn step count for Manual & Business-P?rocess tests in alm by SQL query

  • Questions
  • How to Pull deisgn step count for Manual & Business-P?rocess tests in alm by SQL query
Question ID: 106144
0
0

Please Help me out!

Marked as spam
Posted by (Questions: 1, Answers: 1)
Asked on June 23, 2015 9:14 am
35 views
Answers (2)
0
Private answer

Here is an example of how to extract the manual test with his steps you can instead of select the DESSTEPS count them.

SELECT
TEST.TS_TEST_ID as ''Test ID'', /*Test.Test ID*/
TEST.TS_SUBJECT, /*Test.Subject*/
TEST.TS_NAME as ''Test Name'', /*Test.Test Name*/
TEST.TS_DESCRIPTION as ''Test Desc.'', /*Test.Description*/
DESSTEPS.DS_STEP_NAME as ''Step Name'', /*Design Step.Step Name*/
DESSTEPS.DS_DESCRIPTION as ''Step Desc.'', /*Design Step.Description*/
DESSTEPS.DS_EXPECTED as ''Expected Result'', /*Design Step.Expected Result*/
TEST.TS_STATUS as ''Test Status'', /*Test.Status*/
TEST.TS_TYPE ''Test Type'', /*Test.Type*/
TEST.TS_RESPONSIBLE as ''Test Designer'', /*Test.Designer*/
TEST.TS_USER_03 as ''Test Priority'', /*Test.Priority*/
TEST.TS_USER_04 as ''Test Reviewer'' /*Test.Reviewer*/

FROM
Test,
DESSTEPS

WHERE
DS_TEST_ID = TS_TEST_ID

Marked as spam
Posted by (Questions: 1, Answers: 4)
Answered on June 23, 2015 3:51 pm
0
Private answer

SELECT TEST.TS_TEST_ID as ''Test ID'', /*Test.Test ID*/
TEST.TS_NAME as ''Test Name'', /*Test.Test Name*/
TEST.TS_SUBJECT as ''Subject'',
TEST.TS_DESCRIPTION as ''Test Desc.'', /*Test.Description*/
TEST.TS_DEV_COMMENTS as ''Comments'',
TEST.TS_TYPE as ''Test Type'', /*Test.Type*/
COMPONENT_STEP.CS_STEP_NAME as ''Step Name'',
COMPONENT_STEP.CS_DESCRIPTION as ''Step Description'',
COMPONENT_STEP.CS_EXPECTED as ''Expected Results''

FROM ALL_LISTS
Left Join TEST on ALL_LISTS.AL_ITEM_ID=TEST.TS_SUBJECT
Left join BPTEST_TO_COMPONENTS on TEST.TS_TEST_ID=BPTEST_TO_COMPONENTS.BC_PARENT_ID
Left join COMPONENT_STEP on BPTEST_TO_COMPONENTS.BC_CO_ID=COMPONENT_STEP.CS_COMPONENT_ID

where
BC_PARENT_ID = TS_TEST_ID
AND AL_ITEM_ID = TS_SUBJECT
AND TS_SUBJECT = ALL_LISTS.AL_ITEM_ID
ORDER BY TS_TEST_ID

By using the above query I am getting the BPT Component steps but i want to get the count of them.
Please help me out

Marked as spam
Posted by (Questions: 1, Answers: 1)
Answered on June 23, 2015 5:16 pm