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
Bruno_Cotrim
Offline

Badges

Badges
10

Accepted Solutions

Accepted Solutions
1

Likes Received

Likes Received
5

Posts & Comments

Posts & Comments
9

Discussions

Discussions
0

Questions

Questions
4

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by Bruno_Cotrim
Customize the badges you want to showcase on your profile
Re: DayOfYear Query returns two days - Adobe Campaign 14-05-2019
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

806

Likes

0

Replies

0
Re: DayOfYear Query returns two days - Adobe Campaign 14-05-2019
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

628

Likes

0

Replies

0
DayOfYear Query returns two days - Adobe Campaign 14-05-2019
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

1.0K

Likes

2

Replies

4
Re: Recipient Form and 1-1 link with non existing data - Adobe Campaign 03-05-2019
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

754

Likes

0

Replies

0
Recipient Form and 1-1 link with non existing data - Adobe Campaign 02-05-2019
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 - Adobe Campaign 19-03-2019
@wodnicki We've a hosted environment so I don't think I've access to those logs.

Views

605

Likes

0

Replies

0
Export sent SMSs - Adobe Campaign 13-03-2019
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

698

Like

1

Replies

2
Re: Acessing 1:n data from DB in a Campaign Delivery - Adobe Campaign 27-02-2019
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

907

Likes

0

Replies

0
Acessing 1:n data from DB in a Campaign Delivery - Adobe Campaign 27-02-2019
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.5K

Like

1

Replies

2