manuel/V03/Documentation-Administrateurs/3.-Sysma-et-QGis.md

@@ -114,9 +114,9 @@ actions as ( -- filtre sur nos actions
   LEFT JOIN sysma.sysma_object o on (o.sysma_object_id = idol.sysma_object_id) -- jointure sur les sysma_object_id
 )
 
-, selected_objects_with_action_type_alias AS (
+
+, selected_objects_with_action_type_names AS ( -- ajout des noms des types d'actions
   SELECT 
-      aty.sysma_action_type_alias
     , aty.sysma_action_type
     , so.*
   
@@ -124,12 +124,11 @@ actions as ( -- filtre sur nos actions
   LEFT JOIN sysma.sysma_action_type aty ON (aty.sysma_action_type_id = so.sysma_action_type_id)
 
 )
--- Contrcuction de la table finale avec ajout d'un identifiant unique (gid)
-
-SELECT row_number() over() as gid
-, sowaty.*
+-- Construction de la table finale avec ajout d'un identifiant unique (gid)
 
- FROM  
-selected_objects_with_action_type_alias sowaty
-```sql
+SELECT 
+   row_number() over() as gid
+ , sowaty.*
+ FROM  selected_objects_with_action_type_alias sowaty
+```
 # 3.4 Un exemple concret : générer un Atlas bilan annuel des travaux
\ No newline at end of file