entrouvert
/
publik-bi
Archived
17
0
Fork 0
Code Issues Pull Requests Releases Activity

3m; remove encombrants from bi_all_forms view

This commit is contained in:
Benjamin Dauvergne 2016-02-25 11:39:55 +01:00
parent 9ed042e31c
commit d8de03a580
2 changed files with 0 additions and 4 deletions
Show Stats Download Patch File Download Diff File Expand all files Collapse all files

2
3m/3m_prod.sql
View File

@ -151,8 +151,6 @@ CREATE VIEW bi_espaces_verts AS (SELECT
-- Les 7 formulaires pôles
CREATE VIEW bi_all_forms AS (
SELECT formdef_id || '-' || id AS id, backoffice_submission, 'encombrants' as form, receipt_time, status, pole_commune_ref FROM bi_encombrants
UNION ALL
SELECT formdef_id || '-' || id AS id, backoffice_submission, 'voirie' as form, receipt_time, status, pole_commune_ref FROM bi_voirie
UNION ALL
SELECT formdef_id || '-' || id AS id, backoffice_submission, 'reseaux_eau_potable' as form, receipt_time, status, pole_commune_ref FROM bi_reseaux_eau_potable

2
3m/3m_test.sql
View File

@ -151,8 +151,6 @@ CREATE VIEW bi_espaces_verts AS (SELECT
-- Les 7 formulaires pôles
CREATE VIEW bi_all_forms AS (
SELECT formdef_id || '-' || id AS id, backoffice_submission, 'encombrants' as form, receipt_time, status, pole_commune_ref FROM bi_encombrants
UNION ALL
SELECT formdef_id || '-' || id AS id, backoffice_submission, 'voirie' as form, receipt_time, status, pole_commune_ref FROM bi_voirie
UNION ALL
SELECT formdef_id || '-' || id AS id, backoffice_submission, 'reseaux_eau_potable' as form, receipt_time, status, pole_commune_ref FROM bi_reseaux_eau_potable