Set Form Table Filter

Kalipso - Form - Actions - Actions Description - Group Forms - Set Form Table Filter

Sets a Filter and/or an Order by on the specified Database Table for the current Form. This Filter/Order By only affects Data Link Actions.

Action available for the following operating systems:

Parameters

• Table - Database Table where the filter should be applied.

Set

• Filter - Check to apply a Filter.

• Order By - Check to apply an Order By.

• Filter <Kalipso Filter> or <string> - Condition to specify which records should be available for the Data Link Actions. Check Expressions chapter for more information about Kalipso Filter and String expressions.

• Order By <Kalipso Filter> or <string> - Specifies the order in which records should be available for the Data Link Actions. Check Expressions chapter for more information about Kalipso Filter and String expressions.

If your Filter or Order By have dynamic values (Controls, Variables, etc), you must refresh the Filter/Order By whenever they change with Refresh Form Table Filter Action.