Hi Stephan,

Thank you for your reply.

Unfortunately, it doesn´t solve the problem.

When running that query, the log file outputs: 06/28/12 14:05:01 > Error = [ODBC SQL Server Driver][SQL Server]Invalid column name 'AgentTeamID'.
But there is a column named AgentTeamID, so that message is quite weird..

In the interface I´m using, I have specified the following:

CallDataTable=Agent_Skill_Group_Half_Hour
QueueSQL=SELECT DISTINCT AgentTeamID FROM Agent_Team_Member ORDER BY AgentTeamID
QueueNameColumn=AgentTeamID

Maybe the QueueNameColumn tries to read from the CallDataTable instead of the Agent_Team_Member table?


//Erik

Erik,
What are you trying to accomplish? all you want is the 4-digit team ID? or is this to build a report to show which team an agent belongs to?

if all you want is the 4-digit ID for a team then that table is the Agent_Team table in the AWDB but if you want to show which team an agent belongs to you would link two or three tables (three if you want to show the agent's full name)

A query like this one will give you the agent's full name and the name of the team:

select
AgentName = (PERSON.FirstName + ' ' + PERSON.LastName),
AGENT.EnterpriseName as AgentLoginName,
--MEMBERSHIP.AgentTeamID,
TEAMS.EnterpriseName as Team
from
t_Agent AGENT
left join
t_Person PERSON
on
AGENT.PersonID = PERSON.PersonID
left join
t_Agent_Team_Member MEMBERSHIP
on
AGENT.SkillTargetID = MEMBERSHIP.SkillTargetID
left join
t_Agent_Team TEAMS
on
MEMBERSHIP.AgentTeamID = TEAMS.AgentTeamID

order by
TEAMS.EnterpriseName

Thank you for all your help!

I have now been able to get help from our Local IT to run some queries towards Agent_Team.

I think the problem is the interface that I´m using. All the four digit ID´s are shown in the column AgentTeamID, exactly as they are supposed to, so I should be able to retrieve them from the table. At least I now know that the table and column isn´t the problem. I´ll continue searching with the vendor of the interface.

Thanks again, great answers!

//Erik