About ViewCreator¶
ViewCreator is a tool that facilitates easy creation of table or view from the intra-mart Web screens using the data from the database.
Tenant database or shared database can be used.
In ViewCreator, broadly 2 types of data are handled.
- Query
SQL query is created using tables in the database.
It can be created by simple GUI operations such as drag and drop.
- Data reference
This means setting the query display method (table, view etc.).
A single query can be represented in multiple ways (data reference).
Moreover, access rights can also be set for referring the data.
The administrator first creates queries using the existing table information.
Based on the created queries, the data reference is created.
The created data reference can be shown to the user as well as it can be
output to the portlet and can also be displayed on the portal screen.
Moreover, the data from data reference displayed in list format can be output as CSV file.
- Query creation screen
- Auto-generated SQL from the query
- Query based data reference creation Example 1 - Grouped table
- Query based data reference creation Example 2 - Bar graph
