How to fetch data from master doctype in jinja?

Frappe Framework Print Formats
1

I want to fetch the address and contact of the supplier here, how can I do that? I am using the Purchase Order to make this print format:

<div class="supplier">
    <p>{{ doc.supplier_name }}</p>
    <p>{{ supplier_address }}</p>
    <p>{{ supplier_contact }}</p>
</div>
2

@Hamza3351 U can try this code

Supplier Address
<p>{{doc.address_display }}</p>

Billing Address
<p>{{doc.billing_address_display }}</p>

Shipping Address
<p>{{doc.shipping_address_display }}</p>

Contact Details
<p>{{ doc.contact_display or ""}}</p>

Mobile No
<p>{{ doc.contact_mobile or "" }}</p>

Email
<p>{{ doc.contact_email or "" }}</p>

1 Like
3

How do I get the contact no?

4

Mobile No
<p>{{ doc.contact_mobile or "" }}</p>

1 Like
5

It’s not working, Here you can see I have address and contact details filled but it doesn’t shows in the print format:

image
image1279×629 74 KB

Nothing in the print format:

image

7

Supplier Address
<p>{{doc.address_display }}</p>

Contact Details
<p>{{ doc.contact_display}}</p>

1 Like
8

I have tried this but no good as you can see my previous reply…

9

@Hamza3351 as you see this is my test and it worked well ??!

image
image1352×498 33.7 KB

image
image1364×572 45.2 KB

image
image1364×619 63 KB

1 Like
10

you can fetch with this

image
image1110×216 17.8 KB

Example:

frappe.db.get_value("Contact", {"customer": doc.customer}, "mobile_no")

1 Like
11

I have tried this code but I can fetch the static data only:

<div class="supplier">
    {% set address = frappe.db.get_value('Address', '786 MALIK GOODS-Billing', ['address_line1']) %}
    {% set contact = frappe.db.get_value('Contact', '786 MALIK GOODS-786 MALIK GOODS', ['phone']) %}
    
    <p>{{ doc.supplier_name }}</p>
    <p>{{ address }}</p>
    <p>{{ contact }}</p>
</div>

image

12

Error in print format on line 27: (1054, “Unknown column ‘customer’ in ‘where clause’”)

13

You are using print builder, try it in a custom format if it works

14

Try this

<div class="supplier">
    {% set address = frappe.db.get_value("Address", {"address_title": doc.supplier}, "address_line1") %}
    <p>{{ doc.supplier_name }}</p>
    <p>{{ address }}</p>
</div>

I have tested

1 Like
15

This one works fine , thanks

16

If you want to fetch all mobile number from the table

you can fetch same like this

1 Like
17

do I fetch it like this:

{% set contact = frappe.db.get_value("Contact", {"contact_title": doc.supplier}, "phone") %}
18

image
image950×359 21.3 KB

image
image1361×351 23.5 KB

image
image1364×559 46 KB

19

In summary, this is how we can fetch both, we just need to find a link between the name of the field and the doctype which it is linked to:

<div class="supplier">
    {% set address = frappe.db.get_value("Address", {"address_title": doc.supplier_name}, "address_line1") %}
    {% set contact = frappe.db.get_value("Contact", {"first_name": doc.supplier_name}, "phone") %}
    
    <p>{{ doc.supplier_name }}</p>
    <p>{{ address }}</p>
    <p>{{ contact }}</p>
</div>
20

image