<< Click to Display Table of Contents >>

Add dataset

CLEAR QUEST dataset can be added to the Design view mode and Manual mode.

Design view mode - record type

1.Creates a CLEAR QUEST dataset in association with CLEAR QUEST record type.

2.Select [Add Dataset] from the right mouse click popup menu on the store you created under  [CLEAR QUEST] in OZ data window. Select [Record Type] tab in the Add ClearQuest Dataset dialog.

3.Enter dataset name in Add ClearQuest Dataset dialog, select the record type to connect, and click [OK]. Dataset will be added and the user can configure dataset in [Query] tab.

4.Select fields from the [Available fields] list and add them to [Selected fields] list using ([Add], [Delete]) buttons and set the order of fields using ([Up], [Down]) buttons.

5.After adding from [Available fields] list to [Selected Filter] list, select field using ([Add], [Delete]) buttons and change the operator of selected field using operator buttons ([OR], [AND]).

6.To set values in the filter condition, enter the value by yourself or use the parameter wizard.

7.After finishing with options, run the query by [Run Query] button on the toolbar.

Design view mode - workspace

1.Creates a CLEAR QUEST dataset in association with CLEAR QUEST workspace.

2.Select [Add Dataset] from the right mouse click popup menu on the store you created under  [CLEAR QUEST] in OZ data window. Select [Workspace] tab in the Add ClearQuest Dataset dialog.

3.Enter dataset name in Add ClearQuest Dataset dialog, select the workspace to connect, and click [OK]. Dataset will be added and the user can configure dataset in [Query] tab.

4.After finishing with options, run the query by [Run Query] button on the toolbar.

Manual mode

1.Select [Add Dataset] from the right mouse click popup menu on the store you created under [CLEAR QUEST] in OZ data window.

2.Enter dataset name in the Add ClearQuest Dataset dialog.

3.Enter SQL in the [Query] tab.

4.Run the query by [Run Query] button on the toolbar.