Expand my Community achievements bar.

SOLVED

How to compare Small Int data type used in Enumeration in Adobe Campaign

Avatar

Level 1

We have a field which is am Integer 8 (Small Int). It is present as an enumeration.

How to compare its values in a CRM Connector

eg @FIELD == 0 gives error as we cannot compare small Int with integer

      @FIELD == '0' gives error as we cannot compare small Int with String

ToString() and Tointeger() functions also fail and does not work on small Int.

1 Accepted Solution

Avatar

Correct answer by
Level 1

We have solved this problem by using 

IfEquals(ToString(@field),'0' ,'ABC' ,'Error');

 

in CRM Connector.

Where field was an integer 8 bit (Small Int).

== did not work

View solution in original post

2 Replies

Avatar

Community Advisor

Hello @Alolika 

 

You can compare it like this.

 

ToString(@FIELD) == ToString(0)

 

Let me know if this works.

 

Thanks

 

 

 


     Manoj
     Find me on LinkedIn

Avatar

Correct answer by
Level 1

We have solved this problem by using 

IfEquals(ToString(@field),'0' ,'ABC' ,'Error');

 

in CRM Connector.

Where field was an integer 8 bit (Small Int).

== did not work