Oracle Cloud Infrastructure Documentation

Use Table Hyperlinks to Access Data in Table Format

Table Hyperlink data can be viewed in tabular format when accessed from a browser. The table format supports scrolling, sorting, filtering, cell colors, and Group By where you select a column name to see column data based on the values in the column.

Parent topic: Use Table Hyperlinks for Read Only Data Access on Autonomous Database

Use Table Hyperlinks and View Data in Default Table Format

You can access data with a Table Hyperline from a browser and view the data in table format.

To return data in table format, append the ?view=table query parameter to any Table Hyperlink. For example, from a browser use a Table Hyperlink with ?view=table appended: 

https://dataaccess.adb.us-ashburn-1.oraclecloudapps.com/adb/p/F5Sn..._example/data?view=table

Here is a sample response to a Table Hyperlink with ?view=table appended:

Description of par_url_ui_default.png follows
Description of the illustration par_url_ui_default.png

Column options are configurable when a Table Hyperlink is generated. See Generate a Table Hyperlink with UI Features Specified on Columns for more information.

Use Table Hyperlinks in Table Format with Column Sorting

You can access data with a Table Hyperlink from a browser and view the data in table format and sort table data.

To return data in table format, append the ?view=table query parameter to any Table Hyperlink. For example, from a browser use a Table Hyperlink with ?view=table appended: 

https://dataaccess.adb.us-ashburn-1.oraclecloudapps.com/adb/p/F5Sn..._example/data?view=table

In table view you can sort Table Hyperlink columns in ascending or descending order by clicking more actions next to a column heading, and then select Sort Ascending or Sort Descending.

For example:

Description of par_url_ui_descending.png follows
Description of the illustration par_url_ui_descending.png

Column sorting is configurable by column when a Table Hyperlink is generated. See Generate a Table Hyperlink with UI Features Specified on Columns for more information.

Use Table Hyperlinks in Table Format with Column Filtering

You can access data with a Table Hyperlink from a browser and view the data in table format and filter table data.

To return data in table format, append the ?view=table query parameter to any Table Hyperlink. For example, from a browser use a Table Hyperlink with ?view=table appended: 

https://dataaccess.adb.us-ashburn-1.oraclecloudapps.com/adb/p/F5Sn..._example/data?view=table

You can filter Table Hyperlink columns by clicking more actions next to a column heading, and then enter the filter text in the input text box, and type Enter.

The following is a screenshot of a sample table with the SPECIES column filtered to only display data for Spruce trees:

Description of par_url_ui_filtered.png follows
Description of the illustration par_url_ui_filtered.png

Column filtering is configurable by column when a Table Hyperlink is generated. See Generate a Table Hyperlink with UI Features Specified on Columns for more information.

Use Table Hyperlinks to Access Data in Table Format with Colors in Cells

You can access data with a Table Hyperlink from a browser and view the data in table format and display cell values with color.

You can access Table Hyperlink data with a browser and view the returned data in database table like format. The table format supports scrolling, sorting, filtering and cell colors.

To return data in table format, append the ?view=table query parameter to any Table Hyperlink. For example, from a browser use a Table Hyperlink with ?view=table appended: 

https://dataaccess.adb.us-ashburn-1.oraclecloudapps.com/adb/p/F5Sn..._example/data?view=table

By default columns do not include coloring for cell values. You can add color to cell values in Table Hyperlink table view by clicking more actions next to a column heading, and then select Enable Color.

The following is a screenshot of a sample table with the SPECIES column showing color with values in cells:


Description of par_url_ui_enable_color.png follows
Description of the illustration par_url_ui_enable_color.png

Color Column Data with Query Parameters

You can also use query parameters select the columns you want to add color to. To specify the columns with color, include the column names with the colored_column_names query parameter. For example, to color the COUNTY and SPECIES columns: 

https://dataaccess.adb.us-ashburn-1.oraclecloudapps.com/adb/p/F5Sn..._example/data?view=table&colored_column_names=COUNTY,SPECIES

The following is a screenshot of a sample table with COUNTY and SPECIES columns showing color with cell values:

Description of par_url_ui_colored.png follows
Description of the illustration par_url_ui_colored.png

Color Column Data Types with Query Parameter

You can also use query parameter to select a specific column data type to add color in a table by providing the data type with the colored_column_types query parameter.

This parameter supports colored_column_types=VARCHAR to color all the string (VARCHAR) columns, and colored_column_types=NONE to not color any data types.

For example:

https://dataaccess.adb.us-ashburn-1.oraclecloudapps.com/adb/p/F5Sn..._example/data?view=table&colored_column_types=VARCHAR

Use Table Hyperlinks to Access Data with the Group By Option in Table Format

You can access data with a Table Hyperlink from a browser and group the data by the values of cells in a column.

The Table Hyperlink generation procedures supports column list options that provides support specifying columns and viewing column values with the group by option.

For example, when group by is specified when a Table Hyperlink is generated, do the following to view data by group:

  1. From a browser use a Table Hyperlink with ?view=table appended.

    For example:

    https://dataaccess.adb.us-ashburn-1.oraclecloudapps.com/adb/p/F5Sn..._example/data?view=table
  2. From a column that shows the group by option, select Group by.

    This shows the Group by display, and allows you to select another column if another column is available for group by display (depending on how the Table Hyperlink was generated).


    Description of adb_par_url_group_by_table.png follows
    Description of the illustration adb_par_url_group_by_table.png

By default the Table Hyperlink columns do not support group by options. This option is configurable by column when a Table Hyperlink is generated. See Generate a Table Hyperlink with UI Features Specified on Columns for more information.