Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Gaia on January 20, 2020, 05:28:45 PM

Title: Request configuration Database
Post by: Gaia on January 20, 2020, 05:28:45 PM

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,

Title: Re: Request configuration Database
Post by: cavagnaro on January 20, 2020, 06:07:03 PM

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

Title: Re: Request configuration Database
Post by: terry on January 20, 2020, 08:55:48 PM

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

Title: Re: Request configuration Database
Post by: Gaia on January 21, 2020, 09:09:35 AM

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]

Title: Re: Request configuration Database
Post by: cavagnaro on January 21, 2020, 10:31:58 AM

[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

Title: Re: Request configuration Database
Post by: Gaia on January 21, 2020, 11:03:08 AM

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

Title: Re: Request configuration Database
Post by: cavagnaro on January 21, 2020, 11:04:12 AM

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

Title: Re: Request configuration Database
Post by: Gaia on January 21, 2020, 11:15:30 AM

::) ::) ::) ::)

Title: Re: Request configuration Database
Post by: Kubig on January 21, 2020, 01:11:17 PM

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

Title: Re: Request configuration Database
Post by: cavagnaro on January 21, 2020, 01:12:14 PM

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

Title: Re: Request configuration Database
Post by: Gaia on January 21, 2020, 01:40:49 PM

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

Title: Re: Request configuration Database
Post by: Gaia on January 21, 2020, 05:45:23 PM

Thank you experts

The ExpandAgent function is working  :) ;D

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



Gaia

Title: Re: Request configuration Database
Post by: cavagnaro on January 21, 2020, 05:49:06 PM

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

Title: Re: Request configuration Database
Post by: terry on January 21, 2020, 07:30:48 PM

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