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