Find email recipients who got a specific email

m.hnat · 1 August 2023 16:11

I have a newsletter recipient defined and want to do a filter like:

give me all recipients who got the following mail: (select mail)

Since all sent mails and users are logged in email_template_send_log I should be able to filter them. But I can’t find the correct filter.

Again a problem in front of the keyboard- issue?

jjannek · 7 August 2023 08:47

Is the newsletter recipient a custom Preside object? Or is this website users?

m.hnat · 7 August 2023 08:52

Custom preside object

jjannek · 7 August 2023 09:07

Did you follow the Preside Docs guide in order to have it logged?
See here:
https://docs.preside.org/devguides/emailtemplating/emailRecipientTypes.html
In particular, check the section in regards to logging:
https://docs.preside.org/devguides/emailtemplating/emailRecipientTypes.html#4-email-log-foreign-key

You then might in addition need custom expressions. A couple of years ago I created an open source very basic CRM extension, which has done this. Happy for you to borrow the code from there and adapt.
Essentially this was also based on how Preside core does it for the website users - so you might cross check if any changes have been applied in the meantime.
Otherwise check the following:

Config:

github.com

pixl8/preside-ext-crm/blob/stable/config/Config.cfc

component {

    public void function configure( required struct config ) output=false {

        // core settings that will effect Preside
        var settings            = arguments.config.settings             ?: {};

        // other ColdBox settings
        var coldbox             = arguments.config.coldbox              ?: {};
        var i18n                = arguments.config.i18n                 ?: {};
        var interceptors        = arguments.config.interceptors         ?: [];
        var interceptorSettings = arguments.config.interceptorSettings  ?: {};
        var cacheBox            = arguments.config.cacheBox             ?: {};
        var wirebox             = arguments.config.wirebox              ?: {};
        var logbox              = arguments.config.logbox               ?: {};
        var environments        = arguments.config.environments         ?: {};

        var appMappingPath      = settings.appMappingPath               ?: "app";

        interceptors.prepend(

This file has been truncated. show original

Context:

github.com

pixl8/preside-ext-crm/blob/stable/handlers/rules/contexts/Person.cfc

/**
 * Handler for the person rules engine context
 *
 */
component {

	property name="emailSendingContextService" inject="emailSendingContextService";

	private struct function getPayload() {
		var emailPayload = emailSendingContextService.getContextPayload();

		if ( emailPayload.keyExists( "person" ) ) {
			return emailPayload;
		}

		return { person = {} };
	}

}

Rules Expressions:

github.com

pixl8/preside-ext-crm/blob/stable/handlers/rules/expressions/LastPersonEmailBounced.cfc

/**
 * Expression handler for "Last email to person bounced" expression
 *
 * @expressionCategory email
 * @expressionContexts person
 */
component {

	property name="personDao" inject="presidecms:object:person";

	private boolean function evaluateExpression() {
		var personId = payload.person.id ?: "";

		if ( !personId.len() ) {
			return false;
		}

		return personDao.dataExists(
			  id           = personId
			, extraFilters = prepareFilters( argumentCollection=arguments )

This file has been truncated. show original

github.com

pixl8/preside-ext-crm/blob/stable/handlers/rules/expressions/PersonEmailInteraction.cfc

/**
 * Expression handler for "Person email interaction" expression
 *
 * @expressionCategory email
 * @expressionContexts person
 */
component {

	property name="personDao" inject="presidecms:object:person";

	/**
	 * @templates.fieldtype     object
	 * @templates.object        email_template
	 * @templates.objectFilters personEmailTemplates
	 * @templates.multiple      true
	 * @action.fieldtype        enum
	 * @action.enum             emailAction
	 * @action.multiple         false
	 *
	 */

This file has been truncated. show original

Also check the corresponding i18n files that you need here:

And of course you would need to substitute “Person” with whatever your custom Preside Object is named.

m.hnat · 7 August 2023 09:30

of course

But indeed I’m missing the separate filter rules for the object. Thanks for the hint, will add this to my application.