Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Scottyjohn on June 04, 2012, 05:25:11 PM

Title: SQL Query to pull Templates from Config DB
Post by: Scottyjohn on June 04, 2012, 05:25:11 PM

Hi all,
I have managed this before and cant find the query :-(

I want a query that will pull the template options from config DB.  Any help much appreciated!

Title: Re: SQL Query to pull Templates from Config DB
Post by: René on June 05, 2012, 04:53:11 PM

Hi,

Here is the code:
[code]SELECT templ.name,aopt.section,aopt.opt,aopt.val
FROM cfg_app_prototype templ
LEFT JOIN cfg_app_option aopt ON aopt.object_dbid = templ.dbid AND object_type = 20
ORDER BY templ.name,aopt.section,aopt.opt
[/code]

R.

Title: Re: SQL Query to pull Templates from Config DB
Post by: Scottyjohn on July 16, 2012, 03:49:30 PM

Thanks Rene your a star  ;D