Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Vic on January 01, 1970, 12:00:00 AM

Title: How to get Skill definition of VAG on a fly?
Post by: Vic on January 01, 1970, 12:00:00 AM

Hi,

I am in serious need of retrieving skill and value used to define a VAG from inside the strategy.
I have a strategy A and inside it, I need to retrieve the skill and value uses by virtual agent group VAG_1. How can this be done?

Title: How to get Skill definition of VAG on a fly?
Post by: ecki on January 01, 1970, 12:00:00 AM

Hi,

So I think, you have to use stored procedure for this. Join two table "cfg_group.dbid" and "cfg_flex_prop.objec_dbid" and use criteria "cfg_group.name=input value","cfg_flex_prop.objext_type=5","cfg_flex_prop.prop_name='script'" and the returning variable should be filled from cfg_flex_prop.prop_value".

Title: Re: How to get Skill definition of VAG on a fly?
Post by: makkerc on February 07, 2011, 04:33:01 PM

Vic, did you manage to get the SQL Statement?

I'm loking for the same!

Cheers!!