| Column | Verbose Name | Type | Groupable | Filterable | Is temporal | |
|---|---|---|---|---|---|---|
| user_id | None | INT | ||||
| rowid | None | INT | ||||
| partita_iva | None | STRING | ||||
| partita_iva_desc | None | STRING | ||||
| shareCapital | None | STRING | ||||
| yearenddate | None | STRING |
| Table Name | admin user-financial_data_disgreg-yNKs5dSlY |
|---|---|
| Sql | select a.user_id , a.rowid, a.partita_iva, 'P.IVA:'||a.partita_iva||'' as partita_iva_desc, a.valore_n as "shareCapital", substring(b.valore_n from 2 for 10) AS yearenddate from (SELECT user_id , rowid, partita_iva ,campo, valore_n FROM v_financial_deaggr where campo in ('shareCapital') GROUP BY 1,2,3,4,5) a left join (SELECT user_id , rowid, partita_iva ,campo, valore_n FROM v_financial_deaggr where campo in ('yearEndDate') GROUP BY 1,2,3,4,5) b on a.user_id= b.user_id and a.partita_iva=b.partita_iva and a.rowid=b.rowid |
| Enable Filter Select | False |
| Fetch Values Predicate | None |
| Database | fascicoloimprese |
| Schema | public |
| Description | None |
| Owners | [admin user] |
| Main Datetime Column | None |
| Default Endpoint | None |
| Offset | 0 |
| Cache Timeout | None |
| SQL Lab View | True |
| Template parameters | None |
| Perm | [None].[admin user-financial_data_disgreg-yNKs5dSlY](id:36) |
| Associated Charts | [] |