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

Filter „is included in“ with variable that has a list of values

Avatar

Avatar
Validate 1
Level 1
michaelk5974358
Level 1

Likes

0 likes

Total Posts

11 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Give Back
Ignite 1
View profile

Avatar
Validate 1
Level 1
michaelk5974358
Level 1

Likes

0 likes

Total Posts

11 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Give Back
Ignite 1
View profile
michaelk5974358
Level 1

06-03-2018

Hello

I try to use the filter „is included in“ with a variable like $(vars/@zzz) that in a javascript activity is written like vars.zzz.

It works if I only have one content, but it does not work when I used several contents comma separated like

aaa,bbb,ccc

I also tried the following alternatives without success:

'aaa,bbb,ccc'

'aaa','bbb','ccc'

('aaa,bbb,ccc')

('aaa','bbb','ccc')

Any proposal for solution?

Michael

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
MVP
Jean-Serge_Biro
MVP

Likes

353 likes

Total Posts

464 posts

Correct Reply

153 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
MVP
Jean-Serge_Biro
MVP

Likes

353 likes

Total Posts

464 posts

Correct Reply

153 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
Jean-Serge_Biro
MVP

06-03-2018

Hi Michael,

Yes, it is well-known limitation of the Query,Enrichment, DImension change, etc workflow activities. The wizard code generates this syntax:

IN ('v1,v2,v3')

instead of:
IN ('v1','v2','v3')

clause

given the variable value is: v1,v2,v3

There is no problem with the wizard if the values are typed, only when using variables.

So the only workaround is to replace the Query activity (or Enrichment etc) by a Query def; for instance in a webApp, the webApp var containing a list with values separated by commas, is put in the queryDef where clause as is:

"[XXX/@ID] IN (" + ctx.vars.sTypeList + ")"

Hope it could help.

Regards
J-Serge

Answers (2)

Answers (2)

Avatar

Avatar
Validate 25
Level 4
salvdangelo
Level 4

Likes

45 likes

Total Posts

130 posts

Correct Reply

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

Avatar
Validate 25
Level 4
salvdangelo
Level 4

Likes

45 likes

Total Posts

130 posts

Correct Reply

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

27-07-2018

Hi Jean-Serge,

What should I do if I have to extract data with this kind of filter (so I cannot use a Query activity) in a CSV file and save it in a AC SFTP folder?

Usually I would use a "Data extraction" activity but this one needs an inbound population.

Could you explain me how to do this?

Thanks in advance,

Salvatore

Avatar

Avatar
Validate 1
Level 1
michaelk5974358
Level 1

Likes

0 likes

Total Posts

11 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Give Back
Ignite 1
View profile

Avatar
Validate 1
Level 1
michaelk5974358
Level 1

Likes

0 likes

Total Posts

11 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Give Back
Ignite 1
View profile
michaelk5974358
Level 1

09-03-2018

Thank you J-Serge,

it helped.

Michael