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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

rayfinkle_72
Community profile rayfinkle_72 Level 2
Job title here
Location here
6 BADGES
Level 2

Level 2

Learn more
Joined the community 25-11-2020 9:40:07 AM
Online
Top badges earned by rayfinkle_72
Customize the badges you want to showcase on your profile
Re: New 32bit PK attribute (that references NmsBroadLogId...
Avatar
Give Back 5
Level 2
rayfinkle_72
Level 2

Like

1 like

Total Posts

6 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Ignite 1
Give Back
Boost 1
View profile
rayfinkle_72
- Adobe Campaign Classic
Thanks Jon! What’s the best way to rename the column without dropping it and creating new? Also do you think i can use the broadlog sequence or should definitely create new? I would like to replicate that same sequence if you have the code for it

Views

319

Likes

0

Replies

0
Re: New 32bit PK attribute (that references NmsBroadLogId...
Avatar
Give Back 5
Level 2
rayfinkle_72
Level 2

Like

1 like

Total Posts

6 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Ignite 1
Give Back
Boost 1
View profile
rayfinkle_72
- Adobe Campaign Classic
Thanks Jon! What’s the best way to rename the existing column internal name without dropping it and creating new? Should I run sql?

Views

321

Likes

0

Replies

0
Re: New 32bit PK attribute (that references NmsBroadLogId...
Avatar
Give Back 5
Level 2
rayfinkle_72
Level 2

Like

1 like

Total Posts

6 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Ignite 1
Give Back
Boost 1
View profile
rayfinkle_72
- Adobe Campaign Classic
Thanks Jon! Nms:broadLogEventHisto doesn’t have an autopk, it just populates the @ID field with the values pulled from message center, where the sequence actually exists. I want to add an autopk to this table in mkt, but I can’t because autopk adds a field called @ID...which is already being utilized and populated by the mc feed. I want to see if there’s a way to change the name of the field autopk populates from @ID to something else, so I can add an auto incrementing value to the table with a ...

Views

376

Likes

0

Replies

0
New 32bit PK attribute (that references NmsBroadLogId sequence) on an nms:broadLogEventHisto schema, but does not overwrite the current field @id (int64)
Avatar
Give Back 5
Level 2
rayfinkle_72
Level 2

Like

1 like

Total Posts

6 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Ignite 1
Give Back
Boost 1
View profile
rayfinkle_72
- Adobe Campaign Classic
I am feeding ACC nms:broadLogEventHisto data to a legacy system which cannot accept primary keys that are larger than 32 bit integers, but needs a unique value to represent the records. The reason for this can be ignored for this use case. It turns out, all broadLog tables, with the exception of those related to message center, have a 32 bit integer PK incrementing via the NmsBroadLogId sequence:I would like to retain the @id field in the broadLogEventHisto schema (without changing the internal ...

Views

394

Likes

0

Replies

6
Re: Hi All, Please help me with the segment code
Avatar
Give Back 5
Level 2
rayfinkle_72
Level 2

Like

1 like

Total Posts

6 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Ignite 1
Give Back
Boost 1
View profile
rayfinkle_72
- Adobe Campaign Standard
it worked! thank you. And of course to the target mapping

Views

550

Likes

0

Replies

0
Re: Hi All, Please help me with the segment code
Avatar
Give Back 5
Level 2
rayfinkle_72
Level 2

Like

1 like

Total Posts

6 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Ignite 1
Give Back
Boost 1
View profile
rayfinkle_72
- Adobe Campaign Standard
I tried to write a typology as well using JS which queries the segment code field. This code works within a workflow, but not within the typology rule. If the segment code isn't populated at all, there is no field to query.. so i added a catch. That being said I cannot seem to query target data from within a typology rule, it just fails everytime. @Jonathon_wodnicki any ideas? Here is my typology rule code: try { var query= xtk.queryDef.create( ; ) if( query.ExecuteQuery().@count > 0 ) { /...

Views

565

Like

1

Replies

2
Likes given to
Likes from