List view - display the record based on who all are "reporting to" to current user

Hi all,

I want to display the list view as per user, Who all are “reporting to” to current user their records.

I written function to retrieve all the user id’s below the current user. (current user - > senior level - > junior level 1 -> junior level 2)

I have added where condition in modules/<module_name>/module_name.php (modules/leads/leads.php)

function create_new_list_query(){

$where = leads.assigned_user_id IN(‘current_user_id’,‘id1’,‘id2’,‘id3’,‘id4’);


But i not able to get all the records and also am getting less counts.

Kindly let me know to achieve on this.

Note: if you not understand the question please ask me back.