Incorrect syntax near '*'.: SELECT TOP 6 * FROM

[eggsurplus]

Incorrect syntax near '*'.: SELECT TOP 6 * FROM
(
SELECT ROW_NUMBER() OVER (ORDER BY calls.id) AS row_number, count(*) counter, calls.id , calls_cstm.*, calls.status , calls.name , calls.duration_hours , calls.duration_minutes , calls.date_start , calls.assigned_user_id
from calls left join calls_cstm on calls.id = calls_cstm.id_c inner join calls_users on calls.id = calls_users.call_id where (((calls.status in ('planned')
))) and calls.deleted=0 and calls_users.deleted = 0 and (calls.assigned_user_id = '1' or calls_users.user_id = '1')
group by calls.id, calls_cstm.*, calls.status, calls.name, calls.duration_hours, calls.duration_minutes, calls.date_start, calls.assigned_user_id
) AS a
WHERE row_number > 5


calls_cstm.* is in the group by clause instead of each custom field that is referenced. We get this if on the Calls dashlet and we hit next for the next set of results.

[eggsurplus]

This only happens when you have "My Calls" checked. So it must be something with:

             $lvsParams = array(
                           'custom_from' => ' INNER JOIN calls_users ON calls.id = calls_users.call_id ',
                           'custom_where' => ' AND calls_users.deleted = 0 AND (calls.assigned_user_id = \'' . $current_user->id . '\' OR calls_users.user_id = \'' . $current_user->id . '\') ',
                           'distinct' => true
                           ); 
  

in MyCallsDashlet.php. Having these params set must cause it to create a different list query. Will have more info later along with a resolution.

[eggsurplus]

Setting distinct to false in the code snippet above solved the issue.