How to use frappe.db in jinja template in report print format html file

nishith · January 31, 2017, 1:37pm

we can use frappe.db.get_value in normal jinja print format of document but i am not able to use the same syntax in html of report. is there any way to achieve similar result.

max_morais_dmm · January 31, 2017, 4:31pm

@nishith it’s not a jinja! It’s something that sounds like jinja, but is not jinja!

It’s a javascript templated renderized in the front-end site in many cases!

You can use frappe.call instead of frappe.db.get_value

nishith · February 1, 2017, 5:05am

Ok Thank You @max_morais_dmm
Can you please give me one example how to use frappe.call in that html…?

makarand_b · February 1, 2017, 6:58am

@nishith,

Please check the task_info.html for example. Although it is used in Page instead of Report.

github.com

frappe/erpnext/blob/develop/erpnext/templates/pages/task_info.html#L127


      
          							var args = {
          								comment_by_fullname: "test",
          								comment_by: "admin@localhost.com",
          								comment: $("[name='comment']").val(),
          								reference_doctype: "Task",
          								reference_name: "TASK00069",
          								comment_type: "Comment",
          								route: "tasks",
          							}
          
          							frappe.call({
          								btn: this,
          								type: "POST",
          								method: "frappe.templates.includes.comments.comments.add_comment",
          								args: args,
          								callback: function(r) {
          									if(r.exc) {
          										if(r._server_messages)
          											frappe.msgprint(r._server_messages);
          									} else {
          										$(r.message).appendTo("#comment-list");

Thanks,
Makarand

nishith · February 1, 2017, 7:08am

Thanks for the response @makarand_b , but I don’t want to use it in jinja. It’s general_ledger.html file which is look like jinja but not jinja.

netchampfaris · February 1, 2017, 9:15am

As @max_morais_dmm said,
It’s not jinja, it is a js template.
You can use them as

frappe.db.get_value(doctype, docname, fieldname, function(value) {
  frappe.render_template('template_name', { value: value });
})

nishith · February 1, 2017, 1:01pm

I have already used this but it shows that get_value is undefined i.e that function is not accessible in general_ledger.html file. Is there any way to include that function in this file.?

netchampfaris · February 1, 2017, 1:22pm

nope, you can’t do async calls in templates

root13F · January 20, 2018, 10:31am

Can jinja be used for report print formats ?

clarkej · June 9, 2020, 9:34pm

Yes, at least now two years later the docs state that’s the case -

“Frappe allows you to create custom Print Formats for your Query and Script Reports.”

Read on https://frappeframework.com/docs/user/en/printing#print-formats-for-reports

However since reports are generated on the server, perhaps that means only serve-side Jinja and not JS is the only option here?

gopikrishnan · May 4, 2024, 12:56pm

I’m currently working on a script report with a custom template. Could someone please guide me on how to properly set up this template in frappe.templates?