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

Filtering/Getting recipients from Lists

Avatar

Avatar
Validate 10
Level 2
sagil23995776
Level 2

Likes

17 likes

Total Posts

32 posts

Correct Reply

4 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 2
sagil23995776
Level 2

Likes

17 likes

Total Posts

32 posts

Correct Reply

4 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
sagil23995776
Level 2

17-08-2017

Hi,

We sometimes use Lists in Adobe Campaign in order group recipients with specific parameters instead of using database field.

Currently we have several lists (in some cases a specific recipient can be in more then one list)

Is there a way to query a set of lists in the same folder from a workflow to get all the recipients from those lists?

Alternatively is there a way to filter from a workflow recipients that exist in one or more of those lists?

Thanks,

Sagi

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile
Amit_Kumar
MVP

20-08-2017

Hi Sagi,

It looks like you have a custom schema. OOTB schema group is used as list there is no list schema.

1282408_pastedImage_0.png

You need to post your schema structure here or understand that how that works in your system.

Regards,

Amit

Answers (5)

Answers (5)

Avatar

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile
Amit_Kumar
MVP

17-08-2017

Hi Sagi,

You need to follow the given steps to get this working.

1. Change the target dimension in the query to nms:rcpGrpRel(Recipient List Content), if you created a custom schema, you can select that as well.

Refer to screen below for reference.

1281228_pastedImage_0.png

2. Use a filtering condition and sector list folder internal name to your list folder.

1281229_pastedImage_1.png

3. You will get the content of all list under that folder.

4. if you want to send an email to this, use change dimension or use a custom target mapping.

Hope this helps.

Amit

Avatar

Avatar
Validate 10
Level 2
sagil23995776
Level 2

Likes

17 likes

Total Posts

32 posts

Correct Reply

4 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 2
sagil23995776
Level 2

Likes

17 likes

Total Posts

32 posts

Correct Reply

4 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
sagil23995776
Level 2

20-08-2017

Hi,

I've copied the custom lists into a OOTB schema group so it works now.

Thanks,

Sagi

Avatar

Avatar
Validate 10
Level 2
sagil23995776
Level 2

Likes

17 likes

Total Posts

32 posts

Correct Reply

4 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 2
sagil23995776
Level 2

Likes

17 likes

Total Posts

32 posts

Correct Reply

4 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
sagil23995776
Level 2

20-08-2017

Hi Amit,

Thank you for your help, I've tried your suggestion and I saw I'm only getting 1 list out of 8.
Apparently it only works when the list type is 'Group', when the type of the list is 'List' then it won't collect the content

grpList.JPG

listList.JPG

So if we choose to use a 'List Update' in a workflow and selecting 'Create or use a list with its own table' then the list is automatically created with type 'List'.

Is there a way to change the type?

Thanks,

Sagi

Avatar

Avatar
Validate 10
Level 2
sagil23995776
Level 2

Likes

17 likes

Total Posts

32 posts

Correct Reply

4 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 2
sagil23995776
Level 2

Likes

17 likes

Total Posts

32 posts

Correct Reply

4 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
sagil23995776
Level 2

17-08-2017

Thanks Adhiyan,

I've tried it but it doesn't work it can only get a name of a specific list and load only that one.

Sagi

Avatar

Avatar
Boost 50
Employee
Adhiyan
Employee

Likes

239 likes

Total Posts

342 posts

Correct Reply

124 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile

Avatar
Boost 50
Employee
Adhiyan
Employee

Likes

239 likes

Total Posts

342 posts

Correct Reply

124 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile
Adhiyan
Employee

17-08-2017

Hi Sagi,

Try to use a query and change the filtering and targeting dimension to List and then form a query like :

1280746_pastedImage_0.png

But the problem is this will only give you lists inside that folder and not the contents of all those lists.

Another way , I can think of doing this is through read-list activity by using the "name computed by a script" option. Here you get the option of selecting a folder and select lists present in the folder via the template.

1280751_pastedImage_2.png

Try this and it might work for you.

Regards,

Adhiyan