Friends, does anyone know why when a table in SQL is a query and we did a lookup field the field appears blank in the detail view, but table view does it appear?
Table view
Detail view
Field in Detail View does not appear when table comes from query
Re: Field in Detail View does not appear when table comes from query
Hi,
can you post a little bit more information about the two lookup. Are they cascaded?
can you post a little bit more information about the two lookup. Are they cascaded?
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
Re: Field in Detail View does not appear when table comes from query
They actually fetch information from other tables.
I have the parent table and created two query tables for active and inactive employees.
In these query tables, the information in the detail view does not appear only in the table view.
I have the parent table and created two query tables for active and inactive employees.
In these query tables, the information in the detail view does not appear only in the table view.
Re: Field in Detail View does not appear when table comes from query
Hi again,
can you post the definition in AppGini (and possibly the query you use).
Do you have any errors in the browser console?
can you post the definition in AppGini (and possibly the query you use).
Do you have any errors in the browser console?
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
Re: Field in Detail View does not appear when table comes from query
Hi, thank you so much for trying to help me.
The version of my AppGini is 5.84
Below are images:
Thanks!
The version of my AppGini is 5.84
Below are images:
Thanks!
Re: Field in Detail View does not appear when table comes from query
Hi,
sorry, I'm struggling to understand what the funcionarios_activos sql statement is used for. In what relation is it to the funcionarios table?
sorry, I'm struggling to understand what the funcionarios_activos sql statement is used for. In what relation is it to the funcionarios table?
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
Re: Field in Detail View does not appear when table comes from query
I created a parent table (active employees) called employees and two queries for active and inactive employees (employees and inactive_employees)
In AppGini I only use queries (employees and inactive_employees)
It works perfectly, but the lookup field doesn't appear in the detail view
I don't know if you tell me to understand?
In AppGini I only use queries (employees and inactive_employees)
It works perfectly, but the lookup field doesn't appear in the detail view
I don't know if you tell me to understand?
Re: Field in Detail View does not appear when table comes from query
Hi,
still struggling to understand what you mean by "I only use queries". Are you overwriting the query that is generated automatially from AppGini for your table? If that is the case you need to understand that the lookup field do not store the actual value, but the PK of the referenced table and within the query AppGini fetches the value from that table for the lookup through the PK.
still struggling to understand what you mean by "I only use queries". Are you overwriting the query that is generated automatially from AppGini for your table? If that is the case you need to understand that the lookup field do not store the actual value, but the PK of the referenced table and within the query AppGini fetches the value from that table for the lookup through the PK.
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
Re: Field in Detail View does not appear when table comes from query
Hello Friend!
Let's see if I can write in a more didactic way to understand.
I created 2 tables in App Gini. These 2 tables are derived from a parent table. The parent table is not in AppGini, just the lookup tables.
The parent table contains all the information.
In table 1 I did a select * from mother table and added a where so that it takes only a specific value.
In table 2 I did the same thing, a select * from parent table, but getting another value through where.
The issue is that when I look at the query table in the table view the fields (drop-fields) appear, but not in the detail view.
I don't know if I made myself understood this time.
Thank you for your help!
Let's see if I can write in a more didactic way to understand.
I created 2 tables in App Gini. These 2 tables are derived from a parent table. The parent table is not in AppGini, just the lookup tables.
The parent table contains all the information.
In table 1 I did a select * from mother table and added a where so that it takes only a specific value.
In table 2 I did the same thing, a select * from parent table, but getting another value through where.
The issue is that when I look at the query table in the table view the fields (drop-fields) appear, but not in the detail view.
I don't know if I made myself understood this time.
Thank you for your help!
Re: Field in Detail View does not appear when table comes from query
ok, where do you put your SQL statements?
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.