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

Question

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 @2533677 == 0 gives error as we cannot compare small Int with integer

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

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

Alolika · Accepted Answer

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

Manoj_Kumar · Answer

Hello @alolika  You can compare it like this. ToString(@FIELD) == ToString(0) Let me know if this works. Thanks

Sign up

Login with SSO

Login to the community

Login with SSO