Request configuration Database

[Gaia]

Hi Genesys experts  ,

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

I used [b]BD Data block[/b] 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,

[cavagnaro]

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

[terry]

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

[Gaia]

Hi cavagnaro,

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

Gaia


[quote author=cavagnaro link=topic=11519.msg52432#msg52432 date=1579543623]
No because the AG is not a property of the Agent object...why would you like to do such thing?
[/quote]

[cavagnaro]

[quote author=terry link=topic=11519.msg52433#msg52433 date=1579553748]
You can try ExpandAgent[AgentEmployeeID] - supposed to return list of all groups agent is in.
[/quote]Even VAG? Interesting... From where do you get those functions Terry?

Enviado de meu SM-N9600 usando o Tapatalk

[Gaia]

hi terry,

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

[quote author=terry link=topic=11519.msg52433#msg52433 date=1579553748]
You can try ExpandAgent[AgentEmployeeID] - supposed to return list of all groups agent is in.
[/quote]
Gaia

[cavagnaro]

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

[Gaia]

[Kubig]

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

[cavagnaro]

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

[Gaia]

Thanks Kunig

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

[quote author=Kubig link=topic=11519.msg52441#msg52441 date=1579612277]
You can find all available IRD functions within compiler.dat file under IRD installation folder.
[/quote]

Gaia

[Gaia]

Thank you experts

The ExpandAgent function is working 

<script><![CDATA[
App_URSFunction1['urs_url'] = 'urs/call/@' + system.InteractionID + '/func/ExpandAgent?params=[' + '"' + vEmployeeID + '"' + ']';
]]></script>



Gaia

[cavagnaro]

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

[terry]

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