Wednesday, June 27, 2018

Views

A Microsoft Dynamics AX view is a virtual table that provides the data records
and fields that are specified by a query. The following sections describe views
and how they retrieve data.
Like a table, a view uses fields and rows to represent data records. However, the
data in a view is not stored as a database object but is dynamically created when
the view is accessed. A view uses a query to retrieve data fields from one or more
database tables.
In Microsoft Dynamics AX, use views where tables are used. For example, use a
view in a form, a report, and in X++ code. The following table shows the benefits
of using a view instead of a table.
Benefit Description
Focused
Data
A view is used to retrieve and return only the data that is relevant
for a particular user or scenario.
Customize
d Data
A view enables the use of a complex query to create a highly
customized set of data. For example, a view often represents data
as a single table that is retrieved from multiple joined tables and
uses many conditions.
Performan
ce
A view can improve performance by returning only relevant
fields to the user. In addition, a view definition is compiled
which can provide better performance than calling an
equivalently complex query.

When a view is created, the view definition is generated and stored in the
database. When that view is accessed, the view dynamically retrieves the data
that satisfies the view definition.
NOTE: Views are read-only. The data fields and tables that a view uses cannot
be updated from that view.
Views are synchronized like tables. When a view is synchronized, the view
definition is saved to the database. Synchronization of an existing view causes
the definition of that view to be dropped and re-created in the database.


Best Regards,
Hossein Karimi

No comments:

Post a Comment

Configure the Firewall on the Enterprise Portal Server

After you install Enterprise Portal, enable Web Server (HTTP) in Windows Firewall. If you do not enable the web server in Windows Firewall...