Request configuration Database

Hi Genesys experts :),

Is there a URS function which allows to find th agent groups with employee_id ?

I used BD Data block in composer but it seems its not best practice.

SELECT “dbo”.“cfg_group”.“name”, “dbo”.“cfg_person”.“user_name”
FROM
“dbo”.“cfg_group”, “dbo”.“cfg_person”, “dbo”.“cfg_agent_group”
WHERE
“dbo”.“cfg_person”.“employee_id” = {vEmployeeID} AND “dbo”.“cfg_agent_group”.“agent_dbid” = dbo.cfg_person.dbid AND “dbo”.“cfg_agent_group”.“group_dbid” = dbo.cfg_group.dbid AND “dbo”.“cfg_group”.“name” NOT LIKE ‘Entite%’ AND “dbo”.“cfg_group”.“name” NOT LIKE ‘Stats%’ AND “dbo”.“cfg_group”.“name” NOT LIKE ‘%G%’
ORDER BY “dbo”.“cfg_group”.“name” ASC

Thanks for help

Br,

No because the AG is not a property of the Agent object…why would you like to do such thing?

You can try ExpandAgent[AgentEmployeeID] - supposed to return list of all groups agent is in.

Hi cavagnaro,

I need to Know the group the group of the agent who initiated consultation.

Gaia

Even VAG? Interesting… From where do you get those functions Terry?

Enviado de meu SM-N9600 usando o Tapatalk

hi terry,

There is function expandGroup but I never heard of expandAgent ??

Gaia

It was previously posted in another thread… Yet can’t find any info about it on Google lol
Terry is the book keeper

Enviado de meu SM-N9600 usando o Tapatalk

: : : :

You can find all available IRD functions within compiler.dat file under IRD installation folder.

Woha… Nice!
But yet… Still amazed how Genesys can lack of documentation and you have to go like reverse engineering always

Enviado de meu SM-N9600 usando o Tapatalk

Thanks Kunig

I will try to call this function with URS Function in composer , hope this work

Gaia

Thank you experts

The ExpandAgent function is working ;D

Gaia

Nice
Thanks for sharing
And what is the practical use of this? Why would you need the agents group belonging info?

Enviado de meu SM-N9600 usando o Tapatalk

With more or less recent URSes the ExpandAgent should work for VAGs too (at least for VAGs with definitions using skills, without login function)