List | Community
Skip to main content
Level 6
August 3, 2024
Solved

List

  • August 3, 2024
  • 1 reply
  • 1329 views

Hi, there are two options:

1. Create a list using its own table

2. Purge and reuse the list if it exists

 

Can we call the first type of list a static list and the second one a dynamic list.

Note: I have observed the first one stores duplicate data as well.

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 ParthaSarathy

Hi @sanjana12 ,

If you want to create a list to use a schema other than the recipient table then check the Create or use a list with its own table option. Example, if you have broadLogRcp schema in query and to store the value in a list, you have to enable ' Create or use a list with its own table'

 

Whereas, If you enable 'Purge and reuse the list if it exists (otherwise add to the list)' option, each time the workflow runs it will delete the old records in the list and update the list with new values from the workflow. And If you disable the checkbox, then each time the workflow runs, new records will get inserted in the same list without deleting the old records.

 

1 reply

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
August 3, 2024

Hi @sanjana12 ,

If you want to create a list to use a schema other than the recipient table then check the Create or use a list with its own table option. Example, if you have broadLogRcp schema in query and to store the value in a list, you have to enable ' Create or use a list with its own table'

 

Whereas, If you enable 'Purge and reuse the list if it exists (otherwise add to the list)' option, each time the workflow runs it will delete the old records in the list and update the list with new values from the workflow. And If you disable the checkbox, then each time the workflow runs, new records will get inserted in the same list without deleting the old records.

 

 ~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
Sanjana12Author
Level 6
August 3, 2024

But can we call them static and dynamic lists?

Sanjana12Author
Level 6
August 6, 2024

Nah, they're all static - they're only updated if you run some sort of an activity to update the contents of the list. 


Hi, if we check both the options in the list, are duplicate records going to get inserted into the list and deleted everytime we update the list?