The expansion of the structure of the displayed tabular forms without recoding the database views.
Sometimes we need to see more information on the screen than a database table can provide. Let’s look at this table.
It is the list of the branch stores. Here we can see the branch store and the main store address, and the geographical coordinates.
Open any row and see that the
main store and
address fields are the foreign keys. They reference other table rows. And it is very nice that we can see the address in a table, but what if we want to see more information about the store? For example we don’t see the phone number of the store.
You can be happy that this problem is very easy for Abris Platform. Click
Table designer. You see that the
Plus button appeared.
Click it and see the popup window with the related information, organized as a tree.
Address and select
phone field is added to the table.
All constructed fields contain arrows in the caption and a cross icon that allows you to remove fields from the table.
We can move forward and add information from a more complex path. So we can add the
country field that is accessible from city table.
Constructed tables allow the use of ordering and filters.
We can add information not only from the reference fields, but from the dependent tables.
Let’s look at the
Film table. Every film is associated with some actors' names. If we want to see that names in the table we can also add them. Click
Table designer =>
So we always can see more information that application developer provided. It can be done on the fly without any software coding.
For more information, see the video-instruction:
No code, no special design. Just install and use.