function getInstancesQueryComps($params, $logic, $order)
{
$res = parent::getInstancesQueryComps($params, $logic, $order);
$res['from'] = '(' . $res['from'] . ') LEFT OUTER JOIN family family ON family_note.familyid = family.id';
$res['select'][] = 'family.family_name as family_name';
return $res;
}
function getInstancesQueryComps($params, $logic, $order)
{
$res = parent::getInstancesQueryComps($params, $logic, $order);
$res['from'] = '(' . $res['from'] . ') LEFT OUTER JOIN person person ON person_note.personid = person.id';
$res['select'][] = 'person.first_name as person_fn';
$res['select'][] = 'person.last_name as person_ln';
return $res;
}