Expand my Community achievements bar.

rbiri
rbiri
Online
Type
  • All
  • Questions
  • Discussions
  • Ideas
  • Blogs
Filter by user contributions
  • Hello I am trying to getthe latrst consent date for each email from the last 3 years. I am not sure how to use the function properly ex: max(consetDate) but how can I group by email at the same time?

    Type

    Questions

    Views

    199

    Likes

    0

    Replies

    1
  • Hello I am trying  to retrieve all recipents with same email but coming with a différent consent type? I am looking for a straight foward approach, to update them with the same value consent type, when the most recent consent date is updated?

    Type

    Questions

    Views

    204

    Likes

    0

    Replies

    1
  •  in Workfront Questions 10/17/23
    sorry this is for another community

    Type

    Questions

    Views

    208

    Likes

    0

    Replies

    0
  • Hi I am trying to find all recipients with same emails ( I have lot of duplicate..) with different consent type. ex:emailconsent yyperecipient@domain.com   opt outrecipient@domain.com   opt outrecipient@domain.com   opt in And what I need to get is how many emails i have in my database with same ema...

    Type

    Questions

    Views

    202

    Likes

    0

    Replies

    1
  •  in Workfront Questions 10/17/23
    Hi I am trying to find all recipients with same emails ( I have lot of duplicate..) with different consent type. ex:emailconsent yyperecipient@domain.com   opt outrecipient@domain.com   opt outrecipient@domain.com   opt in And what I need to get is how many emails i have in my database with same ema...

    Type

    Questions

    Views

    217

    Likes

    0

    Replies

    3
  • or do I need to change the file format ? 

    Type

    Questions

    Views

    521

    Likes

    0

    Replies

    1
  • hello @ParthaSarathy  Thanks for the step provided, I have followed your solution, and it is working with that test user from the list..but I have run the query with real data, and the JS activity run into a conflict 09/19/2023 9:44:36 AM js SCR-160012 Javascript: error while evaluating script...

    Type

    Questions

    Views

    521

    Likes

    0

    Replies

    2
  • here is the error received 09/15/2023 4:11:38 PM XSV-350122 An error occurred and the process has been stopped. 09/15/2023 4:11:38 PM SOP-330011 Error while executing the method 'PrepareTargetImpl' of service 'nms:delivery'. 09/15/2023 4:11:38 PM WDB-200001 SQL statement 'INSERT INTO wkDlv_213924541...

    Type

    Questions

    Views

    592

    Likes

    0

    Replies

    4
  • hello Thank you for all the details provided, it is very helpful, I have tried your solution, but my question is.this complmentary with LakshmiPravallika solution where I need to update the target mapping of event history too?cause I have been trying your solution with  same query, but I get an erro...

    Type

    Questions

    Views

    601

    Likes

    0

    Replies

    6
  • Hello You screenshot is blurry and I cant for some reason open it too, how do I get to this config?

    Type

    Questions

    Views

    613

    Likes

    0

    Replies

    1