I think you could solve your "problem" by usage of backward related objects ... (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 <tho...@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 <delegb...@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 <ryankasku...@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+unsubscr...@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+unsubscr...@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+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.