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