From a3a69209c824d4e8e454ef916ec97a60ad3590c7 Mon Sep 17 00:00:00 2001 From: olivier larcheveque Date: Tue, 21 Sep 2010 09:22:05 -0400 Subject: [PATCH] =?utf8?q?filtrer=20les=20r=C3=A9sultats=20de=20recherches=20?= =?utf8?q?par=20mod=C3=A9ration?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- auf_savoirs_en_partage/savoirs/lib/sep.py | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/auf_savoirs_en_partage/savoirs/lib/sep.py b/auf_savoirs_en_partage/savoirs/lib/sep.py index 37c0be6..ea827eb 100644 --- a/auf_savoirs_en_partage/savoirs/lib/sep.py +++ b/auf_savoirs_en_partage/savoirs/lib/sep.py @@ -132,7 +132,8 @@ class SEP: m = "+".join (matches) q = "SELECT id, (%s) AS score FROM savoirs_record \ - WHERE (%s) HAVING score > 0 ORDER BY score DESC" % (m, m) + WHERE (%s) AND validated = 1 \ + HAVING score > 0 ORDER BY score DESC" % (m, m) from django.db import connection, transaction cursor = connection.cursor() -- 1.7.10.4