Get list of all users with a role

[ninjas005]

Hi all,

How can we get the list of all users having a specific role in the python class?

Thanks in advance for the answers…

[max_morais_dmm]

Until frappe7

frappe.db.sql("SELECT DISTINCT parent FROM `tabUser Role` WHERE role=%s", ("System Manager",))

In frappe8

frappe.db.sql("SELECT DISTINCT parent FROM `tabHas Role` WHERE role=%s", ("System Manager",))

[ninjas005]

Thanks @max_morais_dmm

frappe.db.sql(“SELECT DISTINCT parent FROM tabUserRole WHERE role=%s”, (“System Manager”,))

this works

[ninjas005]

We can find the frappe version with frappe.__version__ right?

[max_morais_dmm]

@ninjas005 yes