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
Hi Chris,
I'm not sure this would be what you looking for but what about something like :
WHERE [State] LIKE 'Man%'
OR [State] = 'Cheshire'
AND [Customer] = 'IBM'
OR [Customer] LIKE 'HP%'
Ciaran
Become a Viz Whiz on the Forums! Support the Community and master Tableau.