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
