| Column | Verbose Name | Type | Groupable | Filterable | Is temporal | |
|---|---|---|---|---|---|---|
| criticita | None | STRING | ||||
| data_scadenza | None | DATETIME | ||||
| data_inizio | None | DATETIME | ||||
| nome | None | STRING | ||||
| data_consegna | None | DATETIME | ||||
| assegnatario | None | STRING | ||||
| urgenza | None | STRING | ||||
| priorita_raw | None | INT | ||||
| priorita | None | None |
| Table Name | Untitled Query 2-GQL635DyX |
|---|---|
| Sql | SELECT CASE v_progetti_ok.priorita when 9 then 'Critica' when 8 then 'Molto Alta' when 7 then 'Alta' when 6 then 'Medio-Alta' when 5 then 'Media' when 4 then 'Medio-Bassa' when 3 then 'Bassa' when 2 then 'Molto-Bassa' when 2 then 'Minima' else 'Trascurabile' end as criticita, (v_progetti_ok.data_scadenza::date - now()::date) as ritardo , v_progetti_ok.* from v_progetti_ok |
| Enable Filter Select | False |
| Fetch Values Predicate | None |
| Database | axelor |
| 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 | [axelor].[Untitled Query 2-GQL635DyX](id:77) |
| Associated Charts | [] |