Form-over-Table Download

When a business user invokes a download for a Form-over-Table layout, Oracle Visual Builder Add-in for Excel downloads the form data first, then downloads the child rows for the current form row.

The download process is similar to the table download with these differences:

• For the form download:
  • The add-in sets the count/limit query parameter to "1" (one) since only one row is displayed in the form.
  • There is no pagination at the form level.
  • The add-in populates the form region with data from the first row in the response from the GET request on the collection path.
• For the table download:
  • The path parameters for the child collection path are managed automatically by the add-in based on the current parent row.
  • The add-in downloads all available child rows for the current parent row.

    Note:

    You can limit the set of child rows downloaded by configuring one or more download parameters for the table from the Layout Designer. See Configure a Download Parameter for a Layout.
  • If the table has more than one page of child rows available, the user is prompted to continue.
• The post-download macro is invoked, if configured, when the form and table downloads have completed successfully.