I want to make the same as this below but using django. That is what I want. The data are in one table but display shows child table
https://datatables.net/examples/server_side/row_details.html any one help please On Wed, 13 Oct 2021 at 14:28, Ammar Mohammed <amarben1...@gmail.com> wrote: > Hello Dear > > You can use djangos prefetch_related in the docs : > > prefetch_related()¶ > <https://docs.djangoproject.com/en/1.10/ref/models/querysets/#prefetch-related> > prefetch_related(**lookups*)¶ > <https://docs.djangoproject.com/en/1.10/ref/models/querysets/#django.db.models.query.QuerySet.prefetch_related> > > Returns a QuerySet that will automatically retrieve, in a single batch, > related objects for each of the specified lookups. > > This has a similar purpose to select_related, in that both are designed > to stop the deluge of database queries that is caused by accessing related > objects, but the strategy is quite different. > > select_related works by creating an SQL join and including the fields of > the related object in the SELECT statement. For this reason, > select_related gets the related objects in the same database query. > However, to avoid the much larger result set that would result from joining > across a ‘many’ relationship, select_related is limited to single-valued > relationships - foreign key and one-to-one. > > prefetch_related, on the other hand, does a separate lookup for each > relationship, and does the ‘joining’ in Python. This allows it to prefetch > many-to-many and many-to-one objects, which cannot be done using > select_related, in addition to the foreign key and one-to-one > relationships that are supported by select_related. It also supports > prefetching of GenericRelation > <https://docs.djangoproject.com/en/1.10/ref/contrib/contenttypes/#django.contrib.contenttypes.fields.GenericRelation> > and GenericForeignKey > <https://docs.djangoproject.com/en/1.10/ref/contrib/contenttypes/#django.contrib.contenttypes.fields.GenericForeignKey>, > however, it must be restricted to a homogeneous set of results. For > example, prefetching objects referenced by a GenericForeignKey is only > supported if the query is restricted to one ContentType. > > For example, suppose you have these models: > > from django.db import models > class Topping(models.Model): > name = models.CharField(max_length=30) > class Pizza(models.Model): > name = models.CharField(max_length=50) > toppings = models.ManyToManyField(Topping) > > def __str__(self): # __unicode__ on Python 2 > return "%s (%s)" % ( > self.name, > ", ".join(topping.name for topping in self.toppings.all()), > ) > > and run: > > >>> Pizza.objects.all() > > Url : https://docs.djangoproject.com/en/1.10/ref/models/querysets/ > > > On Wed, 13 Oct 2021, 2:06 PM Eugene TUYIZERE, <eugenetuyiz...@gmail.com> > wrote: > >> Dear All, >> >> Kindly assist me to have a tutorial or code to make this kind of table in >> django. I failed to do this from the datatable .net tutorial. >> [image: image.png] >> >> regards, >> >> -- >> * Eugene* >> >> -- >> 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 view this discussion on the web visit >> https://groups.google.com/d/msgid/django-users/CABxpZHuY_zoSvcwQL79UPts6g%3DmJRD%3DO_B%2Bc5%3DvinOtPKNLFLw%40mail.gmail.com >> <https://groups.google.com/d/msgid/django-users/CABxpZHuY_zoSvcwQL79UPts6g%3DmJRD%3DO_B%2Bc5%3DvinOtPKNLFLw%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> > -- > 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 view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/CAHs1H7vL%3Dzawt%2BqPiBU1qrZojSLpdjZuMWYiWT3jic-8dZfTEw%40mail.gmail.com > <https://groups.google.com/d/msgid/django-users/CAHs1H7vL%3Dzawt%2BqPiBU1qrZojSLpdjZuMWYiWT3jic-8dZfTEw%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > -- *TUYIZERE Eugene* *Msc Degree in Mathematical Science* *African Institute for Mathematical Sciences (AIMS Cameroon)Crystal Garden-Lime, Cameroon* Bsc in Computer Science *UR-Nyagatare Campus* Email: eugene.tuyiz...@aims-cameroon.org eugenetuyiz...@gmail.com Tel: (+250) 7 88 26 33 38, (+250) 7 22 26 33 38 -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CABxpZHtwZg6JVSMa4Gbc%2B2cb1obRNs5mxsX95qghNAsM23%2B%2BUg%40mail.gmail.com.
