Appending To a Field Value

How can i append a text-field values .Is there any function like update ,and i want to do it from server side scripting ,can anyone give me suggestions

for update the value in any form using its name and field name

frappe.db.set_value("DocType", docname, "fieldname", value_to_set)
1 Like

But when i want to set the value from a sql query ,which is returning multiple rows how can i do it …

Can you explain in detail? So I can help you better. What are you trying to do?

Well i am trying to get the serial no names from the items table and trying to append them in the text field in another document .
Here is my code

So, Checker is your doctype in that you are updating serial no series.

As I see you are accessing series no incorrectly. It should be like,

    item_series_no = frappe.db.sql("""select serial_no_series 
    	from tabItem where serial_no_series is not null""", as_dict=True)
    for series in item_series_no:
    	print series.get('serial_no_series')  #this gives you series_no

Thanks for that reply but i want to insert that rows values means the serial no into the text field but the update is updating for every iteration and erasing the previous ones ,how can i get all of them in the text field.

because you are updating field value in for loop. Make it as one and then update.

item_series_no = frappe.db.sql("""select group_concat(serial_no_series)  as series_no 
	from tabItem where serial_no_series is not null""", as_dict=True)
if item_series_no[0].get('series_no'):
	a.update('text': item_series_no[0].get('series_no'))

Well i tried it nothing is happening in the new doctype created with empty field…

check my given query for item_series_no