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

Is there an "is included in" operator in Adobe Campaign Standard queries?

Avatar

Avatar
Validate 10
Level 3
davidh2892249
Level 3

Likes

16 likes

Total Posts

131 posts

Correct Reply

2 solutions
Top badges earned
Validate 10
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile

Avatar
Validate 10
Level 3
davidh2892249
Level 3

Likes

16 likes

Total Posts

131 posts

Correct Reply

2 solutions
Top badges earned
Validate 10
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile
davidh2892249
Level 3

22-01-2021

Hi there,

 

I have a requirement where I regularly need to query profiles that have bought 1 of a range of products (SKUs)

 

Our data model has the following setup:

Profile (1) --> (n) Orders (1) --> (n) Order Items

 

There is "Product ID / SKU" column on the Order Items table.

 

I need to build a filter that returns profiles that have an order that contains at least 1 of the product codes (SKUs).

 

The screenshot below seems to be the way that it can be done. However, having to drag in "product code" attribute and configure an "OR" for each SKU is way too time consuming when I need to do this for many SKUs and build many similar filters.

 

Can anyone propose a solution?

* Is there a way of writing "is included in" expression and pasting a range of comma seperated SKUs like in Adobe Campaign Classic?

* FYI - I was looking to build a parameterised filter on the profile custom resource, but this doesn't seem to be possible when using data from a table more than 1 link away.

 

I hope someone has a solution.

 

davidh2892249_0-1611322374451.png

 

 

 

 

 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 5
Employee
kpotts1985
Employee

Likes

6 likes

Total Posts

7 posts

Correct Reply

5 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Affirm 5
Affirm 3
View profile

Avatar
Boost 5
Employee
kpotts1985
Employee

Likes

6 likes

Total Posts

7 posts

Correct Reply

5 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Affirm 5
Affirm 3
View profile
kpotts1985
Employee

27-01-2021

In the advanced expression editor within your query condition you can use an IN statement.  For example:

 

@productCode IN ('01203', '18756', '39428', 'etc', 'etc')

Answers (0)