Welcome!
This community is for professionals and enthusiasts of the Genio platform.
Share your questions and challenges, and help your partners!
Display Table list for Full Calendar custom control with no base table
I needed to show all events of a calendar using the Full Calendar custom control using a Table list but had no related table to base my form on. I created a fake table that I named VAZIO that I filled with one record. I used the option Skip if just one so that I would open the form directly. Is there another way to do the same without having to create a table for that unique purpose?
The workaround you made is a valid solution although in terms of scalability it is not the the recommended way. If you're certain that your system will only have one entity you can use the GLOB table that only has one record (always). This is the solution to avoid the creation of a table with only one record. Again, this is a workaround. The recommended solution is to have a table of entities that is related with all the components of your system. This way, your system becomes easily scalable.
When creating a table with a GLOB identifier, Genio considers it special. It is special because it only allows one and only one registration. All fields / attributes placed in this table can be accessed by the other tables, for example for use in calculation formulas.
Each field in the GLOB functions as a global variable to the system. There is no need for relations with the GLOB. As such, it is completely discouraged to have a 1: N relationship with the GLOB.
N: 1 relations with the GLOB are allowed, for example the need to want the value of a primary key of a given table in a given field of the GLOB.
The solution to use GLOB to solve the presented challenge works today, but is not guaranteed to work in the future. Therefore, it is completely discouraged to use GLOB to solve even if the solution works in this particular case.
Keep Informed
About the Community
Question tools
Stats
| Asked: 05/05/2020 11:26 |
| Seen: 1670 times |
| Last updated: 22/08/2020 15:40 |
I don´t see any GLOB table in the project definitions.