*This question is also in
http://stackoverflow.com/questions/26635406/django-query-in-detailview
I have DetailVIew wich returns a list of related objects (m2m throught). It
works just fine!
But I need to search for objects'names and it is returning all objects
instead of only the related ones.
How can I approach this?
Thanks.
#models.pyclass Candidate(models.Model):
user = models.OneToOneField(User, primary_key=True)
birth = models.CharField(max_length=50)
...
class Job(models.Model):
candidate = models.ManyToManyField('Candidate', through='CandidateToJob')
title = models.CharField(max_length=500)
...
class CandidateToJob(models.Model):
job = models.ForeignKey(Job, related_name='applied_to')
candidate = models.ForeignKey(Candidate, related_name='from_user')
STATUS_CHOICES = (
('1', 'Not approved'),
('2', 'Approved'),
('3', 'Hired')
)
status = models.CharField(max_length=2, choices=STATUS_CHOICES)
My search query
#views.py
def get_query(query_string, search_fields):
query = None # Query to search for every search term
terms = normalize_query(query_string)
for term in terms:
or_query = None # Query to search for a given term in each field
for field_name in search_fields:
q = Q(**{"%s__icontains" % field_name: term})
if or_query is None:
or_query = q
else:
or_query = or_query | q
if query is None:
query = or_query
else:
query = query & or_query
return query
def searchcandidate(request, *args, **kwargs):
query_string = ''
found_entries = None
if ('q' in request.GET) and request.GET['q'].strip():
query_string = request.GET['q']
entry_query = get_query(query_string, ['candidate__user__first_name',
'candidate__user__last_name'])
found_entries =
CandidateToJob.objects.filter(entry_query).order_by('-candidate')
return render_to_response('dashboard/candidates_results.html',
{ 'query_string': query_string, 'found_entries': found_entries },
context_instance=RequestContext(request)
)
The view with the list of objects(candidates)
class Screening(generic.DetailView):
model = Job
template_name = 'dashboard/screening.html'
def get_context_data(self, **kwargs):
context = super(Screening, self).get_context_data(**kwargs)
context['candidate_list'] =
self.object.applied_to.all().order_by('candidate')
return context
My urls
#urls.py
url(r'^dashboard/job/(?P<pk>\d+)/screening/$', views.Screening.as_view(),
name='screening'),
url(r'^dashboard/job/(?P<pk>\d+)/screening/results/$',
'companies.views.searchcandidate', name='searchcandidate'),
And the templates
#html for Screening(DetailView) in which works good<form class="" method="get"
action="{% url 'searchcandidate' job.pk %}">
<div class="input-group">
<input name="q" id="id_q" type="text" class="form-control"
placeholder="Buscar candidatos por nome" />
<span class="input-group-btn">
<button class="btn btn-orange" type="submit">Buscar</button>
</span>
</div></form>
{% for candidate in candidate_list %}
{{ candidate }}{% endfor %}
The one in which is returning all objects instead of only the related ones
#html{% if found_entries %}
{% for candidate in found_entries %}
{{ candidate }}
{% endfor %}{% endif %}
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/aa6a47b4-4043-44e1-99e4-60a0e2630358%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
