Action Updates: RecordDetail V1.6, Execute SOQL V1.3.1 Collection Processors V1.15
RecordDetail 1.6 gets a bug fix related to record type and view mode
Execute SOQL 1.3.1 gets fuller support for nested related queries:
Primary Fix: Update regex for SOQL query string to to handled nested relationship queries after the WHERE clause; The code will first check to see if one of those queries exists and if true, will recursively search the nested queries and do the same formatted on those; If false, it will continue on with the single query search Secondary Fixes: Strip unwanted formatting characters from the query string that come in when text template is used in flow: ‘\n’, ‘\r\n’, ‘\t’ Fix time stamp formatting on date strings with a time: ’00:00 am’ is an invalid format. The equivalent, valid format using regular time is ’12:00 am’. ’00:00′ is only valid for 24hr formatting. Fix month name to month number conversion: prepend a 0 on the month number if the string value is < 10 Improvements: throw some exceptions for more informative error handling cleaned up unit suite and fixed failing tests Potential issues not yet fixed: It appears that after the ‘ order by ‘ substring is removed from the query, it is never added back before querying. Use Cases: SELECT Id, Name,Status_DD__c,Region__c FROM Object2__c WHERE Status_DD__c in (‘Option 1′,’Option 2′,’Option 3’) and id not in (SELECT Id FROM Object1__c WHERE CreatedDate >= 2020-04-12T15:24:00Z) and Field1__r.Custom__c = ‘1234’ SELECT Id, Status__c, Contact__c , Custom__c FROM Object_1__c WHERE Status__c like ‘%Active%’ AND Account__r.Custom__c = ‘1234’ AND Custom__c not in (select Custom__c from Object_2__c where Contact__c = ‘1234’) | |
Special thanks to Adam White and new contributor Ragan Walker, from CapTech Consulting, for these excellent hardening fixes.
Collection Processors Version 1.15
- New Action: DeepClone
- Map Collection gets a bug fix to properly handle date functions like TODAY()