Create a Report with If condition.

💬 General Discussion
1

Hello

I want to give a condition something like below for both in where condition and in field

 WHERE if((tabl1.some_field IS NOT NULL,tabl1.field,if(tabl2.some_field IS NOT NULL,tabl2.field,0))) >= 0

Thnks

2

If you can’t create such a complex condition in a Report (and I suppose you can’t), a possible workaround is this:

  • create a custom field called include_in_report, which can be boolean (true or false) or integer

  • make an update query to set that field with the value of your complex condition

  • run this query regularly, or just before the report

  • make the report use a simple condition based on your new field