since ‎26-02-2020
‎12-03-2020
kattyice
Level 1
How to access external database data from script activity in web application in ACC
Avatar

kattyice

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...

Views

1.6K

Likes

0

Replies

1
Re: How to use Joins in queries in js files
Avatar

kattyice

kattyice
- Adobe Campaign Classic
Thanks jonasn, thats a great help

Views

4.1K

Likes

0

Replies

0
Re: How to use Joins in queries in js files
Avatar

kattyice

kattyice
- Adobe Campaign Classic
Is there anything wrong if I use '/' in the expr ?

Views

4.1K

Likes

0

Replies

0
Re: How to use Joins in queries in js files
Avatar

kattyice

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?

Views

4.1K

Likes

0

Replies

0
How to use Joins in queries in js files
Avatar

kattyice

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...

Views

4.1K

Likes

0

Replies

5
Re: Importing javascript into personalization block
Avatar

kattyice

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) ?

Views

2.8K

Likes

0

Replies

0
Re: Importing javascript into personalization block
Avatar

kattyice

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 ! 🙂

Views

2.8K

Likes

0

Replies

0
Importing javascript into personalization block
Avatar

kattyice

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 ...

Views

2.8K

Likes

0

Replies

4
Likes given to