Query realated fetch the doc name in print format

[suvarna_bhangare]

Hie all,
i want to get creator name of material request form inside the purchase order…i wrote {{ frappe.db.get_value(“Material Request”,doc.items[0].material_request,“owner”) }} but its shows maild of the creator…as we need we want to show name of the creator of the person who create the material request
Please help me with that

[makarand_b]

@suvarna_bhangare

frappe.db.get_value(“Material Request”,doc.items[0].material_request,“owner”) }}

it will fetch the user’s email ID. To get the Full name in the print format add the hidden custom field full name and set the user’s full name in the field on validate.

Then, you can use the frappe.db.get_value("Material Request",doc.items[0].material_request,"fullname") }}

Thanks,
Makarand