projets
/
auf_savoirs_en_partage_django.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
1052d86
)
Recherche
author
Ali Jetha
<ali@U-AJ.(none)>
Tue, 12 Oct 2010 22:49:56 +0000
(18:49 -0400)
committer
Ali Jetha
<ali@U-AJ.(none)>
Tue, 12 Oct 2010 22:49:56 +0000
(18:49 -0400)
auf_savoirs_en_partage/savoirs/lib/sep.py
patch
|
blob
|
blame
|
history
diff --git
a/auf_savoirs_en_partage/savoirs/lib/sep.py
b/auf_savoirs_en_partage/savoirs/lib/sep.py
index
482f54a
..
9730581
100644
(file)
--- a/
auf_savoirs_en_partage/savoirs/lib/sep.py
+++ b/
auf_savoirs_en_partage/savoirs/lib/sep.py
@@
-153,7
+153,7
@@
class SEP:
q = "SELECT r.id, (%s) AS score FROM savoirs_record AS r \
LEFT JOIN savoirs_record_listsets AS rl ON r.id = rl.record_id \
LEFT JOIN savoirs_listset AS l ON rl.listset_id = l.spec \
- WHERE (%s) AND r.validated = 1 AND l.validated = 1 \
+ WHERE (%s) AND r.validated = 1 AND (l.validated = 1 OR l.validated IS NULL) \
GROUP BY r.id \
HAVING score > 0 ORDER BY score DESC" % (m, m)
from django.db import connection, transaction