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

Taken into Account if

Avatar

Avatar
Validate 1
Level 4
somasundaramhal
Level 4

Likes

73 likes

Total Posts

71 posts

Correct Reply

12 solutions
Top badges earned
Validate 1
Shape 1
Boost 50
Boost 5
Boost 3
View profile

Avatar
Validate 1
Level 4
somasundaramhal
Level 4

Likes

73 likes

Total Posts

71 posts

Correct Reply

12 solutions
Top badges earned
Validate 1
Shape 1
Boost 50
Boost 5
Boost 3
View profile
somasundaramhal
Level 4

31-10-2019

Hi,

I need clarification on the 'Taken into account if' in the query & update activity in workflows. In the attached screenshot,

1. If I remove the 'Taken into account if' field value, it shows correct value

2. If I add the 'Taken into account if' field value, result is incorrect.

Want to know when to use and how to use this. Documentations couldn't help me understand this.

1849499_pastedImage_0.png

Thanks,

Somasundaram

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Springboard
MVP
Venu_Reddy
MVP

Likes

163 likes

Total Posts

171 posts

Correct Reply

53 solutions
Top badges earned
Springboard
Establish
Give Back 25
Give Back 10
Give Back 5
View profile

Avatar
Springboard
MVP
Venu_Reddy
MVP

Likes

163 likes

Total Posts

171 posts

Correct Reply

53 solutions
Top badges earned
Springboard
Establish
Give Back 25
Give Back 10
Give Back 5
View profile
Venu_Reddy
MVP

31-10-2019

Hi,

The filed 'Taken into account if' will limit the rule on the channels for which the data is defined.

For example, we can limit the rule on inbound channel based on language (EN, FR, ...)

Check the below link and hope it will helps you to understand in a better way.

Additional data

Answers (3)

Answers (3)

Avatar

Avatar
Validate 1
Level 3
Sourav_Sadhu
Level 3

Likes

32 likes

Total Posts

24 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Level 3
Sourav_Sadhu
Level 3

Likes

32 likes

Total Posts

24 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
Sourav_Sadhu
Level 3

01-11-2019

taken into account is basically a subfilter on top of the filter. Suppose sometime you don't want to use one filter, then you may write "false" [without quote], which then will take all other condition but not that, this way you can probably debug, what condition is causing your query to have no/less results. Furthermore suppose I want to take all the email address which are have 'gmail.com' in the email domain, but for an instance, customer wants to see how many customers are having the email address as 's' in their start, you can achieve this without adding another filter through Taken into account if.

Avatar

Avatar
Boost 50
MVP
Jyoti_Y
MVP

Likes

88 likes

Total Posts

123 posts

Correct Reply

55 solutions
Top badges earned
Boost 50
Shape 1
Boost 5
Give Back 5
Give Back 3
View profile

Avatar
Boost 50
MVP
Jyoti_Y
MVP

Likes

88 likes

Total Posts

123 posts

Correct Reply

55 solutions
Top badges earned
Boost 50
Shape 1
Boost 5
Give Back 5
Give Back 3
View profile
Jyoti_Y
MVP

31-10-2019

Hi,

For update: It updates data only when condition is met

For query: When you add 'Taken into Account If' you can see your query condition gets changed. It does not take into condition you have specified. It queries on full table. You can see this by ''Generated SQL Query'.

Thanks.

Avatar

Avatar
Validate 1
Level 4
somasundaramhal
Level 4

Likes

73 likes

Total Posts

71 posts

Correct Reply

12 solutions
Top badges earned
Validate 1
Shape 1
Boost 50
Boost 5
Boost 3
View profile

Avatar
Validate 1
Level 4
somasundaramhal
Level 4

Likes

73 likes

Total Posts

71 posts

Correct Reply

12 solutions
Top badges earned
Validate 1
Shape 1
Boost 50
Boost 5
Boost 3
View profile
somasundaramhal
Level 4

01-11-2019

Thanks all for taking time to reply. Any example code or screenshots might be helpful to make me understand this clearly. Because, I tried to understand from the documentation and tried to implement in any workflows.

The below works fine and I've already used it.

I want to understand the importance of 'Taken into account if' as this can be achieved via another filter. Any realtime examples to implement in a workflow/code/screenshots might be helpful.

@venur81308875  @jyotiy43907700  @Sourav Sadhu

Thanks.