How to get Link(ed) document with frappe.get_list?

Frappe Framework App Development
1

I have a doctype with a Link field. For example, how the customer is linked to a Quotation in ERPNext.

With frappe.get_all, I can specify fields to get in the ‘list of dicts’ in my templates. This is fine. But now, Should I make an extra db call to fetch details about the Link(ed) document?

Is there a way to get the linked document in the initial get_all call, as another dict?

EDIT
For those familiar with Django ORM. This can be likened to how I can make the following query:

order.customer.name  # Getting linked Doc's fields
1 Like
2

AFAIK you need frappe.get_doc

3

I have used this before. But if I’m looping a lot of records, won’t it make a lot of db queries?

4

I think it would be the same. I mean the linked document is a record in a different DB table so even get_list would have to make a DB call on that table to fetch you the linked document fields.

5

You don’t necessarily need to write a script for this. This can easily be fixed by adding a fetch from property in the doctype settings? Elaborate your use case.

6

I have given an example of what I want to achieve

7

The purpose for you starting this thread is to get help in the issue you’re facing, however a doctor cannot help a patient if the patient is unwilling to tell where it hurts.