Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

kattyice
Community profile kattyice Level 1
Job title here
Location here
1 BADGE
Level 1

Level 1

Learn more
Joined the community 26-02-2020 6:50:36 AM
Offline
Top badges earned by kattyice
Customize the badges you want to showcase on your profile
How to access external database data from script activity in web application in ACC
Avatar
Validate 1
Level 1
kattyice
Level 1

Likes

0 likes

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
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.8K

Likes

0

Replies

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

Likes

0 likes

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
kattyice
- Adobe Campaign Classic
Thanks jonasn, thats a great help

Views

4.4K

Likes

0

Replies

0
Re: How to use Joins in queries in js files
Avatar
Validate 1
Level 1
kattyice
Level 1

Likes

0 likes

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
kattyice
- Adobe Campaign Classic
Is there anything wrong if I use '/' in the expr ?

Views

4.4K

Likes

0

Replies

0
Re: How to use Joins in queries in js files
Avatar
Validate 1
Level 1
kattyice
Level 1

Likes

0 likes

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
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.4K

Likes

0

Replies

0
How to use Joins in queries in js files
Avatar
Validate 1
Level 1
kattyice
Level 1

Likes

0 likes

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
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.4K

Likes

0

Replies

5
Re: Importing javascript into personalization block
Avatar
Validate 1
Level 1
kattyice
Level 1

Likes

0 likes

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
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

3.0K

Likes

0

Replies

0
Re: Importing javascript into personalization block
Avatar
Validate 1
Level 1
kattyice
Level 1

Likes

0 likes

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
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

3.0K

Likes

0

Replies

0
Importing javascript into personalization block
Avatar
Validate 1
Level 1
kattyice
Level 1

Likes

0 likes

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
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

3.0K

Likes

0

Replies

4
Likes given to