Hello,

Is it possible have a parameter which contains the whole WHERE clause?

Example

SELECT   [Customer], [State] FROM [dbo].[Customers]

<Parameters.MyParameter>

So the <Parameters.MyParameter> could be populated as necessary...

'WHERE [State] like 'Man%'

'WHERE [State] like 'Man%' and [Customer] = 'IBM'

'WHERE [State] = 'Cheshire' and [Customer] LIKE 'HP%'

I have this working fine with

SELECT   [Customer], [State] FROM [dbo].[Customers]

WHERE [State] like '<Parameters.MyParameter>%'

I am finding this too restrictive and need to pass the whole WHERE clause.

Any advise would be much appreciated.

Thanks!

Chris

Tableau Version 10.2.0