Field Filder Error

Get Help
#1

İm Select =X. XXXXX 18 [1900] İn Filter Menu for this query;

WHERE (dbo.xxx.xxxxxx= 4) and KAGIT1={{KGT}}

and Error = com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword ‘IN’.

But if im write in query;

WHERE (dbo.xxxxx.xxxxxx= 4) and KAGIT1=‘X. XXXXX 18 [1900]’

İs Working,

so whats wrong?

#2

The syntax for field filter variables is different from “normal” variables because they insert SQL snippets rather than just a static value.

If you have set KGT to a field filter variable type, the syntax should be:

WHERE (dbo.xxx.xxxxxx= 4) and {{KGT}}

#3

Thanks for inform sir,

How i can add quotes ‘{{KGT}}’ , ‘+{{KGT}}+’ , {{‘KGT’}} ; im try and dnt work,

if we are can add quotes the problem is resolved… i think

#4

I would suggest reading over this article on using SQL templates and field filters before you proceed: https://www.metabase.com/docs/latest/users-guide/13-sql-parameters.html

Could you help me understand what exactly you’re trying to achieve by adding quotes?