Empty List

[Ritu21]

Hi Team,

Please let me know how can we empty the List after delivery activity.

We are updating the list with 3 days record so "Purge and re-use the list" checkbox is unchecked. 

Our goal is to empty the records in the list once delivery is performed.

Please help me with this.

Thanks in advance.

[Jonathon_wodnicki]

Hi,

Follow these steps:

1. Create a workflow with external signal pointing to a js activity pointing to an end block
2. In the js:
   1. Use nms.delivery.get(vars.deliveryId) to get the delivery contents
   2. Parse the contents for the target population's group id(s)
   3. Delete all the rows for group(s)
3. Set the external account of the deliveries to use that workflow for post-processing

Might also be able to accomplish above without js, using $long(vars/@deliveryId) in a query activity; not so sure about parsing the target for the group id(s) without js though.

Thanks,

-Jon

[Darren_Bowers]

Hi @Ritu21 - the answer that @Jonathon_wodnicki gave is definitely one way to do it. I found another easy way to do it - just query the List for 0 records then save the List again. It preserves the List schema and purges the list by saving 0 records to it. The query just asks for records where the primary key is empty and the Update List just has the Purge List checkbox ticked.

[Ritu21]

Hi Darren,

Thank you for the reply.

I tried to do that but getting 0 record.

filtered List internal name  and then added query primary key is empty. I am getting 0 records and didn't worked. Could you please let me know where I'm going wrong

[Darren_Bowers]

Hi @Ritu21 - You might need to do a quick load of the List before the query step. This is so you have the actual List schema in the workflow. So the steps would be: Load List > Query 0 records > Save List. This should get you an empty List with the correct schema. Cheers Darren

[Ritu21]

Hi Darren,

I have loaded the list and filtered the data based on primary key as 0.
While clearing the list, I am not getting the list which I have created to delete.
After going through the same, I found that the list whose schema type is "List Of recipient" will only be visible.

Could you please let me know how can I make the schema type as "List Of recipient".
Currently the schema type of the list which I have created is "Recipient" and List type is  "List" not "Group"

List name which I have created : Post Expiration Friday List

While clearing the list : "Post Expiration Friday List" is not coming

[Sukrity_Wadhwa]

Hi @Ritu21,

Were you able to resolve this query with any of the given solutions? Do let us know.

Thanks!

[Ritu21]

Hi Sukrity,

Thank you for your concern.
I was unable to solve that.

Have asked for the same again.

[Darren_Bowers · Accepted solution]

So am posting up the answer that helped @Ritu21 

This is my actual workflow that does this:

The first two steps are self-explanatory. The query is just querying the same record set for 0 records, but I also put all the additional data onto the schema that came off the schema when I first loaded it. I think this is so the new List has the exact same structure as the old list. Make sure you put the targeting dimension on there too.

Then I just save the new list as the same name as the old list

Cheers

Darren