'IN' operator taking a list of arguments

[AndrewMBaines]

Nope, doesn't work. I had the same problem. I've now changed my dashboards from custom SQL to using views.
Views also make code reuse easier. If you're not able to create views in your database due to security, take a look at:

More SQL - how to create a view when you don't have admin rights

I’ve found that in 0.28 I’m limited when I use SQL Queries as it prevents me using multiple values in a filter. My solution so far has been to just use a view. Then I realised that the customer I’m working for is one of the few who would allow me to create views on their database, so had to come up with a new solution for future use. Answer is to use SQL Server Express with linked servers. I can then create views of the ‘proper’ database within a new database in Expess. On top of that, I then …