8.9.6.9 Configuring Advanced Attributes for Interactive Reports

Configure advanced interactive report attributes to define the region alias, specify an item whose value stores the saved report ID, and define a from address in an interactive report subscription or email download

Parent topic: Managing Interactive Report Attributes

8.9.6.9.1 About Emailing from an Interactive Report

Learn about emailing from an interactive report.

You can define the From address for emails sent from an interactive report in two ways:

  • Application-level — Edit the Application Email From Address attribute on the Edit Application Definition page.
  • Report-level — Access the report Attributes. Under Advanced, edit the Email from Address attribute.

In either case, the value can be a literal string containing a valid email or an application substitution defined at the application-level using substitution syntax or &APP_EMAIL. substitution which returns the Application Email From Address defined at the application-level. Examples: 

john.doe@example.com
&MY_APP_EMAIL_FROM.
&APP_EMAIL.

Note:

Oracle does not recommend using an item substitution at the application or page-level since it only works in email download, but not for subscriptions.

See Also:

Parent topic: Configuring Advanced Attributes for Interactive Reports

8.9.6.9.2 Configuring Advanced Attributes

Configure Advanced interactive report Attributes.

To configure Advanced Attributes:

  1. View the page in Page Designer:
    Page Designer appears.
  2. In the Rendering tab, select the region containing the report.
  3. In the Property Editor, select the Attributes tab.
    The Property Editor displays the attributes. Attributes are organized in groups
  4. Find Advanced and configure the appropriate options.
    1. Region Alias - Enter an alphanumeric alias for this interactive report region.

      The alias must be unique within the application. You can use an alias to reference an interactive report region in your custom API call. For example, you can write a function to return the INTERACTIVE_REPORT_ID by querying the ALIAS column in the APEX_APPLICATION_PAGE_IR view. Since the INTERACTIVE_REPORT_ID value can change when you export or import the application to different instance, referencing interactive report regions using an alias may be preferable.

    2. Report ID Item - Select a page or application item whose value stores the saved report ID.

      Interactive report uses this item value to link to a saved report. For example, you can define list of saved reports with links with defined item name and saved report ID as its value to link to a saved default reports, public or private reports. The saved report IDs can be retrieved from the APEX_APPLICATION_PAGE_IR_RPT view.

    3. Email From Address - Enter a valid email address to use as the From address when sending email from this report.

      Emails are sent from this report for Downloads of type Email and for Subscriptions. The value can be a literal string containing a valid email address or a static substitution reference defined in the application using substitution syntax.

      Oracle does not recommend using an item substitution at the application or page-level since it only works in an email download, but not for subscriptions.

      Examples:

      john.doe@example.com
&MY_APP_EMAIL_FROM.
&APP_EMAIL.
    4. Oracle Text Index Column - Select a column where the column is indexed by an Oracle Text index.

      Row Search returns results based on the Oracle Text operator entered, providing the corresponding Oracle Text index has been created for the column. This option should only be enabled if the necessary index exist, and the end users have been trained in how to utilize the Oracle Text search operators. To simplify Oracle Text syntax for end users, you can specify a function for the Oracle Text PL/SQL Function Name Component Setting of Interactive Grids in Shared Components.

  5. To save your changes click Save. To save and run the page, click Save and Run Page.

Parent topic: Configuring Advanced Attributes for Interactive Reports