| ... | ... | @@ -117,7 +117,7 @@ actions as ( -- filtre sur nos actions |
|
|
|
|
|
|
|
, selected_objects_with_action_type_names AS ( -- ajout des noms des types d'actions
|
|
|
|
SELECT
|
|
|
|
, aty.sysma_action_type
|
|
|
|
aty.sysma_action_type
|
|
|
|
, so.*
|
|
|
|
|
|
|
|
FROM selected_objects so
|
| ... | ... | @@ -129,6 +129,6 @@ actions as ( -- filtre sur nos actions |
|
|
|
SELECT
|
|
|
|
row_number() over() as gid
|
|
|
|
, sowaty.*
|
|
|
|
FROM selected_objects_with_action_type_alias sowaty
|
|
|
|
FROM selected_objects_with_action_type_names sowaty
|
|
|
|
```
|
|
|
|
# 3.4 Un exemple concret : générer un Atlas bilan annuel des travaux |
|
|
\ No newline at end of file |
