sorting the Assigned column on the list page

Hi all,

 

I am working on an enhancement to sort the list by assigned.
This is
proving to be more complex than I originally thought since
the issues
are already sorted before the assigned are retrieved. But,
for the
initial query the two tables are joined (eventum_issue and
eventum_issue_user) but the field I want to sort on is
usr_full_name
which is pointed to by both iss_usr_id from eventum_issue
and isu_usr_id
in eventum_issue_user. Now by SQL is not that strong. What
would the
difference in the queries be if I wanted to sort by
usr_full_name
pointed to by isu_usr_id.

 

 

I hope that was understandable,

 

Thanks in advance,

 

Barry