I have entity "Work Order" for which I have defined many custom views. Work Orders can have records with statuses as "active ,cancelled, closed, inprogress, submitted" etc. My requirement is - currently logged in user who belongs to a specific team "sales representative" should be able to see all records on view. If current logged in user does not belongs to "sales representative" team, she should not be able to see "cancelled" records on view but all other record should be visible. How can I achieve this using custom filters if it is possible? Or by code changes?
*This post is locked for comments