This describes the fields in the REPEAT command dialog box. For information on using REPEAT commands, see REPEAT Command.
The Select area is used to identify the n-ary relationship that you want to use to repeat the section. At the first level of the tree control are the commands that are in the context of the REPEAT command. When you expand one of these you will see N-ary relationships for that class of objects. To select one of these, click the name.
The remaining options are unary relationships. When you expand any of these lines, you have additional n-ary (and possibly unary) relationships as choices.
The Where Is A list box lets you limit the results of the REPEAT command to only those objects in a particular class. To limit the results, select a class from the list.
The Name text box is used to specify a name for your repeated section. Every REPEAT command must have a name, and the name must be unique within the current scope. The name can consist of letters, numbers, and underscores. By default, the name of the REPEAT command matches the name of the class selected in the Where Is A list box.
NOTE: Use this selection only when you select the intra-page Artifact Section hyperlink option in the DISPLAY dialog box.
When you select this check box, ProjectConsole Template Builder creates a unique Word bookmark as part of every linked section. Use this option in conjunction with the Create Hyperlink option in the DISPLAY Command Dialog Box to create hypertext cross-references. When you create the Web page, these cross-references become hypertext references and anchors.
The And Where area (visible only when Advanced is checked) lets you limit the results of the REPEAT command to only those objects that satisfy a given expression. To create an expression, choose "Click here to add" below the Left Operand. In the tree control, select an attribute to serve as the left half of the expression. Use the Operator column to select an operator. Finally, choose "Click here to add" below the Right operand. The right operand can be a literal or another attribute.
When adding a second And Where expression, be sure the Logical Operator is set to the value you want ("And" or "Or").
To remove an And Where expression, right-click the row you want to remove and choose Delete.
The Order By area is used to specify how resulting Web page sections are to be ordered. By default, no sorting is done, that is, sections are created based on the order the objects are returned by the domain. To insert a sort key, choose "Click here to add" in the Key column. In the tree control, select an attribute to serve as the sort key.
Choose "Alphanumeric" for alphabetically ordered sections; choose "Numeric" for numerically ordered sections.
Choose "Reverse Order" for reverse alphabetical or numeric order.
Choose "Ignore Case" and ProjectConsole will not consider case when ordering.
If you select the "Unique Only" check box, only one of the objects for which all the keys compare equally is produced.