Error in agent statistics when filtering by department

[alonsoac]

Hello. I had to add this code to avoid a SQL error when filtering by department:

lhc_web/lib/core/lhchat/lhchatstatistic.php

public static function numberOfChatsDialogsByUserParticipant($days = 30, $filter = array(), $groupField = 'lh_chat_participant.user_id')
{
    if ($groupField == 'transfer_uid') {
        if (isset($filter['filterin']['user_id'])) {
            $filter['filterin']['transfer_uid'] = $filter['filterin']['user_id'];
            unset($filter['filterin']['user_id']);
        }
        if (isset($filter['filterin']['lh_chat.user_id'])) {
            $filter['filterin']['lh_chat.transfer_uid'] = $filter['filterin']['lh_chat.user_id'];
            unset($filter['filterin']['lh_chat.user_id']);
        }
        if (isset($filter['filtergt']['user_id'])) {
            $filter['filtergt']['transfer_uid'] = $filter['filtergt']['user_id'];
        }
    }
    //*ADDED:*
      if (isset($filter['filterin']['dep_id'])){
            $filter['filterin']['`lh_chat_participant`.`dep_id`'] = $filter['filterin']['dep_id'];
            unset($filter['filterin']['dep_id']);
        }

[remdex]

can i get a query which get's this error? no need domain, just end part

[remdex]

And here is a proper fix... 93b27dd