How Do I Retrieve Data from a Database View? (Magic xpa 4.x)

Within a database there are database tables, and database views. A view is a sort of virtual table. It does not store data; rather it stores a SELECT statement which extracts data from one or more tables by some criteria.

Magic xpa, however, treats database views just as it does database tables. When you go to do a Get Definition, the database views are listed along with the tables. If you select a database view, you will build a Magic xpa table which will work like any other SQL table. You can tell it is a database view, however, because the name will be in brackets.

See How Do I Access an Existing Database Table? for more information on using Get Definition.