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

SOLVED

Change Primary key default value

jael39132526
Level 2
Level 2

How can you change the value of a field from default value of 0 to something else.

Adobe Campaign counts empty columns as 'null':

null values.png

...so we are placing a filtering condition to remove any 'null' values. If I'm correct, AC defaults empty long values to 0, hence:

pk not null.png

I've also placed a condition to to fetch PK that 'is not empty.'

But can we also write a value where @id =! 'null'? Even though @id is a long (not string) datatype? As you can see, the @id is constrained to a long (not string) datatype:

datatypeforprimarykeylong.png

How can we create an expression where @id != 'Null'?

1 Accepted Solution
wodnicki
Correct answer by
Community Advisor
Community Advisor

Hi,

The console UI displays numeric nulls as 0, so it can be hard to see which is which.

You have it correct there with @id is not empty, which translates to is not null.

Thanks,

-Jon

View solution in original post

1 Reply
wodnicki
Correct answer by
Community Advisor
Community Advisor

Hi,

The console UI displays numeric nulls as 0, so it can be hard to see which is which.

You have it correct there with @id is not empty, which translates to is not null.

Thanks,

-Jon

View solution in original post