Hello,

I would like to use dynamic conditions without an statement like:

Condition customer can be 0 (all costomers) or inherits a number of a customer

This doesn’t work: select * from table where iif(:input_customer_id <> 0;’customer_id = ‘ || :input_customer_id,’’)

I can set the input_customer_id to null when its value = 0, perhaps can I realize this with coalesce?

Where customer_id = coalesce(:input_customer_id;’…’) But I can’t set = and > 0 at the same time or = coalesce(..) and not null.

How can I finish my plan? Also I don’t like to set some if-statements… if input = 0 etc., there many inputs.

Thank you.

Best regards.

Olaf