Home > Sources > ClearQuest
ClearQuestChoosing ClearQuest from the Source list establishes ClearQuest as the source of data for a report.
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.
Enter the name of the ClearQuest® database on which the report is built.
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.
|[DATE]||Replaces the parameter with the date the report was generated|
|[NOW]||Replaces the parameter with the date and time the report was generated|
|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)
|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
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.
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
Note: If you had to specify a schema earlier then this field should match it.