ClearQuest White Paper: Automation of sending a query result report through an email to specified users in Rational ClearQuest
This solution uses CQPerl as the scripting language and IBM Rational ClearQuest APIs.
This solution works in the following way:
Login to the ClearQuest Database
Run the specified query (which is pre-defined and uses static filters)
Redirect the result of the query to an html file in a tabular and readable format
- Email the generated html file to specified users.
Note : Further, this script can be scheduled using the Microsoft Windows Scheduler to be executed on a specified Day/Time.