def __init__(self, model=None):
return SEPSphinxQuerySet.__init__(self, model=model, index='savoirsenpartage_chercheurs',
weights=dict(nom=2, prenom=2))
+
def filter_region(self, region):
return self.filter(region_id=region.id)
def filter_statut(self, statut):
return self.filter(statut=self.STATUT_CODES[statut])
+ def filter_expert(self):
+ return self.filter(expert=True)
+
def order_by_nom(self, direction=''):
return self.order_by(direction + 'nom_complet', '-date_modification')
WHEN 'etudiant' THEN 2
WHEN 'independant' THEN 3
END AS statut,
- (ex.id IS NULL) AS expert
+ (ex.id IS NOT NULL) AS expert
FROM chercheurs_chercheur c
INNER JOIN chercheurs_personne p ON c.personne = p.id
LEFT JOIN ref_etablissement et ON et.id = c.etablissement