With() Statement managing Delegation
Blog Index Author: Warren Belz In this blog, I will discuss a method that will allow the combining of non-Delegable filters with Delegable items in a way that will remove Delegation warnings and combine the process into one statement. There are some important things to remember in this: - The With() statement is effectively creating a (very) temporary variable/collection within the statement which only “exists” for the life of the statement execution. It is not Delegable in itself, meaning that it cannot “hold” more than 500-2000 records depending on your settings (I will refer to 2,000 here). However, if you can isolate less than this number with Delegable filters, then any statement using the resulting data is Delegable . You can also use this on an entire list (no Filter) with less than 2,000 records for the purpose of removing the Delegation warning. NOTE: If your With() statement potentially produces more than the 2,000 records, you will not get a Delegation warning ...