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

How do we pass more than one value(array) of values from a variable into a filter condition of subsequent query activity

Avatar

Avatar
Validate 1
Level 1
doncic
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
doncic
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

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

07-02-2020

Hello,

 

Can we pass multiple values from a variable in JavaScript activity into filter criteria of subsequent query activity.

Tried using "is Included in" but all the values from Variable are being read as single value inside the filter criteria of query activity.

How can we have read all them separately, any suggestions appreciated !

 

doncic_0-1581101539200.png

 

View Entire Topic

Avatar

Avatar
Contributor
MVP
Raj_bounteous
MVP

Likes

90 likes

Total Posts

97 posts

Correct Reply

32 solutions
Top badges earned
Contributor
Shape 1
Give Back 10
Give Back 5
Give Back 3
View profile

Avatar
Contributor
MVP
Raj_bounteous
MVP

Likes

90 likes

Total Posts

97 posts

Correct Reply

32 solutions
Top badges earned
Contributor
Shape 1
Give Back 10
Give Back 5
Give Back 3
View profile
Raj_bounteous
MVP

07-02-2020

Hi,

 

Can you try the below code once?

 

var id = []
var res = query.getElementsByTagName("{{schema name}}")
for each (var w in res){
id.push("'"+w.getAttribute("attribute name")+"'");
}
vars.idArray = id.join(",").slice(1,-1);
logInfo(vars.idArray);

 

 

if it is a string that is in filter criteria should use $noescaping(vars/@idArray) in it.