Web page that displays a doctype's data not working

1

Hello, I’m very new to frappe so I was working on our list and we are also using a custom module, so back to the topic I was working on our list that should display a data however the outcome was different it only displayed a header or a table header a say but it didn’t fetch the data from the specific doctype we were using

VirtualBox_STSM Library ErpNext_18_05_2022_16_52_33
VirtualBox_STSM Library ErpNext_18_05_2022_16_52_331920×985 84.9 KB

2

here are the codes

VirtualBox_STSM Library ErpNext_18_05_2022_17_56_09
VirtualBox_STSM Library ErpNext_18_05_2022_17_56_091920×985 125 KB

3

VirtualBox_STSM Library ErpNext_18_05_2022_17_55_52
VirtualBox_STSM Library ErpNext_18_05_2022_17_55_521920×985 153 KB

4

Hi there,

It’s a bit hard to read in screenshots like this, but you appear to define the get_context method twice? The second is overwriting the first, and as a consequence there’s no variable called book_list for your jinka template to parse.

5

hmmm I see so how should I do it? and sorry for the picture do and thank you for helping me since I will removing that duplicated get_context method

6

Just erase the first method and keep the second one. I believe you need to return context too, but I can’t remember off hand and I’m not in a position to test right now. Make sure the variable you’re exporting matches the name you’re using in your jinka template.

7

ok I already did what you said but the same outcome

8

What have you done to troubleshoot?

9

remove the first method added return context and edited the variables lemme send you a code picture

10

here are the codes

book_list.html


<h2> Books List </h2>

{% if booker_list %}

  <head>
    <style>
      table {
        font-family: arial, sans-serif;
        border-collapse: collapse;
        width: 100%;
      }

      td, th {
        border: 1px solid #dddddd;
        text-align: left;
        padding: 8px;
      }

      tr:nth-child(even) {
        background-color: #dddddd;
      }
    </style>
  </head>

  <table>
      <tr>
        <th>Title</th>
        <th>Author</th>
        <th>Subject</th>
      </tr>
    {% for books in book_list %}
      <tr>
        <td>{{ books.get("title", "")  }} </td>
        <td>{{ books.get("lbks_author", "") }}</td>
        <td>{{ books.get("lbks_subject", "") }}</td>
    {% endfor %}
  </tr>
  </table>

{% else %}

  <p style="font-size:36px; ">No orders!</p>

{% endif %}

book_list.py

import frappe


def get_context(context):
    context.booker_list = frappe.get_list("Library Books", fields=["title", "lbks_author", "lbks_subject"])
                          ##end of function

    return context
11

just correct the codes so we can finish this fast lol

12

Sorry mate, but I’m not your employee. If you’re looking for someone to do the work for you, there are many places where you can hire an erpnext freelancer. Good luck.

13

my bad but yeah what should I change do? didn’t mean it to be a bossy approach do trying to approach it in a joking way

14

appreciate your help I’ll just have to pass this to our school without the custom page

15

The documentation is an important piece here, but more than anything I would suggest brushing up on your Jinja. You’ve got a line:

{% for books in book_list %}

…but nowhere do you define a variable called book_list. You did in your original script, but defined the same method twice.