|
| [WD21] How to pass two conditional parameters to a query? |
| Iniciado por guest, 20,jul. 2017 13:54 - 1 respuesta |
| |
| | | |
|
| |
| Publicado el 20,julio 2017 - 13:54 |
Hi all,
I need to pass two "conditional" parameters to a query.
For example, I want all records to be included that have either boolean field A true or boolean field B true (or both true). But if both are false, then the record must be left out. How can I do that?
Best regards
Ola |
| |
| |
| | | |
|
| | |
| |
| Publicado el 20,julio 2017 - 14:30 |
Hi all,
Panic over, found it!
I found it in the query editor's "Selection condition" -> "Existing conditions (AND/OR) -> "List and sequence of selection conditions". The parameters can be arranged in the field "Sequence of conditions: use "AND","OR","(" and ")", so I changed mine from "1 AND 2 AND 3 AND 4" to "1 AND 2 AND (3 OR 4)", where 3 and 4 are the conditional boolean fields.
Best regards
Ola |
| |
| |
| | | |
|
| | | | |
| | |
|