(assuming there exists a relation between your (two?) models)
http://docs.djangoproject.com/en/dev/topics/db/queries/#backwards-related-objects
"If a model has a ForeignKey, instances of the foreign-key model will
have access to a Manager that returns all instances of the first
model. By default, this Manager is named FOO_set, where FOO is the
source model name, lowercased. "
good luck,
TR
2011/2/25 Thomas Rega <thoreg@googlemail.com>:
> could you paste the definition of the models? I think there is the
> need of a relationship between 'Data_Siswa' and 'Users'.
>
> regards,
> TR
>
>
> 2011/2/22 <delegbede@dudupay.com>:
>> I'm not so sure if I'm answering your question but there's a way you can chain querysets.
>> In your views.py file import Q from django.db.models.
>> You could check django documentation. I think it works well.
>> Sent from my BlackBerry wireless device from MTN
>>
>> -----Original Message-----
>> From: Ryan Wijaya <ryankaskuser@gmail.com>
>> Sender: django-users@googlegroups.com
>> Date: Tue, 22 Feb 2011 07:01:49
>> To: Django users<django-users@googlegroups.com>
>> Reply-To: django-users@googlegroups.com
>> Subject: How to merge querysets and sort it?
>>
>> For me it takes more than a week to solve it alone...
>> So to the point, is it possible to merge two querysets and sort it as
>> well?
>> Recently I've used itertools, but it returns a table with duplicated
>> value and requested objects not properly displayed (the get_full_name
>> displayed separately with other, creating a new row)
>>
>>
>> here's the codes
>> views.py
>>
>> def view_siswa(request):
>> # list_detail.object_list, {"queryset": Data_Siswa.objects.all(),
>> "template_name": "views/view-siswa-list.html"}
>> namasiswa = User.objects.all().exclude(is_staff='false')
>> datasiswa = Data_Siswa.objects.all().order_by('kode_nis')
>> query = chain(datasiswa, namasiswa)
>> variables = RequestContext(request, {'siswa':query,})
>> # variables = RequestContext(request, {'siswa':datasiswa,})
>> return render_to_response(
>> 'views/view-siswa-list.html',
>> # { 'siswa':namasiswa, 'datasiswa': datasiswa, }
>> variables,
>> )
>>
>>
>> template
>>
>> {% for object in siswa %}
>> <tr>
>> <td scope="row"class="spec">{{ object.username }}</td>
>> <td scope="row">{{ object.kode_nis }}</td>
>> <td scope="row">{{ object.first_name }}</td>
>> <td scope="row">{{ object.kode_jurusan }}</td>
>> <td scope="row" width="20px"><a href="/jurnal/siswa/
>> {{ object.id }}/">Lihat</a></td>
>> <td scope="row" width="20px">Edit</td>
>> </tr>
>> {% endfor %}
>>
>>
>> Muchly appreciated any help... btw I'm new in Django
>>
>> Regards
>>
>> Rian
>>
>> --
>> You received this message because you are subscribed to the Google Groups "Django users" group.
>> To post to this group, send email to django-users@googlegroups.com.
>> To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
>> For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
>>
>> --
>> You received this message because you are subscribed to the Google Groups "Django users" group.
>> To post to this group, send email to django-users@googlegroups.com.
>> To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
>> For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
>>
>>
>
>
>
> --
> --- http://thoreg.org/ ---
>
--
--- http://thoreg.org/ ---
--
You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
No comments:
Post a Comment