emailtemplate-subject-not-filterable-in-soql
The EmailTemplate object’s Subject field is not filterable via SOQL WHERE clause — querying WHERE Subject LIKE '%...' returns zero results even when matching records exist. Workaround: query by Name or DeveloperName instead, or retrieve EmailMessage records from actual send history to identify template by subject.