by the above it is not giving any error but it is not showing the correspondence names and also it is showing all the fields in detail :-((
please help On Wed, 4 Sep, 2019, 4:10 PM Anirudh Jain, <[email protected]> wrote: > Then simply use {{ obj.book_name.name }} in template where again, I am > assuming 'name' is the column name you have give to book name in Books model > > On Wed, Sep 4, 2019 at 3:25 PM Amit Samanta <[email protected]> > wrote: > >> You have gussed correctly.. >> but i have taked book id as fk but i need the book name >> >> On Wed, 4 Sep, 2019, 2:41 PM Anirudh Jain, <[email protected]> >> wrote: >> >>> This can be done easily if you make a proper view function and render >>> data from it in template properly. >>> A view function can be written like this :- >>> >>> Here I am assuming that you want get the details of all the >>> books/auuthors at one page. If you want details of a particular book, then >>> the following function will be different. >>> >>> from .models import Details, Author, Books >>> from django.shortcuts import render >>> >>> view.py :- >>> def getdetails(request): >>> template_name = 'showDetails.html' >>> objs = Details.objects.all() >>> context = {'objs; : objs} >>> return render(request, template_name, context} >>> >>> >>> showDetails.html :- >>> (use this block in your html code wherever you want to show this data) >>> >>> {% if objs %} >>> >>> <table> >>> <tr> >>> <th>Author</th> >>> <th>Book</th> >>> </tr> >>> >>> {% for obj in objs %} >>> <tr> >>> <td>{{ obj.author_name }} </td> >>> <td>{{ obj.book_name }} </td> >>> </tr> >>> {% endfor %} >>> </table> >>> >>> {% endif %} >>> >>> (In above html code, I have assumed that author_name and book_name are >>> the FK in your Details table. Also, I am not sure >>> >>> >>> On Wed, Sep 4, 2019 at 1:34 PM Lim Kai Wey <[email protected]> wrote: >>> >>>> Hey Amit, >>>> >>>> I suggest you to follow this tutorial to build your project, >>>> >>>> https://developer.mozilla.org/en-US/docs/Learn/Server-side/Django/Tutorial_local_library_website >>>> >>>> It teaches you all the basics that you need to know from scratch, which >>>> in my opinion will answer all the questions you're asking. >>>> The tutorial is about building a local library webpage which I believe >>>> is very similar to what you are doing now. >>>> >>>> Hope this helps. >>>> >>>> Regards, >>>> Kai Wey >>>> >>>> On Wed, Sep 4, 2019 at 3:59 PM Amit Samanta <[email protected]> >>>> wrote: >>>> >>>>> now how can i get the name for author and details?? >>>>> >>>>> On Wed, 4 Sep, 2019, 10:25 AM Bhoopesh sisoudiya, < >>>>> [email protected]> wrote: >>>>> >>>>>> Hi Amit, >>>>>> >>>>>> You can use >>>>>> =================≠===================== >>>>>> Book.objects.select_related(FK).select_related(FK). values (select >>>>>> column name which you want).all() >>>>>> >>>>>> >>>>>> Thanks >>>>>> Bhoopesh sisoudiya >>>>>> >>>>>> On Wed, Sep 4, 2019, 9:38 AM Amit Samanta <[email protected]> >>>>>> wrote: >>>>>> >>>>>>> Hi, >>>>>>> >>>>>>> I need help i am not understanding the keywords of joining and fetch >>>>>>> value in veiw.py >>>>>>> i have three tables in model.py >>>>>>> >>>>>>> Table 1(Author) : >>>>>>> >>>>>>> Table 2(books): >>>>>>> >>>>>>> Table 3 (details): >>>>>>> FK of table1 >>>>>>> FK of table2 >>>>>>> >>>>>>> Fk = foreign key >>>>>>> >>>>>>> I have to just show >>>>>>> >>>>>>> Author (author name) Books (dynamic) Books(author 2nd book) >>>>>>> ... >>>>>>> details(dynamic) >>>>>>> details(dtl of author 2nd book) ... >>>>>>> >>>>>>> I have created the template >>>>>>> >>>>>>> now in views.py i an confused >>>>>>> >>>>>>> book=books.object(i do not get what to do) >>>>>>> Author= (same ) >>>>>>> details = (same) >>>>>>> >>>>>>> Please can anybody help that will be very greatfull. >>>>>>> Thank you in advance >>>>>>> >>>>>>> >>>>>>> >>>>>>> Thanks and Regards >>>>>>> Amit Samanta >>>>>>> >>>>>>> -- >>>>>>> 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 [email protected]. >>>>>>> To view this discussion on the web visit >>>>>>> https://groups.google.com/d/msgid/django-users/54483cc3-eadd-4559-8c61-c179cfbab933%40googlegroups.com >>>>>>> <https://groups.google.com/d/msgid/django-users/54483cc3-eadd-4559-8c61-c179cfbab933%40googlegroups.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 [email protected]. >>>>>> To view this discussion on the web visit >>>>>> https://groups.google.com/d/msgid/django-users/CAAk3c1OzGXKSQg8GK1C8_5Ck-iQ%2B1WjsYMdD%2B%2B0_q3inb94jyw%40mail.gmail.com >>>>>> <https://groups.google.com/d/msgid/django-users/CAAk3c1OzGXKSQg8GK1C8_5Ck-iQ%2B1WjsYMdD%2B%2B0_q3inb94jyw%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 [email protected]. >>>>> To view this discussion on the web visit >>>>> https://groups.google.com/d/msgid/django-users/CAP4hbAY%3DvOB%2BEs6hZ77jcAU_-LuuG51LkqEPU3eB5nrgqS48ow%40mail.gmail.com >>>>> <https://groups.google.com/d/msgid/django-users/CAP4hbAY%3DvOB%2BEs6hZ77jcAU_-LuuG51LkqEPU3eB5nrgqS48ow%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 [email protected]. >>>> To view this discussion on the web visit >>>> https://groups.google.com/d/msgid/django-users/CAPcVkjg11EAf-rYFvoz85Y5BLKBisD4FJQSOCzonzi0TFC91ZQ%40mail.gmail.com >>>> <https://groups.google.com/d/msgid/django-users/CAPcVkjg11EAf-rYFvoz85Y5BLKBisD4FJQSOCzonzi0TFC91ZQ%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>> >>> >>> -- >>> *Anirudh Jain* | *Appreciate you taking time to read the mail.* >>> >>> -- >>> 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 [email protected]. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/django-users/CAC3mK7diFxarM6W-Tv-wT-sFZz6A46brHP%2Bjo772jKcn_qjbJQ%40mail.gmail.com >>> <https://groups.google.com/d/msgid/django-users/CAC3mK7diFxarM6W-Tv-wT-sFZz6A46brHP%2Bjo772jKcn_qjbJQ%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 [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/django-users/CAP4hbAZAaqfetvLBhgq%3DJ7X6m9nBBJUDTwAKorhKyTuLRBzTkA%40mail.gmail.com >> <https://groups.google.com/d/msgid/django-users/CAP4hbAZAaqfetvLBhgq%3DJ7X6m9nBBJUDTwAKorhKyTuLRBzTkA%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> > > > -- > *Anirudh Jain* | *Appreciate you taking time to read the mail.* > > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/CAC3mK7f__He3v0nW4TYyK7%3Da86-TZr%3D7wRPcSz1NiVwtQ6N-gg%40mail.gmail.com > <https://groups.google.com/d/msgid/django-users/CAC3mK7f__He3v0nW4TYyK7%3Da86-TZr%3D7wRPcSz1NiVwtQ6N-gg%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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAP4hbAYD53P_JAjmzzOjKhBd3_E7d6rKw%3D0A2O1rcik9ZR70zg%40mail.gmail.com.
