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 download row count to "1" (one) since only one row is displayed in the form. If the business object has a configured limit parameter, the request includes that parameter with a value of 1.
- 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.