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

QueryDef inside componment after a split

Avatar

Avatar
Level 1
mic48519263
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
mic48519263
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
View profile
mic48519263
Level 1

10-12-2018

Hello,

My question is quit tricky.

I've a WF with a query, a split and after my own developped componment.

Inside I'm trying to make a queryDef on the temp table.

But as I have a branch in my split. My queryDef take one branch by hazard but not THE branch.

Do you have any idea?

How I take my schema :

var lastQuery = event.vars.targetSchema.toString();

And my queryDef :

<queryDef schema={lastQuery}>

Thanks for your help

Replies

Avatar

Avatar
Contributor
Level 3
saikatk2447661
Level 3

Likes

22 likes

Total Posts

57 posts

Correct Reply

14 solutions
Top badges earned
Contributor
Shape 1
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Contributor
Level 3
saikatk2447661
Level 3

Likes

22 likes

Total Posts

57 posts

Correct Reply

14 solutions
Top badges earned
Contributor
Shape 1
Give Back 5
Give Back 3
Give Back
View profile
saikatk2447661
Level 3

13-12-2018

Try using different segment codes for different branch in split block and use those values of segment codes to filter them inside the querydef.

Avatar

Avatar
Level 1
mic48519263
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
mic48519263
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
View profile
mic48519263
Level 1

13-12-2018

Hello,

Thanks for you answer.

What do you mean by "Try using different segment codes for different branch"

As I'm inside a JS code that Adobe call automaticly by myName_call(){}

So I don't have the way to change a code for each branch.

Thanks

Michaël

Avatar

Avatar
Contributor
Level 3
saikatk2447661
Level 3

Likes

22 likes

Total Posts

57 posts

Correct Reply

14 solutions
Top badges earned
Contributor
Shape 1
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Contributor
Level 3
saikatk2447661
Level 3

Likes

22 likes

Total Posts

57 posts

Correct Reply

14 solutions
Top badges earned
Contributor
Shape 1
Give Back 5
Give Back 3
Give Back
View profile
saikatk2447661
Level 3

13-12-2018

Is it possible for you to post a screenshot of the workflow? I am assuming it is something like this... Please confirm.1645918_pastedImage_0.png

Avatar

Avatar
Level 1
mic48519263
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
mic48519263
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
View profile
mic48519263
Level 1

13-12-2018

Hello,

As it's a componment it's more like that :

1645968_pastedImage_1.png

And Adobe, once is through by "delivery" call a JS. So all the context is done by the activities.

Thanks

Avatar

Avatar
Validate 1
Level 4
pierrec70731455
Level 4

Likes

62 likes

Total Posts

59 posts

Correct Reply

14 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile

Avatar
Validate 1
Level 4
pierrec70731455
Level 4

Likes

62 likes

Total Posts

59 posts

Correct Reply

14 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile
pierrec70731455
Level 4

06-05-2019

Hi,

if I understand correctly, you want to dynamicaly get the temp schema of the previous activity/activities. If so, here is how I would implement it :

var schemaName = vars.targetSchema.substr(vars.targetSchema.indexOf(":")+1);

logInfo(schemaName);

var xml = <query schema={vars.targetSchema} operation="select">

                <select>

                  <node expr="@field1"/>

                  <node expr="@field2"/>

                </select>

              </query>;

var query = xtk.queryDef.create(xml).ExecuteQuery()[schemaName];

vars.results = query.toXMLString();

logInfo("vars.results : " + vars.results);

Kind regards,

Pierre