September 23, 2016 Published by

How to create view and purpose in X3V9

How to create view and purpose in X3V9

View is virtual table and consists of rows and columns. View is good option when fetching the data from multiple tables in X3 and increase the performance at coding level.

View programming is similar to programming for a table and contains its own class.

The following steps are describing how to create view and use them in coding:

Development -> Data and Parameter -> Views

 

image001

 

Write the either SQL or Oracle query based on data type is being used for X3.

SQL Server:

 

image003

 

Query has been written for testing purpose, which is for retrieving the data form ITMMASTER (Product table) and ITMFACILIT (Product-Site table) tables by using joins.

Once the query has been completed, we have to assign the fields in field table and make sure the number of fields in query and in tab are same. Data type should also be same.

 

image005

We need to provide index code for view as well as for table.

 

image007

 

Open the view using clalev function which is same for table as shown in following screen shot.

 

image009

 

Once reading data from the view has been started, query will be executed and will load the data in to view automatically from database.
Ex: Displaying one record of data from both tables and displaying in info box.

 

image011

 

 

 

 

TAGS:

Your email address will not be published. Required fields are marked *