Click Next on the Define Record Layout window to the Add Filter Rules window, which allows you to create basic filters to include or exclude records and fields.
The Add Filter Rule options are:
Include/Exclude – select the type of Filter Rule to create:
Include Records
Exclude Records
Include Fields
Exclude Fields
Position/Condition (record rules only) – select:
Number – to specify the position of the record to filter. Enter the numbers or ranges of numbers for the filter rule.
Where – to specify a condition for the filter rule. Select the field where the condition should be met.
Select the Boolean argument for the filter rule.
Enter the value for the filter rule in the last input field.
Click Add to add the filter rule. The preview highlights any records or fields that match the filter rules.
Position/Label (field rules only) – select:
Number – to specify the position of the field.
Where – to specify a condition for the filter rule.
Label – to include or exclude a field specifically by the contents of its label.
Editing filter rules can alter the structure of a table
by adding, excluding, and moving columns or rows. Such changes can
impact features that were dependent on the previous table structure,
such as events and charting. After changing filter rules you should
check the dependencies to verify the application still works as
expected.
Applying newly created
filter rules
Continue to use the data-capable Web element example used in the previous section.
Select Include Records from the Include/Exclude drop-down.
Select Number from the Number/position drop-down.
Enter “1– 4” in the Number field. When you click Preview, records 1– 4 are highlighted in the preview.
Click Next. The element preview displays only those records that are defined by the filter rules.
Enter the name under which you want to save the element in the Element Name field, and click Finish.
When you return to the Application Builder, click the down arrow beside the Save button to save the new element. See “Saving applications” for specific instructions.
Copyright © 2005. Sybase Inc. All rights reserved. |
![]() |