using a "Filter" on Sql Report

Hello Vasco,

I am not sure I got your question right but If you are using a SQL report, just add a WHERE clause after your JOIN like :

LEFT OUTER JOIN orcamento on orcamento.id_assistencia = assistencia.id
WHERE orcamento.boolean = 0

Now, why do you use LEFT OUTER JOIN ?

When you do a SELECT with INNER JOIN like :

SELECT
x
FROM table_a
INNER JOIN table_b

you will get all records that have x in table_a AND a link in table_b

If instead you use LEFT OUTER JOIN, you will get all records that have x in table_a EVEN IF they have no link in table_b.

For example, if you do :

SÉLECT
customer.name,
sex.gender
FROM
customer
LEFT OUTER JOIN sex on customer.id_sex = sex.id

The query will return ALL customer names EVEN if no sex (male or female) has been declared for them. But if you use INNER JOIN you will only get customer names that have a sex declared.

I know this is not the subject of your question, but I was surprised to read that so I ask 

Finally, from memory because I am not in front of my computer, if you don’t want to use the WhERE clause in your query, just add the orcamento.boolean in the SELECT part and filter the boolean field to 0 in the report.

Hope this helped and I understood your question right.

Cheers

Mathias

Hello MVD community! Please, how can I filter a sql report through a defined variable in the script?
I've already tried using '{name_variable}', but it does not work. This only works when referring to a form field in the WHERE clause.