Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Bruno_Cotrim
Community profile Bruno_Cotrim Level 2
Job title here
Location here
10 BADGES
Level 2

Level 2

Learn more
Joined the community 11-07-2018 4:43:51 AM
Offline
Top badges earned by Bruno_Cotrim
Customize the badges you want to showcase on your profile
Re: DayOfYear Query returns two days
Avatar
Give Back 5
Level 2
Bruno_Cotrim
Level 2

Likes

5 likes

Total Posts

9 posts

Correct reply

1 solution
Top badges earned
Give Back 5
Ignite 3
Give Back 3
Give Back
Ignite 1
View profile
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

704

Likes

0

Replies

0
Re: DayOfYear Query returns two days
Avatar
Give Back 5
Level 2
Bruno_Cotrim
Level 2

Likes

5 likes

Total Posts

9 posts

Correct reply

1 solution
Top badges earned
Give Back 5
Ignite 3
Give Back 3
Give Back
Ignite 1
View profile
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

526

Likes

0

Replies

0
DayOfYear Query returns two days
Avatar
Give Back 5
Level 2
Bruno_Cotrim
Level 2

Likes

5 likes

Total Posts

9 posts

Correct reply

1 solution
Top badges earned
Give Back 5
Ignite 3
Give Back 3
Give Back
Ignite 1
View profile
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

945

Likes

2

Replies

4
Re: Recipient Form and 1-1 link with non existing data
Avatar
Give Back 5
Level 2
Bruno_Cotrim
Level 2

Likes

5 likes

Total Posts

9 posts

Correct reply

1 solution
Top badges earned
Give Back 5
Ignite 3
Give Back 3
Give Back
Ignite 1
View profile
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

704

Likes

0

Replies

0
Recipient Form and 1-1 link with non existing data
Avatar
Give Back 5
Level 2
Bruno_Cotrim
Level 2

Likes

5 likes

Total Posts

9 posts

Correct reply

1 solution
Top badges earned
Give Back 5
Ignite 3
Give Back 3
Give Back
Ignite 1
View profile
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.3K

Like

1

Replies

3
Re: Export sent SMSs
Avatar
Give Back 5
Level 2
Bruno_Cotrim
Level 2

Likes

5 likes

Total Posts

9 posts

Correct reply

1 solution
Top badges earned
Give Back 5
Ignite 3
Give Back 3
Give Back
Ignite 1
View profile
Bruno_Cotrim
- Adobe Campaign Classic
@wodnicki We've a hosted environment so I don't think I've access to those logs.

Views

528

Likes

0

Replies

0
Export sent SMSs
Avatar
Give Back 5
Level 2
Bruno_Cotrim
Level 2

Likes

5 likes

Total Posts

9 posts

Correct reply

1 solution
Top badges earned
Give Back 5
Ignite 3
Give Back 3
Give Back
Ignite 1
View profile
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

621

Like

1

Replies

2
Re: Acessing 1:n data from DB in a Campaign Delivery
Avatar
Give Back 5
Level 2
Bruno_Cotrim
Level 2

Likes

5 likes

Total Posts

9 posts

Correct reply

1 solution
Top badges earned
Give Back 5
Ignite 3
Give Back 3
Give Back
Ignite 1
View profile
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

688

Likes

0

Replies

0
Acessing 1:n data from DB in a Campaign Delivery
Avatar
Give Back 5
Level 2
Bruno_Cotrim
Level 2

Likes

5 likes

Total Posts

9 posts

Correct reply

1 solution
Top badges earned
Give Back 5
Ignite 3
Give Back 3
Give Back
Ignite 1
View profile
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.3K

Like

1

Replies

2