Creating custom schema values for output parameters

When you define output parameters that use the DirectSQL, Array of Impact Object, or Impact Object format in the user output parameters editor, you also must specify a name and a format for each field that is contained in the DirectSQL, Array of Impact Object, or Impact Object objects.

About this task

Custom schema definitions are used by Netcool®/Impact to visualize data in the console and to pass values to the UI data provider and OSLC. You create the custom schemas and select the format that is based on the values for each field that is contained in the object. For example, you create a policy that contains two fields in an object:
O1.city="NY" 
O1.ZIP=07002
You define the following custom schemas values for this policy:
Table 1. Custom schema values for City
Field Entry
Name City
Format String
Table 2. Custom schema values for ZIP
Field Entry
Name ZIP
Format Integer

If you use the DirectSQL policy function with the UI data provider or OSLC, you must define a custom schema value for each DirectSQL value that you use.

If you want to use the chart widget to visualize data from an Impact object or an array of Impact objects with the UI data provider and the console, you define custom schema values for the fields that are contained in the objects. The custom schemas help to create descriptors for columns in the chart during initialization. However, the custom schemas are not technically required. If you do not define values for either of these formats, the system later rediscovers each Impact object when it creates additional fields such as the key field. UIObjectId, or the field for the tree widget, UITreeNodeId. You do not need to define these values for OSLC.

Procedure

  1. In the Policy Settings Editor, select DirectSQL, Impact Object, or Array of Impact Object in the Format field.
  2. The system shows the Open the Schema Definition Editor icon Icon for Open the Schema Definition Editor beside the Schema Definition field. To open the editor, click the icon.
  3. You can edit an existing entry or you can create a new one. To define a new entry, click New. Enter a name and select an appropriate format.

    To edit an existing entry, click the Edit icon beside the entry that you want to edit

  4. To mark an entry as a key field, select the check box in the Key Field column. You do not have to define the key field for Impact objects or an array of Impact objects. The system uses the UIObjectId as the key field instead.
  5. To delete an entry, select the entry and click Delete.