since ‎26-02-2020
‎12-03-2020
kattyice
Level 1
How to access external database data from script activity in web application in ACC kattyice - Adobe Campaign Classic
Hi, I Have an external Micrsoft SQL server database defined in the external account in my ACC. I am able to use the database from the "JavaScript code" activity in the ACC workflows with no problem. However, when I am trying to query that external database from the "Script" Activity in the ACC web application(for example, by just a simple select sql query or a simple join), in the preview debug window. it shows some errors like below: Cannot load document of type 'External Accounts (nms:extAccou...
1515
Views
0
Likes
1
Answers and Comments
Re: How to use Joins in queries in js files kattyice - Adobe Campaign Classic
Thanks jonasn, thats a great help
4038
Views
0
Likes
0
Comments
Re: How to use Joins in queries in js files kattyice - Adobe Campaign Classic
Is there anything wrong if I use '/' in the expr ?
4048
Views
0
Likes
0
Comments
Re: How to use Joins in queries in js files kattyice - Adobe Campaign Classic
Hi, jonasn, thx so much for replying me!, I have added sth like "expr: "emailInfo/@email]", and the externalJoin is in my schema. But I got the error which says :"The node of path '/' is not stored as an independent SQL field, UNable to use it as a filtering criteria in a query". Do you know how this error comes?
4050
Views
0
Likes
0
Comments
How to use Joins in queries in js files kattyice - Adobe Campaign Classic
Hi there, I am trying to query data from javascript like below: var query = NLWS.xtkQueryDef.create( {queryDef: {schema: "nms:recipient", operation: "select", select: { node: [{expr: "@id"}, {expr: "@label"}, {expr: "@internalName"}] }, where: { condition: [{expr: "@id='16'"}] } }}) So for the above query, if I have another table which is nms:userEmail. And I want to inner join this table with the current one(which is the one that shows above in the js code(nms:recipient)), and get the joined ta...
4075
Views
0
Likes
5
Answers and Comments
Re: Importing javascript into personalization block kattyice - Adobe Campaign Classic
Hmm, so do you mean the Xpath of a js file in the schema? (Since the js files are stored in a table). Lets assume we have a js file which is called "test" in the xtk:javascript table, what the Xpath would be and be called from eval(js.data) ?
2748
Views
0
Likes
0
Comments
Re: Importing javascript into personalization block kattyice - Adobe Campaign Classic
Hi, John, thx for the response, its useful. But I have a question of how to use the eval(@jsData) that you mentioned? Could you give sth like an example? I will really appreciate that, thank you ! 🙂
2768
Views
0
Likes
0
Comments
Importing javascript into personalization block kattyice - Adobe Campaign Classic
Hi there, I have a question of how to import javascript that I have in the Adobe Campaign Classic to my personalization block. I tried to use "<%@ include file='javascriptTest' %>" to import, but the default pickup path seems not correct. So I am asking what is the standard path of the javascript path on the server for Adobe Campaign? (The path on the server which holds AC in our company is like ......./neolane/nl6/var/.....). Or If I can not import the javascript from the file including method ...
2787
Views
0
Likes
4
Answers and Comments
Likes given to