In certain condition I need add join table in the query in the funtion create_query_list in each module for listView
for a module 'MY'


for example, the module 'My'( in MY.php)
I show this function create_list_query in blew, we can call this query in general.
But in certain condition, I need add 2 join table in this query.

HOW Can I solve this problem???

OR

Is there another solution???


function create_query_list(){

$custom_join = $this->custom_fields->getJOIN();
$query = "SELECT users.user_name as assigned_user_name ";

if($custom_join){
$query .= $custom_join['select'];
}

$query .= " ,properties.*, document_revisions.id as document_revision_id FROM properties ";
$query .="LEFT JOIN users ON properties.assigned_user_id=users.id ";
$query .="LEFT JOIN documents ON properties.id = documents.parent_id ";
$query .="LEFT JOIN document_revisions ON documents.document_revision_id = document_revisions.id ";
}
Edit/Delete Message