Timeline for Is there a way to make this apex more performant?
Current License: CC BY-SA 4.0
6 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Sep 29, 2022 at 17:25 | comment | added | guffelman |
This field is a custom field installed by our CTI adapter. It basically records a task for every SMS or Call that is completed related to an object. This field has values stored in it like 'Call', or 'SMS'. Should be fairly easy... AND Five9__Five9TaskType__c in ('Call, 'SMS') , right?
|
|
Sep 29, 2022 at 17:05 | comment | added | Kevin P |
@guffelman - this one might be harder: AND Five9__Five9TaskType__c != null depending on how tightly controlled your task types are. This is the kind of thing I use Custom Metadata for. Build a helper lib to pull the custom metadata records (without soql) of what types to include, and build your query dynamically.
|
|
Sep 29, 2022 at 16:54 | comment | added | guffelman | @KevinP, Thank you so much for the information!!!! I wasn't aware of this. It will surely come in handy! I know what task subtypes I'm looking for, so I'll switch that. | |
Sep 29, 2022 at 16:34 | comment | added | Kevin P | Just to be clear, I've never met an org that used Task, that didn't abuse Task. Which is to say, I suspect a full table scan of Task HURTS. | |
Sep 29, 2022 at 16:06 | comment | added | Matt Lacey♦ | I wasn't expecting to see you back on here! | |
Sep 29, 2022 at 15:49 | history | answered | Kevin P | CC BY-SA 4.0 |