Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

Change Primary key default value

Avatar

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

Avatar

Correct answer by
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

Avatar

Correct answer by
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