Tableau Server Version: 2023.3.5
Tableau Desktop Version: 2023.3.14
Hi ,
Above are my specs.
I am using Google Big Query Connection and using following query
Select * from table1 where
("," || CAST(<Parameters.ACCOUNT_NO > AS STRING) || "," ) like ("%," || ACCOUNT_NO || ",%" )
Basically i am passing comma separated strings in the parameter to fetch multiple account No details from query and it is working properly in tableau desktop but when i publish the query on server it is only fetching data for the first account no passed only.
I have tried 3 different approaches of query
1 listed above using like function ,
another one using unnest and
third one using unnest and cross join all 3 working on tableau desktop but not on the server.
Please help me to find out if is it GCP or server issue or something else like any server setting causing the issue?
Thanks in advance
@Avadhut Sar
Hi, it should work also in Tableau Server. What if you try with single quotes:
Select * from table1 where
(',' || CAST(<Parameters.ACCOUNT_NO > AS STRING) || ',' ) like ('%,' || ACCOUNT_NO || ',%' )
If not, maybe you would need to create a support case:
https://help.salesforce.com/s/articleView?id=001537695&type=1
https://www.tableau.com/support/case
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Forums Ambassador
