Oracle Visual Builder Table Frozen Row

6 min read Oct 03, 2024

Oracle Visual Builder: How to Freeze Rows in Your Tables for Enhanced Data Exploration

Oracle Visual Builder offers a powerful platform for building web applications. One of its key features is the ability to display data in tables, allowing users to easily navigate and interact with information. However, when working with large datasets, keeping track of important information can become challenging. This is where the ability to freeze rows in tables becomes invaluable.

What is a Frozen Row?

Frozen rows are a handy feature in table displays that keeps certain rows visible at the top of the table, regardless of scrolling. This allows users to maintain context while exploring the remaining rows, making data analysis more efficient.

Why Use Frozen Rows?

Imagine you're working with a table containing sales data for various products across multiple regions. You might want to freeze the first row, which could contain headers like "Product Name," "Region," and "Total Sales." Freezing this row ensures that the column headers remain visible even when scrolling through hundreds of rows of sales data.

Implementing Frozen Rows in Oracle Visual Builder

1. Understanding the Visual Builder Environment:

Oracle Visual Builder provides a visual interface for creating and managing your applications. Within this interface, you can create components like tables to display data.

2. The Table Component:

The Table component is your primary tool for displaying tabular data in Visual Builder. To implement frozen rows, you'll need to configure the Table component.

3. The FrozenColumns Property:

The Table component has a property called FrozenColumns. This property allows you to specify which columns should remain frozen (visible) at the top. You can specify this in several ways:

Column Index: Indicate the index of the column you wish to freeze. For example, FrozenColumns: "0" would freeze the first column.
Column Name: You can also specify the column name if it is unique.
Combination: A combination of column indexes and names is possible. For instance, FrozenColumns: "0, productName" freezes the first column and the column named "productName."

4. Applying the Configuration:

Once you've defined the FrozenColumns property, the changes will automatically apply to your table. You will now see the specified columns remain visible as you scroll through your data.

Example

Let's say you have a table with data about customers, each row representing a customer with columns for "Customer Name," "Address," "City," and "State." You want to freeze the "Customer Name" column.

Open your Visual Builder application and navigate to the Table component where you are displaying customer data.
In the component's properties, locate the FrozenColumns property.
Set the value of the property to "Customer Name". This will freeze the column named "Customer Name."

Now, as you scroll through the table, the "Customer Name" column will stay fixed at the top, providing a constant reference for each customer's data.

Troubleshooting Tips

Check Column Names: Ensure that the column names you specify in FrozenColumns match the actual names used in your data source.
Column Indexes: If you're using column indexes, double-check that the index values are correct. Start counting from 0 for the first column.
Data Source: Make sure the data source for your Table component is correctly defined and populated.

Conclusion

Freezing rows in Oracle Visual Builder is a powerful technique for improving data analysis in web applications. By strategically using the FrozenColumns property, you can ensure that crucial information remains visible even when working with large datasets. This enhances the user experience and simplifies data exploration, making your web applications more effective and user-friendly.