Databases Reference
In-Depth Information
To understand this concept, let's take a look at an example that represents the
query to the
Employee
Data Object that you saw before.
In this
ViewSet
definition, the dataset attribute specifies the database table
(
_Employees
) that is used to persist the Data Object (
Employee
). The
Data-
setField
and
AggregateField
elements specify the
_Sales_Area
data
field and the aggregate
SUM(_Sales_Number)
that can be used to construct
the query to the
_Employees
dataset.
ViewSets
can also be sorted, filtered, and applied row-level securities. More
topics related to
ViewSet
will be covered in the next chapter.
View
A
View
is a rendered result set, which is generated by opening one or a col-
lection of
ViewSets
. The following is a sample of the 3D bar chart View that
shows the number of orders, grouped by its status: