Using Validate (server script) On Item group field in Item

ERPNext Customize ERPNext
, ,
1

Hi All,
I want to write code to work as a field trigger in (client script) but using server script,

my case is triggered when the item group field in the item is changed I want to run some functionality in the server script.

Is there any help?

2 
item_group = doc.item_group

if doc.item_group != item_group:
    frappe.msgprint(_("Item Group is changed."))

I need something like this because it is not working for me
@NCP kindly is there any way

3

Hmm :thinking:,

Please try it @Omar_Mohammed.

    previous_item_group = doc.get_db_value('Item', doc.name, 'item_group')

    if previous_item_group != doc.item_group:
        frappe.msgprint(_("Item Group is changed."))

Thank You!

4

Thank you for response

but I face this, and I search for documentation for get_db_value function
image

5 
import frappe

def on_update(doc, method):
    previous_item_group = doc.get_db_value('Item', doc.name, 'item_group')
    if previous_item_group != doc.item_group:
        frappe.msgprint(_("Item Group is changed."))

Please add doc_event in hook.py in custom app and set code your according.

Thank You!

6

I face a same error message

TypeError: BaseDocument.get_db_value() takes 2 positional arguments but 4 were given

7

Is get_db_value built-in or officially documented function?

8

You can try this!

image
image1616×658 61.5 KB

1 Like
9

I found this

image
image1135×501 101 KB

I also try frappe.db.get_value but it’s not returen before the change is getting the value after the change

10

yes, it is.

11

Thank you so much it’s working as I want.

Thank you for your help @NCP

12

No worries!

1 Like