custom list view query help

[blitz2190]

this is a new concept to me so i don't know where to start, i want this where clause to be added to the list view query regardless of a search or first time loading the list view,

assigned_user_id = '$cur_user' OR man_id = '$cur_user'

where $cur_user will contain the current user id. I have heard about the create_new_list_query() and custom controller.php but I am at a loss on how or where to make these changes any help would be great.

[chrislynch8]

Solutions is about three post down

http://www.sugarcrm.com/forums/showthread.php?t=58494

[blitz2190]

thank you this worked great, and for anyone else reading this i used the example chrislynch8 provided in his first post.

[blitz2190]

next question, right before the where statements i put this $bean->db->query($query,true) to get some other info form another table and it displays a blank list, any ideas?

*EDIT*
found the answer it should be $this->bean->db->query($query,true)