diff options
author | Frédéric Péters <fpeters@entrouvert.com> | 2019-10-03 14:00:27 (GMT) |
---|---|---|
committer | Frédéric Péters <fpeters@entrouvert.com> | 2019-10-03 14:00:27 (GMT) |
commit | 82629738eb603070c82f3e1fe29c813d1e4f0661 (patch) | |
tree | fa46d9e9d0d4dbf9ccaa850677125bc808c94fe2 | |
parent | 4ddb26f6def9c32e10f325189f1ab6272ef44b7f (diff) | |
download | tabellio.pcfdb-master.zip tabellio.pcfdb-master.tar.gz tabellio.pcfdb-master.tar.bz2 |
-rw-r--r-- | tabellio/pcfdb/sync.py | 1 |
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 |