View Object
General
This section will explain some of the options available for the view object in the Overview
tab and other options available from the Property Inspector window.
Tuning
This section has some of the tuning properties that can be set for the view object. The tuning
options used for the performance of the view object are as follows:
‹ All Rows: This option is used to retrieve all the rows from the database.
‹ Only up to row number: Using this option, you can set the row number up to
which you want to retrieve the rows.
‹ In Batches of: This option can be used to say how many batches you want to
retrieve from the database.
‹ As needed: Using this option, you can have rows fetched as needed from
the database.
‹ All at once: This option can be used to get the rows all at once at first retrieval
upon executing the query.
‹ At most one Row: This option can be used to get at the most one row when the
view object query is executed.
‹ No rows: This option can be used retrieve a no rows event after querying the
database using the view object.
‹ Query Optimizer hints: This option provides an optimizer hint to make the view
object performant in retrieving the data.
‹ Fill last page of rows: This option will display the result of the query when working
with pagination in the UI. Pagination is displaying the result of the query in pages,
with a range of data.
‹ Passivate State: This option is used to maintain the state of the object on failover
by passivating the view object collection data. This option is used in a clustered
environment, where the activation and passivation of query results is mandatory
for the highly available application.
‹ Access Mode: This setting provides options to support pagination in the UI.
‹ Range size: This option defines the range size of the rows in each paging view.
Entity Objects
The view object is created based on the entity that you will select. The view object can be
based on multiple entity objects, using joins.
Attributes
The Attributes section defines the following properties:
‹ SDO Property: Sometimes, a view object is used as a service. Check if this is acting
as a service definition object.
‹ XSD Type: This option defines the XML Schema Definition (XSD) type to be used
for a service definition.
List of Values
You can use this setting to provide a list to be shown for the attribute in the UI.
Query
The SQL query defined for the view object is shown in this section. We can change
the Where: and the Order by: clause in this section, if the view object is based on
an entity object.
Bind Variable
This section defines the bind variable for the view object query. This is used to fetch the desired result set by passing the value to the bind variable.
View Criteria
This section provides support for creating custom criteria which is more flexible for use in fetching data efficiently.
General
This section will explain some of the options available for the view object in the Overview
tab and other options available from the Property Inspector window.
Tuning
This section has some of the tuning properties that can be set for the view object. The tuning
options used for the performance of the view object are as follows:
‹ All Rows: This option is used to retrieve all the rows from the database.
‹ Only up to row number: Using this option, you can set the row number up to
which you want to retrieve the rows.
‹ In Batches of: This option can be used to say how many batches you want to
retrieve from the database.
‹ As needed: Using this option, you can have rows fetched as needed from
the database.
‹ All at once: This option can be used to get the rows all at once at first retrieval
upon executing the query.
‹ At most one Row: This option can be used to get at the most one row when the
view object query is executed.
‹ No rows: This option can be used retrieve a no rows event after querying the
database using the view object.
‹ Query Optimizer hints: This option provides an optimizer hint to make the view
object performant in retrieving the data.
‹ Fill last page of rows: This option will display the result of the query when working
with pagination in the UI. Pagination is displaying the result of the query in pages,
with a range of data.
‹ Passivate State: This option is used to maintain the state of the object on failover
by passivating the view object collection data. This option is used in a clustered
environment, where the activation and passivation of query results is mandatory
for the highly available application.
‹ Access Mode: This setting provides options to support pagination in the UI.
‹ Range size: This option defines the range size of the rows in each paging view.
Entity Objects
The view object is created based on the entity that you will select. The view object can be
based on multiple entity objects, using joins.
Attributes
The Attributes section defines the following properties:
‹ SDO Property: Sometimes, a view object is used as a service. Check if this is acting
as a service definition object.
‹ XSD Type: This option defines the XML Schema Definition (XSD) type to be used
for a service definition.
List of Values
You can use this setting to provide a list to be shown for the attribute in the UI.
Query
The SQL query defined for the view object is shown in this section. We can change
the Where: and the Order by: clause in this section, if the view object is based on
an entity object.
Bind Variable
This section defines the bind variable for the view object query. This is used to fetch the desired result set by passing the value to the bind variable.
View Criteria
This section provides support for creating custom criteria which is more flexible for use in fetching data efficiently.
No comments:
Post a Comment