I have a quick DLRS SOQL question: How do you search for a word using a contains function (or something similar) in the relationship criteria. I'm trying to rollup the most recent email date by searching for the word "Email:" in the Subject field. This criteria doesn't seem to be working and it was all i could find when i goggled this: Subject LIKE '%Email:%'
11 Kommentare
Yeah I did. And that's what I wanted anyways since the Due Date was filled out 100% of the time whereas completed was not. At any rate I figured out a workaround by creating a formula field on tasks called "Email?" That basically returned yes or no if the subject contained "Email" - which made up for not being able to query that with the LIKE '%Email%' criteria.
