Get old data from same table for summarizing

Frappe Framework App Development
1

Hi community
I have a scenario where i need to get old data from a table via sql query and add to it the current values to have a sum which will be stored in the same data entry automatically.

Regards

2

Is it ERPNext related question or SQL? Sorry, your query is not very clear, can you explain little bit more.

3

Yes it is erpnext related i already try it in custom script frappe.db.sql but i get nothing if you can show me an exemple how to get data from database after a field selection
Thank you @KanchanChauhan
Regards

4

please share your custom script

please check the frappe.db.get_value method https://github.com/frappe/frappe/blob/develop/frappe/public/js/frappe/form/footer/timeline.js#L194

5

thank you @makarand_b
this is my code

` frappe.ui.form.on(“Gaz Consumption”, {
validate: function(frm) {
frm.trigger(“calculate_area”)
},

daily_production: function(frm) {
	frm.trigger("calculate_area")
},


calculate_area: function(frm) {
	if (frm.doc.daily_production){
		d = frappe.datetime.add_days("2016-05-03", -1);
		fetch = frappe.db.sql("Select cumul from `tabGaz Consumption` where date = (%s);",frappe.datetime.add_days(self.date),-1);
		area = flt(frm.doc.daily_production + fetch);
		frm.set_value('cumul', area);
	}
}

})`

6

frappe.db.sql is python method and can not be access on the client script, use the frappe.db.get_value method instead.

frappe.db.get_value("DocType Name", filter, fields, callback)

e.g. frappe.db.get_value("Gaz Consumption", {date: frappe.datetime.add_days(self.date),-1)}, "cumul", function(r) {
	frm.set_value("cumul", r.cumul)
})

e.g.

1 Like
7

shows me blank form
this is the final code

` frappe.ui.form.on(“Gaz Consumption”, {
validate: function(frm) {
frm.trigger(“calculate_area”)
},

daily_production: function(frm) {
	frm.trigger("calculate_area")
},

calculate_area: function(frm) {
	if (frm.doc.daily_production){
		frappe.db.get_value("Gaz Consumption", {date: frappe.datetime.add_days(self.date),-1)}, "cumul", function(r) {
frm.set_value("cumul", r.cumul);

})
}
}
})`

8

hi @makarand_b
after some modifications i get the form and this error makes me crazy

any idea

9

after some diging i do not get cumul field in the debugger list

10

@SOLOSOFT,

check the frappe.db.get_value result try to print the value of r in console e.g. console.log(r) and check if you are getting the cumul field.

Thanks,
makarand