since ‎11-07-2018
‎10-12-2019
Bruno_Cotrim
Level 2
Re: DayOfYear Query returns two days Bruno_Cotrim - Adobe Campaign Classic
Hello PierreThank you, that seems to have been exactly the problem. I didn't know the method DayOfYear translated the date to the number of days, good to keep in mind.Kind regards,Bruno Cotrim
473
Views
0
Likes
0
Answers
Re: DayOfYear Query returns two days Bruno_Cotrim - Adobe Campaign Classic
Hello Pierre,Thank you for the suggestion.It is a Date not a Datetime, non the less I've already tried that Kind Regards,Bruno Cotrim
301
Views
0
Likes
0
Answers
DayOfYear Query returns two days Bruno_Cotrim - Adobe Campaign Classic
Hello guys,I've a simple query that I've not been able to solve. I'm comparing day of year to day of year to find out someones birthday and it it returning me two days.The query:Note: the @birthday field is a "Date"Result (today 05/14):Sql Query:(Extract(DOY FROM E0.tsBirthdate) = Extract(DOY FROM (GetDate()) AT TIME ZONE 'Europe/Lisbon'))As far as I understand the problem seems to be in the Time Zone but I can't see how to solve it...Does any one have a suggestion on how to solve this issue?Kin...
702
Views
2
Likes
4
Answers and Comments
Re: Recipient Form and 1-1 link with non existing data Bruno_Cotrim - Adobe Campaign Classic
Hey Jon,Just tried that and it still throws the error out...This is the complete structure of the container:Edit: I also tried removing the container with the linklist unfortunately same thing 😕Kind Regards,Bruno Cotirm
461
Views
0
Likes
0
Answers
Recipient Form and 1-1 link with non existing data Bruno_Cotrim - Adobe Campaign Classic
Good afternoon guys,I'm having a issue while designing the form that presents the Recipient data.In the Database I've satellite tables that might or not be populated if this recipient has that kind of characteristics, our recipient form is use only as a way to see information about a recipient and I'm designing it around that concept, by hinding the contexts that this recipient does not include, for example he might or not be part of the loyalty program and will only have an entry in the loyalty...
986
Views
1
Like
3
Answers and Comments
Re: Export sent SMSs Bruno_Cotrim - Adobe Campaign Classic
@wodnicki We've a hosted environment so I don't think I've access to those logs.
294
Views
0
Likes
0
Answers
Export sent SMSs Bruno_Cotrim - Adobe Campaign Classic
Good Morning,I've implemented some workflows to be able to save the text value of sent SMSs, it works but I've a issue with it that I hope someone call help me with.To compute the value of the SMS text I'm building a preview of the event history, using the method "BuildPreviewFromId", this works for both messages sent via message center and via regular delivery, the thing is the same method has an enormous difference in performance when called internally or called via SOAP Service (for message c...
382
Views
1
Like
2
Answers and Comments
Re: Acessing 1:n data from DB in a Campaign Delivery Bruno_Cotrim - Adobe Campaign Classic
I've found a way to do it the way I was expecting to do it.Thank youWodnik​ for unlocking the thought process, my objective was a bit more dynamic than hard coding the number of rows but the input was critical to make me understand it was possible to do it as I had imagined it.The problem was I was trying to access the DB directly instead of accessing the Temporary tables and when I tried to access the temporary tables I had the delivery as "Enable but do not Execute" so the targetData variable ...
404
Views
0
Likes
0
Answers
Acessing 1:n data from DB in a Campaign Delivery Bruno_Cotrim - Adobe Campaign Classic
Good morning, I've been having a hard time since yesterday because I can't access the data that is in a one to many table in the database.This is the case, I want to send a e-mail to an Employee, using data from one of the month and all the flights of that month.So far I've not been able to find the data in a test preview as seen in the next images.The code:The result preview:The data that I've found is the value of an external key (Unique Flight) in the employeeFlights Table.Is it possible to a...
1003
Views
1
Like
2
Answers and Comments