Bulk Update for multiple fields

Frappe Framework
1

Need to perform bulk update for multiple fields at same time.

frappe.call({ method: 'frappe.desk.doctype.bulk_update.bulk_update.update', 
				      args: { doctype: 'doctype', 
						field: [cur_frm.doc.field1,cur_frm.doc.field2], 
						value: [value1,value2], 
						condition: "name='"+field_id+"'"
					    },

For single field,its working but not working with multiple field-values.
Any help will be deeply appreciated.

Thanks In Advance

2

what is field_id??

3

it is the id of field where i want to update the fields

4

which is custom variable??

5

value 1 and value 2

6

Looking at frappe.desk.doctype.bulk_update.bulk_update.py doesn’t seem like it can handle multiple fields at once.
`…
data[field] = value
…

7

So any alternate approach to do the same ??

Updating multiple field values for multiple doc forms ??

8

If you are able to modify py, you could create a custom whitelisted action in your custom app. I don’t think this is generic enough requirement to be pushed in as PR

9

Any way else to update multiple fields at same time via custom script ?

10

RBAR… You can update one field at a time in for loop,if it’s just 2 fields, can try run_serially()

11

can you give some references for using run_serially()

12
13

You could try something like

		let tasks = [];
		var update = function (field_id, field, value) {
			return frappe.call({
				method: 'frappe.desk.doctype.bulk_update.bulk_update.update',
				args: {
					doctype: 'doctype',
					field: field,
					value: value,
					condition: `name='${field_id}'`
				},
			});
		};

		tasks.push(() => {
			return update("1", "1", "1");
		});

		tasks.push(() => {
			return update("2", "2", "2");
		});

		return frappe.run_serially(tasks);
14

u mean to say let field has 3 fields in comma seperated and values also has 3 values comma seperated so

return update("1", "1", "1");

will choose first value and field automatically and so does for the next one ?

15

I mean like

return update("field_id", "field1", "value1");

and

return update("field_id", "field2", "value2");
16

and what if I want to update 5 fields of id-A, 5 fields of id-B and 5 fields of id-C at same time where fields for all are same (ie field 1,2,3… are same for all three A,B and C)

17

check this i think this help you.

1 Like
18

Some changes and it worked.

Thanks…!!