Hi All,

would you please help me How to use views in x++?

Hi Kishore,

This link in MSDN should get you started with the basics.

If you have specific questions, do let us know.

Hello Kishore,

A Microsoft Dynamics AX view is a virtual table that contains the data records and fields that are specified by a query.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.

Views can be used in the same way as tables: in forms, reports, and from X++ code. View elements are instantiated in X++ variable declarations the same way as tables.Views support only inner joins and field-level aggregation.

Thanks & Regards,

Shankar Dutt Sharma