Cms groupagent interval

[mscisk]

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?

[shaikht]

Hi,

It looks to be complex SQL and I will suggest to break in parts to isolate the culprit item which need to be part of group by list.

If you want Avaya to look into it, we have Avaya Professional Services which work on creating such designer reports.

I hope it helps.