Screen

Instructions

Additional Information

Query Properties Selection

System

Selected Object Properties

This screen enables you to choose the object properties to include in data query you are constructing.

...

       1.      Under System, navigate the database tree and click the object property you want to include.

       2.      Choose Add. The object property is displayed under Selected Object Properties.

Choose a selected object property and then Remove to undo a selection.

       3.      Repeat the above steps to include additional object properties in your query.

       4.      Choose Next.

The Distributed Query Engine supports the selection of object properties from multiple systems.

The Distributed Query Engine however does not check the logic of the query; this is the responsibility of the content creator.

Properties and Sorting in Result iView

This screen displays the object properties you selected in the previous step. Here you specify which properties are to be visible in the resulting iView, if a property is a link, and the sort order of the properties.

       5.      To render a property visible, or not, choose the property via the radio button and then choose the Toggle Visible button.

       6.      Choose whether or not the property is to serve as a link from the Link drop-down list. Select the link type (None, Object Based Navigation or Drag&Relate).

       7.      From the drop-down list labeled Sort Result iView by, choose the property by which the displayed result set will be sorted.

       8.      From the Sort Order list, choose Ascending or Descending.

Query Condition

Parameter

Value

Personalize

Query

This screen enables you to define query conditions, adding them to the WHERE clause, and define parameter values as required.

All parts of the query, which has been selected automatically, using selection lists and buttons, appear in the free text field at the bottom of the page. The query shown in this area is the query that is sent to the DQE.

       9.      From the Parameter list, select the property to add to the query condition and then choose the Add button below the Parameter field.

   10.      From the Operation list, select an operator, and then, if necessary, enter a value in the Value field. Choose the Add button below the Value field.

   11.      If you want to enable the user to enter a property value at runtime, give the property a name in the Personalize field and choose the Add button below the field.

   12.      Choose Next.

If you wish to resolve the condition against another property instead of a numerical value, select an operator, then another property and choose the Add button below the Parameter field.

Repeat these steps and form your query conditions as desired.

The Personalize attribute can be applied to multiple properties, as desired.

The end user of the resulting iView must choose the iView Personalize icon in order to enter a value for the property.

Writing free text:

The free text field, with buttons to the right for adding operators, also allows manual editing of the query, using all supported SQL functions. For more information, see Editing Queries.

Summary Details

   13.      Review the options defined for the new iView and choose Finish.

To make changes, choose Back until you return to the appropriate screen.

Next Step

   14.      Choose your next step and click OK.

·        You have the option of opening the object Property Editor at the end of the wizard.

The iView may need editing before it can be used as intended, for example enabling Drag&Relate.

If you want to define the new iView as a template, by setting the Object is a Template property to Yes.

   15.      You have the option of restarting the wizard to create a new iView.