The online community for software testing & quality assurance professionals
 
 
Calendar   Today's Topics
Sponsors:




Lost Password?

Home
BetaSoft
Blogs
Jobs
Training
News
Links
Downloads



Testing Tools >> Micro Focus/Compuware QADirector

Pages: 1
TraceyA
Newbie


Reged: 08/23/10
Posts: 2
QAD Reporting
      #639746 - 08/23/10 11:51 AM

I am attempting to create a report that includes a count of the script statuses for our test scripts. I.e. the number of scripts in the pass,fail, and Not Started status for a project. The Results / Script Results report has them listed but I see no way to add a count or a chart to the report.

I have decided to create a report that would pull data directly from the database, does anyone know what tables I should look at?

Thanks,
Tracey


Post Extras: Print Post   Remind Me!   Notify Moderator  
dwarlick
Member


Reged: 01/16/08
Posts: 131
Loc: North Carolina
Re: QAD Reporting [Re: TraceyA]
      #639889 - 08/24/10 08:59 AM

This is not as easy as it may look. I have created reports for our organization and it took several weeks of 'hacking' the db to determine how the different id are related. Here are some basic tables:
QAC_WB_Projects - General Project data
QAC_WB_Folders - General information on folders (Test, result)
QAC_WB_Assetdefinitions - IDS and names for the different asset types (Tests, EPs)
QAC_WB_SCRIPTDEFINITIONS - Basic script info
QAC_WB_EOSCRIPTRELATIONS - Project/EP/Test Script relationships.
How good are you at SQL scripting?

--------------------
don, CSTP, QAD/TP user since 06
Test Partner 6.3; QAD 6.1; QADLoad 5.9


Post Extras: Print Post   Remind Me!   Notify Moderator  
TraceyA
Newbie


Reged: 08/23/10
Posts: 2
Re: QAD Reporting [Re: dwarlick]
      #639902 - 08/24/10 10:43 AM

Thanks! I'll see what I can figure out with these.

I am comfortable with SQL Scripting but I am by no means an expert.

Tracey


Post Extras: Print Post   Remind Me!   Notify Moderator  
dwarlick
Member


Reged: 01/16/08
Posts: 131
Loc: North Carolina
Re: QAD Reporting [Re: TraceyA]
      #640034 - 08/25/10 08:52 AM

Let me know if you need any additional information.

don

--------------------
don, CSTP, QAD/TP user since 06
Test Partner 6.3; QAD 6.1; QADLoad 5.9


Post Extras: Print Post   Remind Me!   Notify Moderator  
JeffCull
Newbie


Reged: 06/01/11
Posts: 2
Re: QAD Reporting [Re: dwarlick]
      #679418 - 07/19/11 01:28 PM

I too am looking at going down the same path. That is reporting on the running of automated TP scripts from QAD.

Just wondering what successes people have had with this? The QAD API seems like is does not do much and the Database is cryptic to say the least.


Post Extras: Print Post   Remind Me!   Notify Moderator  
Pages: 1



Extra information
0 registered and 2 anonymous users are browsing this forum.

Moderator:  Jim Brennan, AJ, DSquared 

Print Topic

Forum Permissions
      You cannot start new topics
      You cannot reply to topics
      HTML is disabled
      UBBCode is enabled

Rating:
Topic views: 4620

Rate this topic

Jump to

Contact Us | Privacy statement SQAForums

Powered by UBB.threads™ 6.5.5