fix join SQL

diff --git a/project/rh/lib.py b/project/rh/lib.py
index 496afba..136df13 100644 (file)
--- a/project/rh/lib.py
+++ b/project/rh/lib.py
@@ -368,7 +368,7 @@ class EmployeAdmin(AUFMetadataAdminMixin, ProtectRegionMixin, admin.ModelAdmin):
     ordering = ('nom', )
     actions = ('desactiver', )
     form = EmployeAdminForm
-    list_display = ('id', 'nom', 'prenom', )
+    list_display = ('id', 'nom', 'prenom', 'date_modification',  'user_modification',)
     list_display_links = ('id', 'nom',)
     inlines = (AyantDroitInline,
                DossierROInline,
@@ -389,7 +389,8 @@ class EmployeAdmin(AUFMetadataAdminMixin, ProtectRegionMixin, admin.ModelAdmin):
     add_form_template = 'admin/change_form.html'
 
     def queryset(self, request):
-        return self.model.actifs.all()
+        qs = super(EmployeAdmin, self).queryset(request) 
+        return qs.filter(actif=True).select_related(depth=1)
 
     def save_formset(self, request, form, formset, change):
         instances = formset.save(commit=False)