• Community
    • Adobe Campaign Classic v7 & Campaign v8
    • Discussions
    • Re: Personalization block How to query custom tabl...
  • Community
  • Adobe Campaign Classic v7 & Campaign v8
  • Discussions
  • Re: Personalization block How to query custom tabl...

Avatar

Community Advisor Marcel_Szimonisz
Community Advisor
‎09-08-2021 04:31 PDT
  • Mark as New
  • Follow
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report

Hello @Luca_Lattarini ,

apart from the @Manoj_Kumar_  asnswer -querydef- you you can also use:

 

 

 

sqlSelect from jsapi:

var res = sqlSelect("publicUrl,@sstringValue:string",
        "select sstringValue from XtkOption where sname='XtkFileRes_PublicUrl'")
logInfo(res.publicUrl.@sstringValue.toString(

 

 

 

 

https://docs.adobe.com/content/help/en/campaign-classic/technicalresources/api/f-sqlSelect.html?hl=s...

 

Marcel

 

Views

271

Replies

0
1 Like

Total Likes

Translate
Translate
  • ελληνικά
  • Italiano
  • Nederlands
  • Polski
  • русский
  • Svenska
  • Čeština
  • Türkçe
  • 한국어
  • 中文 (简体)
  • Español
  • 日本語
  • Deutsch
  • Português
  • Français
  • English
Reply
Powered by Khoros