www.softwaretestforum.dk Forum Index www.softwaretestforum.dk
Virtuelle netværks forum for dem som arbejder professionelt med QA og software test
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Erfaringer/gode resultater med Excel Reports?

 
Post new topic   Reply to topic    www.softwaretestforum.dk Forum Index -> Quality Center
View previous topic :: View next topic  
Author Message
Søren Kelstrup
Bruger på niveau 1
Bruger på niveau 1


Joined: 27 Jul 2008
Posts: 8
Location: København

PostPosted: Mon Aug 06, 2012 9:31 pm    Post subject: Erfaringer/gode resultater med Excel Reports? Reply with quote

Hej

Er her nogen, der benytter dataudtræk til Excel i deres daglige omgang med QC/ALM 11?

Mvh
Søren
Back to top
View user's profile Send private message Send e-mail
Søren Kelstrup
Bruger på niveau 1
Bruger på niveau 1


Joined: 27 Jul 2008
Posts: 8
Location: København

PostPosted: Fri Aug 10, 2012 12:35 pm    Post subject: Reply with quote

Fx denne her, hvis man gerne vil have en liste over defects med tilstanden "klar til gentest" og testcases, der er linket til dem:

SELECT
BUG.BG_BUG_ID AS DefectID,
BUG.BG_SEVERITY AS Severity,
BUG.BG_STATUS AS DefectStatus,
ALL_LISTS.AL_DESCRIPTION as Subject,
CYCLE.CY_CYCLE AS TestSet,
TEST.TS_NAME AS TestCase,
TESTCYCL.TC_STATUS AS Status

FROM BUG, TEST, V_LINK_TESTCYCL, TESTCYCL, CYCLE, ALL_LISTS

WHERE BUG.BG_BUG_ID = V_LINK_TESTCYCL.LN_BUG_ID
AND TESTCYCL.TC_TESTCYCL_ID = V_LINK_TESTCYCL.LN_TESTCYCL_ID
AND TESTCYCL.TC_TEST_ID = TEST.TS_TEST_ID
AND CYCLE.CY_CYCLE_ID = TESTCYCL.TC_CYCLE_ID
and BUG.BG_STATUS = 'Klar til gentest'
and TS_SUBJECT = AL_ITEM_ID
Back to top
View user's profile Send private message Send e-mail
Lars Kjølholm
Bruger på niveau 3
Bruger på niveau 3


Joined: 18 Jan 2008
Posts: 34
Location: Allerød, Denmark

PostPosted: Wed Aug 22, 2012 9:53 am    Post subject: Reply with quote

Ja, jeg benytter Excel-rapportering - godt nok i QC version 10.

Det giver nemlig rigtig gode muligheder for at lave pivot-tabeller og langt mere frihed til at lave grafer.

Det store MEN er blot, at det kræver stor viden om tabeller i Quality Center (som dit eksempel også viser).
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    www.softwaretestforum.dk Forum Index -> Quality Center All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group