Alolika
16-02-2021
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.
17-02-2021
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
MVP
Hello @Alolika
You can compare it like this.
ToString(@FIELD) == ToString(0)
Let me know if this works.
Thanks