Identfying Recently Updated Recipient Records | Community
Skip to main content
davidh2892249
davidh2892249
Level 5
January 10, 2023
Solved

Identfying Recently Updated Recipient Records

  • January 10, 2023
  • 3 replies
  • 1338 views

Hi there,

 

I have a requirement where I need to be able to identify all recently modified recipient records (any recipient field updated or recipient added to a list).

 

Effectively we have a range of fairly disperate processes that can update/insert recipient records.

From Automated workflows to manual import jobs carried out by a variety of users (even API updates in some ways).

 

Most of the updates are carried out by "jobs" but some updates may be made by "update data" workflow activities or session.write API calls.

 

I basically need a way whereby I can identify when each record was last processed (present in any of the file imports, even if fields didn't change and they were only added to a list) so that we can purge records that have not been modified in last 12 months.

 

Is there any OOTB way of identifying this based on how records are modified above or a small piece of development that could log this for us going forward? (preferably the former as I don't want to have to wait to build up history).

 

lastModified would've been ideal, but this seems to update outside of the above scope (e.g. when associated delivery/tracking logs are added and potentially other things?)

 

Any thoughts appreciated

 

Thanks

 

David

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by akshaaga

@davidh2892249 -

Just to confirm, are you planning to build logic around the last modified field?

As you said "Recently modified recipient records", you can use ToIntlString(@lastModified) to display the milliseconds.

Do note that whenever there is a timestamp change, this @lastmodified also gets modified without even the actual change. 

You can have a small test to validate this at your end.

3 replies

ParthaSarathy
Community Advisor
ParthaSarathyCommunity Advisor
Community Advisor
January 10, 2023

Hi @davidh2892249 ,

You can use the field '@lastModified' from nms:Recipient schema.

After a Recipient record got created, @lastModified will be same as creation date. And later @lastModified in recipient schema will get updated only if there is some edit made on recipients field for that particular record, and NOT associated with any delivery broadLogs, tracking logs etc.

So you can query Recipient's @lastModified on or after 12months and can purge your data as per your business need.

 

Regards,

ParthaSarathy 

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
    akshaaga
    Adobe Employee
    akshaagaAdobe EmployeeAccepted solution
    Adobe Employee
    January 19, 2023

    @davidh2892249 -

    Just to confirm, are you planning to build logic around the last modified field?

    As you said "Recently modified recipient records", you can use ToIntlString(@lastModified) to display the milliseconds.

    Do note that whenever there is a timestamp change, this @lastmodified also gets modified without even the actual change. 

    You can have a small test to validate this at your end.

      davidh2892249
      davidh2892249Author
      Level 5
      February 9, 2023

      Thanks for the response.

       

      Whilst this seems to work if the recipient record is modified in any way... if a recipient is part of a data file, "processed" by a job (e.g. their reconciliation key is present in the file) which adds them to a list but their recipient fields remain unupdated becuase they are already the same as the file - modification date is not updated.

       

      My use case would prefer a scenario that updates the recipient modification date if they are added to a list (even if their recipient fields are unchanged).

       

      Any further thoughts?

       

      Thanks

       

      David

       

       

      Sukrity_Wadhwa
      Community Manager
      Sukrity_WadhwaCommunity Manager
      Community Manager
      January 25, 2023

      Hi @davidh2892249 ,

      Were you able to resolve this query with the help of the given solutions or do you still need more help here? Do let us know. In case any of the given solutions were helpful, then kindly choose the it as the 'Correct Reply'.
      Thanks!

      Sukrity Wadhwa
      Terms & ConditionsAccessibility statement

      Loading footer...