Empty List

Avatar

Avatar

Ritu21

Avatar

Ritu21

Ritu21

16-10-2020

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. 🙂

View Entire Topic

Avatar

Avatar

Darren_Bowers

MVP

Avatar

Darren_Bowers

MVP

Darren_Bowers
MVP

19-10-2020

Hi @Ritu21 - the answer that @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.

Darren_Bowers_0-1603147401540.png

 

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

 

Ritu21_0-1603199908652.png

 

 

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

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

Ritu21_0-1603876403376.png

 

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

Ritu21_1-1603876499921.png

 

 

Ritu21_0-1603876847100.png