Home > Sources > ClearQuest

ClearQuest

Choosing ClearQuest from the Source list establishes ClearQuest as the source of data for a report. 




Schema

Enter the schema name of the ClearQuest® master database for this report.  This feature is ONLY needed if your installation of ClearQuest is configured with multiple master databases (schemas).  This configuration is user-specific: one person in a company may be required to enter a schema while another user at the same company doesn't have to enter it.

How to tell if you need to enter a Schema:

This field must be populated only if you are prompted to choose a schema when you open the ClearQuest application.  The prompt to choose a schema will occur BEFORE you are required to enter your ClearQuest login information (e.g. Database, User name, Password). Not all ClearQuest installations are configured with multiple schemas.

If you are prompted to choose a schema you must enter the schema chosen in the list in this field.

Note: Leave this field blank if you are not prompted to choose a schema when you open your ClearQuest application.


Database

Enter the name of the ClearQuest® database on which the report is built.


User Name

Enter the user name you normally use to log into ClearQuest®.  This may or may not be your operating system login.


Password

Enter the password you use to log into ClearQuest®.  This may or may not be the password you use to log into your operating system.


Query

This button is only activated when the Database, User Name and Password  fields are populated in the report. ReportsDNA uses that information to login into ClearQuest® and return all available queries in the dropdown to the right of the button.  Choose the query using the dropdown.


Dynamic Parameters

This option allows you to specify dynamic parameters used by your query.  The parameters must correspond to dynamic parameters in the query chosen in the Query field.  ClearQuest normally prompts you for these values when you execute the query in the ClearQuest application.  When you run the query using a ReportsDNA report, the comma-delimited values specified in the Dynamic Parameters setting will be passed directly to ClearQuest as the input.  Check the Prompt for Parameters checkbox if you want the report to prompt you every time you generate the report.


This field accepts variables which are interpreted at the time the report is generated.  Variables ARE case sensitive and are listed below:

Variable  Description
 [DATE]  Replaces the parameter with the date the report was generated
 [NOW]  Replaces the parameter with the date and time the report was generated



Example Parameters

Dynamic Parameter Interpretation Description
40 40 The parameter does not contain a variable; therefore, the value is a literal.
[DATE] 7/1/2007 [DATE] variable is replaced by the date the report was generated.
[NOW] 7/1/2007 20:15:30 [NOW] variable is replaced by date and time the report was generated.
[DATE]+2 7/3/2007 [DATE] variable plus 2 days.
[NOW]-3 6/28/2007 20:15:30 [NOW] constant minus 3 days.
[now] [now] The parameter does not contain a variable (variables are case-sensitive and  must be capitalized); therefore, the value is a literal.
20,40     20,40 Two parameters (the comma indicates two parameters)
resolved#closed resolved#closed One parameter that takes 2 values (the # sign indicates the values all belong to one parameter)

e.g., show all defects where the state in (resolved, closed)
[DATE]-7#[DATE],assigned#submitted#confirmed 6/24/2007#7/21/2007,
assigned#submitted#confirmed
Two parameters (separated by a comma)

The first parameter takes two values [DATE]-7 and [DATE]

The second parameter takes three values assigned,submitted,confirmed


ClearQuest Web Configuration

The ClearQuest Web Configuration is an optional feature. It enhances your report by adding a hyperlink to each record, which links to the record in ClearQuest's web interface.  This feature will be replaced in the future by the Hyperlink feature on the options tab.




Hyperlink Column

Click the column selector button to choose the field that will hyperlink to the record


Web Server

The web server used for ClearQuest Web. You can find it by viewing a record in ClearQuest Web and examining the url in your browser (Figure 8c).


Web Schema

The schema that contains your records. You can find it by viewing a record in ClearQuest Web and examining the url in your browser (Figure 8c).
Note: If you had to specify a schema earlier then this field should match it.



 


See also

Excel
Creating a Connection
Access-Database-External Data-File