WHENNODATA

Determines whether to collapse, minimize, or shrink a subpanel when the subpanel has no data to display.

Possible values
  • Collapse
  • Minimize
  • End (close)

    If no data is retrieved on the initial query or entry to the workspace, the subpanel is "deleted" and any query it contains is not run again on a refresh until the panel is reentered.

  • Shrink (the number of rows in the subpanel is dynamically decreased to null when there is no data).
  • Hide. Use instead of End if you want the subpanel to reappear when data is available again.
Default value
Collapse
Note: If Collapse is specified, code EXPANDCOLLAPSE=Y so users can expand the subpanel.

Example

WHENNODATA=COLLAPSE