This is a set of utilities that facilitate the creation and use of Salesforce Collections (Lists)
They include:
- fac_CompareLists - Compare two lists returning 2 lists; a list of those added to the first and a list of those deleted From the first
- fac_FilterCollection - An "IN"-like query to filter a collection of objects
- fac_GetListFromObjectsField - Returns a list of strings from designated Field in object collection given the object collection and name of the field value to be added to list
- fac_GetRecordsIn - Perform an SOQL (getRecord) query using the "IN" condition of the WHERE clause
Compare two lists returning 2 lists; a list of those added to the first and a list of those deleted From the first
Parameters:
- Request
- Original List - The reference list which the changes are compared against
- Changed List - The changed list to compare against the original list
- Response
- Items Added - Items which appear in the changed list which are not in the Original List
- Items Removed - Items which appear in the original list which are removed from the changed List
An "IN"-like query to filter a collection of objects
- Request
- IN Field Name - The field DeveloperName used to compare that field value to a list of values that have been specified
- Value Collection - A collection of values to be compared to the value in the specified IN field
- Collection to Filter - The collection to be filtered'
- Is Not In - Set this to TRUE if you wish the returned collection to be those NOT found in the value collection
- Response
-
Object Collection Returned - The collection of objects matched in the Values Collection
Returns a list of strings from designated Field value in object collection
- Request
- Object Collection - The source collection of objects to build the list
- Field Name - The DeveloperName of the Field whose values appear in returned list
- Response
-
Returned List - The collection list returned
Perform an SOQL (getRecord) query using the "IN" condition of the WHERE clause
- Request
- Query Field Collection - The collection of Developer Field Names to be queried
- IN Field Name - The field DeveloperName used to compare that field value to a list of values that have been specified
- Value Collection - A collection of values to be compared to the value in the specified IN field
- Is Not IN - Set this to TRUE if you wish the returned collection to be those NOT found in the value collection
- Object Developer Name - The Object (Developer Name) to be queried
- Where clause (Post IN) - Additional conditional clause to appear After the Field IN values
- Where clause (Pre IN) - Additional conditional clause to appear Before the Field IN values
- Response
- Object Collection Returned - The collection of objects returned from the Select
- Query Used - The actual query used - useful for debugging
- Record Count Found - The count of records returned - useful for debugging