'IN' operator with SQL connector

Need help Plugins
1

Dear all,

I’m looking for a solution to do a sql request with a IN operator like

SELECT * FROM tableName
WHERE id IN ($1)

But unfortunately i can’t construct an array properly with a list of values.

Thanks in advance for your help

2

Same question here, Anybody who can suggest a solution for this?

3

I am able to generate the array, But still its not working fine. The same query works fine in MySql but not in bubble connector

image

4

@romanmg, @NigelG: Any solutions for the above mentioned issue which you have come across in the past?

5

Not used this, sorry.

6

@eve: can you help here?

7

I have this working in my app with a MySql backend. The SQL I used looks like this:

select…where idEvent in (?)

The ? parameter has to be of type text even though it’s a list of numbers. So for example: 1,2,3,4,5,6,7

I then pass this value to the SQL query from my workflow:
RepeatingGroup GetEvents’s List of GetEvents idEvent.

That passes a list of comma separated id’s in text format, which is what the SQL parameter is expecting.

Hope that works for you!

1 Like
8

@joeyg
Is it work with text type example?

9

I’m guessing it will. Give it a try.