(SOLVED) Pre-filter SQL Syntax

[mbeley]

I'm using a pre-filter on my candidates list, so that it only displays the candidates with a null status. It is working as expected, filtering out the candidates with a non null statuts.


In another form, I have a db join to candidates.
I would like the db join to show the same values (at the moment it shows all values)
I'm trying to use Data - Where in the db join element, but for some reason it's not working as I expected.

Below are several of the where statements I tried and the error messages or problems I'm seeing:

WHERE 'estatuto' IS NULL

my form is loading but shows no values in the candidate dropdown

WHERE {thistable}.'estatuto' IS NULL

my form is not loading I get a SQL 0 error:
SQL=SELECT DISTINCT(`candidatos`.`id`) AS value, CONCAT_WS('', candidatos.nome, ' ', candidatos.apelido) AS text FROM `candidatos` AS `candidatos` WHERE candidatos.'estatuto' IS NULL ORDER BY text ASC

WHERE {thistable}.'estatuto' IS NULL

SQL=SELECT DISTINCT(`candidatos`.`id`) AS value, CONCAT_WS('', candidatos.nome, ' ', candidatos.apelido) AS text FROM `candidatos` AS `candidatos` WHERE 'candidatos'.'estatuto' IS NULL ORDER BY text ASC

Help please!
Thanks,
Mathieu

 

[troester]

You mustn't quote table/column names with ' , use ``

 

[mbeley]

Thanks!