4.5.5 Configure Items to Submit and Return

Whenever you reference a page item value as a bind variable in a region data source query or WHERE clause, make sure to list its name in the region's Page Items to Submit property.

If you reference multiple page items as bind variables, list each name separated by commas in the value of this property. While you precede the page item name with a colon when using it as a bind variable, for this region property, page item names without the colon. Failure to remember this step can result in an application malfunction. When you forget to include a page item's name, its bind variable inadvertently evaluates to null. This can cause a query to return no rows, or business logic to take the wrong execution path.

Similarly, when referencing a page item or grid column value as a bind variable in a Dynamic Action of type Execute Server-side Code, ensure you set the Items to Submit and Items to Return properties appropriately. Forgetting to do this can produce No Data Found errors or make your page appear to function incorrectly when server-side computed values are not returned to the page as expected.