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

Adding dynamic segment code gives an error

Avatar

Avatar
Validate 10
Level 3
robayzma
Level 3

Likes

13 likes

Total Posts

53 posts

Correct Reply

2 solutions
Top badges earned
Validate 10
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile

Avatar
Validate 10
Level 3
robayzma
Level 3

Likes

13 likes

Total Posts

53 posts

Correct Reply

2 solutions
Top badges earned
Validate 10
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile
robayzma
Level 3

11-11-2020

Hi,

 

Anyone knows how to add a dynamic segment code in a transition without triggering an error in a workflow?

I have tried something really simple like:

robayzma_0-1605107479476.png

But I get an SQL insert error in the workflow.

-Robert

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Give Back 5
Employee
ramon_bisswange
Employee

Likes

242 likes

Total Posts

353 posts

Correct Reply

182 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 25
Give Back 10
Give Back
View profile

Avatar
Give Back 5
Employee
ramon_bisswange
Employee

Likes

242 likes

Total Posts

353 posts

Correct Reply

182 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 25
Give Back 10
Give Back
View profile
ramon_bisswange
Employee

16-11-2020

If you want to do it to have the segment code available on the delivery logs, there is no need to use the dynamic segmentation code feature.

Easier might be to use an Enrichment. Then just in Additional Data add an attribute and as field name use @segmentCode.

This will process the value in the same way then defined elsewhere but gives you great flexibility in defining the value.

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 2
anasso83525035
Level 2

Likes

6 likes

Total Posts

30 posts

Correct Reply

6 solutions
Top badges earned
Validate 1
Give Back 3
Give Back
Boost 5
Boost 3
View profile

Avatar
Validate 1
Level 2
anasso83525035
Level 2

Likes

6 likes

Total Posts

30 posts

Correct Reply

6 solutions
Top badges earned
Validate 1
Give Back 3
Give Back
Boost 5
Boost 3
View profile
anasso83525035
Level 2

11-11-2020

Hello @robayzma,

 

I just tried reproducing the dynamic segment in a query, I do have an SQL error.

I think the reason is that the expression $long(vars/@recCount) can't be applied here since there are no inbound transition to the query.

 

If your need is to have the segment named with the count resulting from the query, you can add an enrichment after the query and put your expression there :

 

anasso83525035_0-1605110509023.png

Outbound transition from the query :

anasso83525035_1-1605110566217.png

Enrichment with dynamic segment code :

anasso83525035_2-1605110617474.png

Outbound transition from the enrichment :

anasso83525035_3-1605110947838.png