I follow your tutorial and I encounter a strange issue, here is what happened when I input an address email :
The error mention that I'm using a boolean but when looking at my variable, I'm using a text in the screenshot below :
Is it the correct way to put the variable in the storage like mention in your tutorial ?
Also, one more question about this part :
At the step "Valeur" and "Pris en compte si", is it okay if i write down those lines by hands without using any function ? (I'm not good in that part) I have the same result as you but I don't know if Campaign will like if I write those lines by hands.
Yes, broadlog and tracking logs are huge tables, and the query could last some seconds, but 10 minutes seems abnormal, because email fields are indexed. For comparison, it takes about 1 minute for me for 14 millions of contacts and broadlogs/trackinglogs purge after 1year and half.
I tried with limiting the result set of the 2 query activities to 100 lines or not limiting at all, the same response time. (the matter of this limitation treshold would be to reduce RAM memory dedicated to XML context, but in that use case, only one recipient so the volume is quite small).
One optimization may be: find first the recipient.id corresponding to the email entered in the form field, then search the trackinglogs and broadlogs by using the recipient.id.
Regarding the Filter parameter screen in Query activity, the problem is that this fields form is quite buggy with special characters management, often it generates bad escaping chars; so the best is to use the Advanced editor to circumvent such issues;
Often with direct type in field, backslash are added.
when line is selected, and appears as this when you are in the field:
The same for the Value to this:
Then, it should resolve your issue about boolean type, because I guess Adobe Campaign is misleaded/wrong issue reported.