Change Primary key default value | Community
Skip to main content
Level 2
December 17, 2018
Solved

Change Primary key default value

  • December 17, 2018
  • 1 reply
  • 1962 views

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

Adobe Campaign counts empty columns as 'null':

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

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:

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jonathon_wodnicki

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

1 reply

Jonathon_wodnicki
Community Advisor
Jonathon_wodnickiCommunity AdvisorAccepted solution
Community Advisor
January 2, 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