How to hide other emplyee to see project which is not assign to him

ERPNext User Forum
1

in this project 4 employee there so it should visible to him only

but it is visible to others who is not in project

from role permission i removed but when i am giving role project user then he is also able to see others projects

Screenshot from 2024-08-13 12-59-17
Screenshot from 2024-08-13 12-59-171129×485 33.2 KB

2

@Prashanth_Kolhetkar you can write permission query for that.

3

Hi @Jeel i am writing this script but its not working

could you please suggest any correct script or can you modify my script

import frappe
from frappe.utils import flt

def get_permission_query_conditions(user):
if not user:
user = frappe.session.user

if "Employee" in frappe.get_roles(user):
    employee = frappe.get_value("Employee", {"user_id": user}, "name")
    if employee:
        return f"""(`tabProject`.name IN (
                      SELECT DISTINCT `tabProject Assignment`.parent
                      FROM `tabProject Assignment`
                      WHERE `tabProject Assignment`.employee = '{employee}'
                   ))"""
else:
    return ""

def has_permission(doc, user):
if “Employee” in frappe.get_roles(user):
employee = frappe.get_value(“Employee”, {“user_id”: user}, “name”)
if employee:
project_assignments = frappe.get_all(“Project Assignment”,
filters={“parent”: doc.name,
“employee”: employee})
return bool(project_assignments)
return True

4

@Prashanth_Kolhetkar please assign project to user from sidebar there is one assign to button click on this button and assign project to user