Using a list in an advanced query

By Claring on 30 Oct 2017

So I want to be able to do something like this:

SELECT *
FROM myTable
WHERE someId IN (@MyList)


However currently I have to resort using a comma seperated string and use an expand inline.
Which in turn costs performance, which is something we wish to avoid.

Kilian Hekhuis2 Nov 2017

The performance has to come from somewhere. If you're not manually making your list into a comma seperated list, the Platform has to do it for you - as we say in Dutch, linksom of rechtsom, the database needs plain text.

Also, you can't just have any list, it must be a list of stuff you can convert to Text.

Claring3 Nov 2017

Hmm, that's definately true, this would only work with a text list....

There isn't an option to use a list in an Aggregate or using a WHERE IN inside an aggregate right?

Kilian Hekhuis3 Nov 2017

Nope, there's no such things.