fix bi_assainissement view in 3m_test.sql
This commit is contained in:
parent
d19233d2b7
commit
773eede548
|
@ -63,7 +63,7 @@ CREATE VIEW bi_assainissement AS (SELECT
|
|||
commune_display AS pole_commune_ref,
|
||||
backoffice_submission,
|
||||
nature_demande_display as nature_demande
|
||||
FROM wcs_view_90_assainissement_et_reseaux_d_eaux_usees AS f
|
||||
FROM wcs_view_101_assainissement_et_reseaux_d_eaux_usees AS f
|
||||
WHERE status != 'draft'
|
||||
);
|
||||
|
||||
|
|
Reference in New Issue