6. Bug Fixed

Fixed Too many SOQL queries 201

The complex VLOOKUPs, including nested VLOOKUPs (where a VLOOKUP contains a sub-VLOOKUP), can result in the error 'Too many SOQL queries: 201.' This issue can be addressed by using the lookup formula with relationship names. However, this issue has been resolved.

Fixed Comparison Issue between Null and Number Values

We encountered an issue when comparing a Null value with a Number in a formula mapping. For example, consider the following formula: IF(ISNULL(FieldX__c), 'VALUE IS NULL', IF((FieldX__c >= '15000', 'MORE', 'LESS')). When FieldX__c is null, an error occurs: 'Output Error line: 1019 > For >= operator, LHS & RHS should be of the same data type!'. This error is caused by comparing a Null value with a Number, which are different data types. To resolve this issue, we have made an enhancement. Comparisons between Null and Number will now always result in false. For instance:

• FieldX__c is blank (null)
• FieldX__c>= '17000101' : false