I'm not certain if this is a bug, or expected behavior. It certainly looks like a Django bug to me. However, after looking at the same database for hours on end, it could simply be a cross-eyed user error. In sort, the admin interface has the following search fields (I know this won't scale very well and is cumbersome. Unfortunately, it's the fields my customer wants to search; I also know that the first_service, second_service, etc. models breaks 2nd normal form.... however, again, it is my customer's preference =( ). search_fields = ['contact_name', 'alternate_contact_name', 'cross_reference', 'client_reference', 'info', 'people_involved__first_name', 'people_involved__last_name', 'people_involved__info', 'case_notes__notes', 'first_service__service', 'second_service__service', 'third_service__service', 'fourth_service__service', 'first_subcontractor__subcontractor', 'second_subcontractor__subcontractor', 'third_subcontractor__subcontractor', 'fourth_subcontractor__subcontractor' ] If you look at the following link, you'll see two 'cases': userid: admin password admin (this is a development instance for testing) If you notice in case 1, you'll notice that 'indigo' is a 'Person Involved' first name set up for testing. However, it is not found during a search. In summary, the following search fields work perfectly: * 'contact_name' * 'alternate_contact_name' * 'cross_reference' * 'client_reference' * 'info' While the remainders do not. Either I am not properly using the syntax of 'model, double underscore, field' to refer to the foreign model, I've made another mistake (or am missing a key piece of information), or this is a legitimate bug (i.e., foreign key lookups do not work). Any help you can give would be great. Then I would know that I need to go read something to learn from a mistake, or I need to break this down into a test case for a bug reproduction. I've tested this against the latest trunk with the same results. The admin.py file is attached. Thanks in advance, Glen Jarvis -- 415-680-3964 "You must be the change you wish to see in the world." -M. Gandhi |
from django.contrib import admin from django.contrib.auth.models import User from django.contrib.auth.admin import UserAdmin
from myproject.forensic_database.models import Case, CaseNote, Company,\
Country, Function, PeopleInvolved, Service, Subcontractor, Tool
forensic_admin = admin.AdminSite()
################
# User Section #
################
class UserAdmin(UserAdmin):
fieldsets = (
('Commonly Used', {
'fields': ['username', 'email', 'password',
('first_name', 'last_name'),
('is_active', 'is_staff', 'is_superuser'),
'user_permissions',
]
}
),
)
list_display = ('username', 'first_name', 'last_name',
'is_active', 'is_staff', 'is_superuser', 'last_login',
)
list_display_links = ('username', 'first_name', 'last_name',
'is_active', 'is_staff', 'is_superuser', 'last_login',
)
ordering = ('username', )
search_fields = ['username' ]
################
# Case Section #
################
class CaseNoteInline(admin.StackedInline):
model=CaseNote
fieldsets = (
('Case Note', {
'fields': ('date','notes', 'initials',),
'classes': ('collapse',),
}),
)
extra=1
class PeopleInvolvedInline(admin.StackedInline):
model=PeopleInvolved
fieldsets = (
('Person Involved', {
'fields': ('first_name','last_name', 'work_phone',
'mobile_phone', 'home_phone', 'email', 'info',),
'classes': ('collapse',),
}),
)
class CaseAdmin(admin.ModelAdmin):
fieldsets = (
('Case', {
'fields': (('case_number', 'company',),
('cross_reference', 'client_reference',),
('date_appointed', 'date_completed',),
('status', 'country',),
),
}),
('Contact Details', {
'fields': (('contact_name', 'contact_work_phone',
'contact_mobile_phone', 'contact_home_phone',
'contact_email'), ),
}),
('Alternate Contact Details', {
'fields': (('alternate_contact_name', 'alternate_contact_phone'),),
'classes': ('collapse',),
}),
('Image', {
'fields': ('image',),
'classes': ('collapse',),
'description': 'Select image to upload. Click Save when finished.'
}),
('Case Details', {
'fields': ('info', 'cost_analysis', 'report'),
'classes': ('collapse',),
'description': 'Contact Details'
}),
('Services and Equipment', {
'fields': (
('first_service', 'first_tool'),
('second_service', 'second_tool'),
('third_service', 'third_tool'),
('fourth_service', 'fourth_tool'),
),
'classes': ('collapse',)
}),
('Subcontractors', {
'fields': (
('first_subcontractor', 'first_function'),
('second_subcontractor', 'second_function'),
('third_subcontractor', 'third_function'),
('fourth_subcontractor', 'fourth_function'),
),
'classes': ('collapse',)
}),
)
date_hierarchy = 'date_appointed'
list_display = ('case_number', 'date_appointed', 'date_completed',
'company', 'contact_name', 'country', 'status',
)
list_display_links = ('case_number', 'date_appointed', 'date_completed',
'company', 'contact_name', 'country', 'status',
)
list_filter = ('status', 'country',
)
search_fields = ['contact_name', 'alternate_contact_name',
'cross_reference', 'client_reference', 'info',
'people_involved__first_name', 'people_involved__last_name',
'people_involved__info', 'case_notes__notes',
'first_service__service', 'second_service__service',
'third_service__service', 'fourth_service__service',
'first_subcontractor__subcontractor',
'second_subcontractor__subcontractor',
'third_subcontractor__subcontractor',
'fourth_subcontractor__subcontractor'
]
inlines= [
PeopleInvolvedInline, CaseNoteInline,
]
forensic_admin.register(User, UserAdmin)
forensic_admin.register(CaseNote)
forensic_admin.register(Company)
forensic_admin.register(Country)
forensic_admin.register(Function)
forensic_admin.register(PeopleInvolved)
forensic_admin.register(Service)
forensic_admin.register(Subcontractor)
forensic_admin.register(Tool)
forensic_admin.register(Case, CaseAdmin)
