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