Paul: Created page with "'''ClearQuest Dynamic List Editor''' === Manual Setup of a ClearQuest Schema === It is highly recommended to test the procedure in your development environment, an..."

2013-06-16T18:16:38Z

Created page with "<big>'''ClearQuest Dynamic List Editor'''</big> === Manual Setup of a ClearQuest Schema === It is highly recommended to test the procedure in your development environment, an..."

New page

<big>'''ClearQuest Dynamic List Editor'''</big>

=== Manual Setup of a ClearQuest Schema ===
It is highly recommended to test the procedure in your development environment, and backup master and user databases before you start.

==== Schema Integration ====
The schema integration, "Dynamic_List_Editor.txt", is locate in the "data" folder of the installation directory. It is a text file that can be easily scanned or inspected.

==== Apply Integration to ClearQuest Schema ====
* Verify that the ClearQuest schema is checked in, and that there are no pending schema changes that have not been applied to the user database.
* Open the command line tool, (Start->Run "cmd") and change the directory to the location where the integration package was extracted.
* Import integration using the "cqload importintegration" command. For example:
cqload importintegration -dbset <db_connection_name> <admin_user> <admin_password> <ClearQuest_Schema_Name> "" "Dynamic List Editor" 1.0 Dynamic_List_Editor.txt ""
* Verify that the schema update was imported and no issues were detected.

[[File:cqload_completed.png|center]]

==== Upgrade User Database ====
Now, you can apply changes to the user database using ClearQuest Designer. For Eclipse Designer, in the ClearQuest Database Admin section, right click on the user database that you are going to apply changes to, and select "Upgrade Database" from the context menu. (In legacy Windows Designer, select the "Upgrade Database..." option from the database menu and select your user database).

[[File:upgrade_db.png|center]]

Apply the change that you imported on the previous step by clicking the "OK" button. Verify that user database was upgraded successfully.

[[File:upgrade_db_completed.png|center]]

==== Import First Dynamic List ====
The rest of the configuration can be completed from a ClearQuest client. You can use any client of your choice. The instructions are based on ClearQuest Web client, version 8.0.
Login as an administrator (super user), and submit a new record of the "Dynamic_List" type:

[[File:Submit_Dynamic_List_1.png|center]]

Select one of the list names from the "Name" drop-down list.

[[File:Submit_Dynamic_List_2.png|center]]

Dynamic list values will be populated automatically.

[[File:Submit_Dynamic_List_3.png|center]]

click "Save" to commit the record to the database

==== Creating Dynamic List Administration Query ====
Now, you will need to create a simple query that will be used by Dynamic Lists administrators. Right click on the folder you are going to save the query to, and select "New Query" from the context menu.

[[File:Dynamic_List_Query _1.png|center]]

Select "Dynamic_Query" as a record type

[[File:Dynamic_List_Query _2.png|center]]

Provide a query name (for instance, "Dynamic Lists"), add the "Name" field to the presentation/display section, and specify the "Ascending" (A-Z) sort order. Save the query.

[[File:Dynamic_List_Query _3.png|center]]

==== Importing Dynamic Lists ====
Run the "Dynamic Lists" query that we created on the previous step. You should see one Dynamic List record in the result set. Select the record, and in the "Utilities" section, chose the "SyncAllLists" action.

[[File:Dynamic_List_Sync_1.png|center]]

The action syncs ClearQuest records with the correspondent dynamic lists:
* when the ClearQuest record already exists, its content is updated from the dynamic list
* when the ClearQuest record does not exist, a new record is created
* when a dynamic list for the existing ClearQuest record does not exist, the record is deleted.

[[File:Dynamic_List_Sync_2.png|center]]

If no error occurred, a confirmation is displayed. Otherwise, you would see an error message.
Refresh the query to verify that all dynamic lists with their proper content are loaded.

[[File:Dynamic_List_Sync_3.png|center]]

== Support ==
: ClearQuest Dynamic List Editor is supported by [http://cqadmin.com CQAdmin, inc]. Three levels or support agreement are currently offered, starting with '''free''' community support at [http://forum.cqadmin.org http://forum.cqadmin.org]. Consulting services are also available.

[[Category:Rational]] [[Category:ClearQuest]] [[Category:Dynamic_List_Editor]]

ClearQuest Dynamic List Editor ManualSetup - Revision history

Paul: Created page with "'''ClearQuest Dynamic List Editor''' === Manual Setup of a ClearQuest Schema === It is highly recommended to test the procedure in your development environment, an..."