Change List View Query

I want to override the query upon which a list view or report view gets data for only 1 particular doctype.

1 Like

You can try permission query Server Script

1 Like

This Feature is Great
I have a scenario in which i created a new doctype Team which is a tree structure and User wants to get list view of leads on the base of left side of tree means

1 manager
2 sales lead
and every sales lead has different team members

Team member can see only there leads which can be done by Lead Owner
Sales Lead can see only there team leads
and Manager can see both Sales Lead Leads
In this case i need query override to use join

I need to add or condition in list view . What can I do?