summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorFrédéric Péters <fpeters@entrouvert.com>2019-10-03 14:00:27 (GMT)
committerFrédéric Péters <fpeters@entrouvert.com>2019-10-03 14:00:27 (GMT)
commit82629738eb603070c82f3e1fe29c813d1e4f0661 (patch)
treefa46d9e9d0d4dbf9ccaa850677125bc808c94fe2
parent4ddb26f6def9c32e10f325189f1ab6272ef44b7f (diff)
downloadtabellio.pcfdb-master.zip
tabellio.pcfdb-master.tar.gz
tabellio.pcfdb-master.tar.bz2
ignore placeholder deputies (#36632)HEADmaster
-rw-r--r--tabellio/pcfdb/sync.py1
1 files changed, 1 insertions, 0 deletions
diff --git a/tabellio/pcfdb/sync.py b/tabellio/pcfdb/sync.py
index 0c14438..b8778f9 100644
--- a/tabellio/pcfdb/sync.py
+++ b/tabellio/pcfdb/sync.py
@@ -508,6 +508,7 @@ class SyncFromPcfDbView(BrowserView):
FROM t_pers, t_pershistoline, t_comppol, t_parl, t_arrond
WHERE t_pers.st = 'S_PARL' and
t_pers.prenom is not NULL and
+ t_pers.nom is not like '%% N %%' and
t_pers.id = t_pershistoline.pers and
t_pershistoline.description = t_comppol.id and
t_pershistoline.type = 'P_CMPL' and