since ‎11-07-2018
‎10-12-2019
Bruno_Cotrim
Level 2
Re: DayOfYear Query returns two days
Avatar

Bruno_Cotrim

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

Views

529

Likes

0

Replies

0
Re: DayOfYear Query returns two days
Avatar

Bruno_Cotrim

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

Views

356

Likes

0

Replies

0
DayOfYear Query returns two days
Avatar

Bruno_Cotrim

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...

Views

762

Likes

2

Replies

4
Re: Recipient Form and 1-1 link with non existing data
Avatar

Bruno_Cotrim

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

Views

527

Likes

0

Replies

0
Recipient Form and 1-1 link with non existing data
Avatar

Bruno_Cotrim

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...

Views

1.1K

Like

1

Replies

3
Re: Export sent SMSs
Avatar

Bruno_Cotrim

Bruno_Cotrim
- Adobe Campaign Classic
@wodnicki We've a hosted environment so I don't think I've access to those logs.

Views

368

Likes

0

Replies

0
Export sent SMSs
Avatar

Bruno_Cotrim

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...

Views

461

Like

1

Replies

2
Re: Acessing 1:n data from DB in a Campaign Delivery
Avatar

Bruno_Cotrim

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 ...

Views

485

Likes

0

Replies

0
Acessing 1:n data from DB in a Campaign Delivery
Avatar

Bruno_Cotrim

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...

Views

1.1K

Like

1

Replies

2
Likes given to