Query sql, exclude filtered data or not work

Get Help
1

My Data.

image
image465×610 5.97 KB

I try to filter the Chile value, but it hides the data

image
image476×587 6.54 KB

SELECT glpi_entities.id AS id, glpi_entities.name AS name
FROM glpi_entities
[[WHERE glpi_entities.name = {{name}}]]

*MySQL DB

this way it works but i need to filter multiple fields
image

2

Hi @jlcornejo
If you are using Field Filters, then you should not include the column:
https://www.metabase.com/learn/building-analytics/sql-templates/field-filters.html

3

thanks, it works.

I had forgotten

FROM `resumen_componentes`
WHERE 1=1
    [[AND {{uunn}}]]
    [[AND {{bandera}}]]
    [[AND {{nombre_tipo}}]]
    [[AND {{tipo_generico}}]]

) AS rc
ON (BINARY dc.bandera = BINARY rc.bandera
AND BINARY dc.id_pais = BINARY rc.id_pais
AND BINARY dc.uunn = BINARY rc.uunn
AND BINARY rc.id_categoria = BINARY dc.id_categoria
AND BINARY rc.id_tipo = BINARY dc.id_tipo)
INNER JOIN
(
SELECT glpi_entities.id AS id, glpi_entities.name AS name
FROM glpi_entities
WHERE 1=1
[[AND {{name}}]]
) as ge
ON (ge.id = rc.id_pais)