Adding an Invalidate query cache event action

Use the Invalidate Query Cache event action to invalidate any query cache, if the caching of result set data is enabled.

About this task

Using this event action is appropriate in a scenario where you have changed the target query table, thereby invalidating any previous results, and these invalid results are still displaying in the related components. By implementing the Invalidate Query Cache event action, you redraw results in all the related components. This query is rerun and the valid results are displayed in the component.

To add an Invalidate query cache event action to an object:

Procedure

Select the object in the editor window and double-click the event that will trigger the jump from the Events view.
The [objectname] Behavior window opens.
Click the Add New Action icon.
The Add New Action dialog opens.
Select Invalidate Query Cache in the actions tree.
Note: To quickly find the required event action, type the name of the action in the filter text field.
Click Next.
A window requesting the parameters for the Invalidate Query Cache event action opens.
Specify one or more target components for which the query cache will be invalidated and click Finish.
The Add New Action window closes.
Click OK to close the [objectname] Behavior window.

Results

You have added an Invalidate Query Cache event action.

When the defined event action occurs, query cache in the target component is invalidated and the valid results are displayed in the component the next time it is refreshed.