" /> SQL Query to pull Templates from Config DB - Genesys CTI User Forum
« previous next »
Pages: [1]   Go Down

Author Topic: SQL Query to pull Templates from Config DB  (Read 2596 times)

Offline Scottyjohn

  • Jr. Member
  • **
  • Posts: 66
  • Karma: 0
SQL Query to pull Templates from Config DB
« on: June 04, 2012, 05:25:11 PM »
Advertisement
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!
Logged

Offline René

  • Administrator
  • Hero Member
  • *****
  • Posts: 1832
  • Karma: 62
Re: SQL Query to pull Templates from Config DB
« Reply #1 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.
Logged

Offline Scottyjohn

  • Jr. Member
  • **
  • Posts: 66
  • Karma: 0
Re: SQL Query to pull Templates from Config DB
« Reply #2 on: July 16, 2012, 03:49:30 PM »
Thanks Rene your a star  ;D
Logged
Pages: [1]   Go Up
« previous next »