Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: mark on March 14, 2007, 12:22:41 PM

Title: Hyperion question - unique values
Post by: mark on March 14, 2007, 12:22:41 PM

Probably an easy one for you all :D

I have created a hyperion query against the cfg db for agent name, skill, skill level.

When I process the query, I get the results that I want, however it does have multiple results. For example, Agent1 with Skill1/Level1 will show 200+ times.

Query:
Cfg.Person - Firstname, lastname
Cfg.Skill - name
Cfg.Skill Level - level

Any help would be appreciated :D

Mark

Title: Re: Hyperion question - unique values
Post by: René on March 14, 2007, 01:23:44 PM

Hi Mark,

Here it is  :)

[font=Courier New][color=navy]SELECT person.first_name,person.last_name,skill.name,skl.level_
FROM cfg_person person,cfg_skill_level skl,cfg_skill skill
WHERE person.is_agent=2 AND skl.person_dbid = person.dbid AND skill.dbid = skl.skill_dbid
ORDER BY person.last_name,skill.name
[/color][/font]

René

Title: Re: Hyperion question - unique values
Post by: Adam G. on March 14, 2007, 01:31:14 PM

Rene beat me to it but here is a Hyperion report that I just rustled up.

Please rename the .txt to .bqy

Pavel

Title: Re: Hyperion question - unique values
Post by: mark on March 14, 2007, 01:35:59 PM

Thanks both :]

Pavel, the file tells me 'Incorrect fields encountered. Document may be corrupt'.

Are you free this afternoon? Was looking at giving you a call regarding Munich later on :]

Mark

Title: Re: Hyperion question - unique values
Post by: mark on March 14, 2007, 01:45:43 PM

Ahh in the query my joins were a bit wrong!

Have now got it right,

cfg.person: dbid  connected to cfg.skill level: person dbid
cfg.skill level: skill dbid connected to cfg.skill: dbid

i had skill and skill level the wrong way around (and a few un needed links!)

Mark

Title: Re: Hyperion question - unique values
Post by: Adam G. on March 14, 2007, 01:50:13 PM

[quote author=mark link=topic=2125.msg7345#msg7345 date=1173879359]
Thanks both :]

Pavel, the file tells me 'Incorrect fields encountered. Document may be corrupt'.

Are you free this afternoon? Was looking at giving you a call regarding Munich later on :]

Mark
[/quote]

Mark,

Have emailled you the bqy just in case. It has been written against a v7.2 config Server DB.

Pavel

Title: Re: Hyperion question - unique values
Post by: René on March 14, 2007, 02:09:50 PM

Just a note - don't use ".txt" extension when uploading a binary file because it becomes corrupted.

to Pavel: even I was faster, you won  ;)

René