View Single Post
  #1  
Old 01-05-2016, 07:09 AM
mscisk mscisk is offline
Hot Shot
 
Join Date: Sep 2013
Posts: 10
mscisk has 10 reputation points
Default Cms groupagent interval

Hi,

Could anyone help me with below topic. I would like to screate a GroupAgent Interval report. Everything works fine except moment when to the WHERE statement I would like to add GROUP BY.

SELECT OK
ROW_DATE, STARTTIME, hagent.STARTTIME + hagent.INTRVL, hagent.LOGID, ACDCALLS, TRANSFERRED, 100 * (ACDCALLS - TRANSFERRED) / ACDCALLS, 3600 * (ACDCALLS) / (TI_STAFFTIME), NOANSREDIR, (ACDTIME + ACWTIME + HOLDTIME) / ACDCALLS, TOTAL_I_ACDTIME, TOTAL_I_ACWTIME, HOLDACDTIME, TI_AUXTIME1, TI_AUXTIME2, TI_AUXTIME3, TI_AUXTIME4, TI_AUXTIME5, TI_AUXTIME6, TI_AUXTIME7, TI_AUXTIME8, TI_AUXTIME0, TI_AUXTIME, RINGTIME, TI_OTHERTIME, TI_AVAILTIME, TI_STAFFTIME FROM hagent

WHERE OK
ACD=$acd and LOGID in (select value from agroups where item_name = [Agent Group:] and acd_no=$acd) and ROW_DATE = [Date:] and STARTTIME = [Times:]

With above configuration when i run report per every Agent per every interval there are few rows - each row is a separate SPLIT.

When i add to above WHERE condition GROUP BY hagent.LOGID then error occures:
QUERY0 The coumn must be in the GROUP BY list.

Any clue?
Reply With Quote