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
BedrockMission!

Learn More

View all

Sign in to view all badges

Empty List

Avatar

Avatar
Validate 1
Level 1
Ritu21
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
Ritu21
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
Ritu21
Level 1

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

263 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile

Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

263 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
MVP

03-11-2020

So am posting up the answer that helped @Ritu21 

This is my actual workflow that does this:

Darren_Bowers_3-1604440887161.png

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.

Darren_Bowers_4-1604441000405.png

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

Darren_Bowers_5-1604441094112.png

Cheers

Darren

Answers (3)

Answers (3)

Avatar

Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

263 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile

Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

263 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
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

 

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

960 likes

Total Posts

1,090 posts

Correct Reply

509 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

960 likes

Total Posts

1,090 posts

Correct Reply

509 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

16-10-2020

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

Avatar

Avatar
Validate 1000
Employee
Sukrity_Wadhwa
Employee

Likes

143 likes

Total Posts

866 posts

Correct Reply

35 solutions
Top badges earned
Validate 1000
Validate 500
Validate 250
Validate 100
Validate 25
View profile

Avatar
Validate 1000
Employee
Sukrity_Wadhwa
Employee

Likes

143 likes

Total Posts

866 posts

Correct Reply

35 solutions
Top badges earned
Validate 1000
Validate 500
Validate 250
Validate 100
Validate 25
View profile
Sukrity_Wadhwa
Employee

25-10-2020

Hi @Ritu21,

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

Thanks!