Change Primary key default value

Avatar

Avatar

jael39132526

Avatar

jael39132526

jael39132526

17-12-2018

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'?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

wodnicki

MVP

Avatar

wodnicki

MVP

wodnicki
MVP

02-01-2019

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

Answers (0)