Hi All,

What happens in below scenarios in filter by expression select parameter in Abinitio.

  1. If condition resolving to 1/true
  2. If we put -1 as select expression
  3. If condition resolved to Null
  4. If condition resolved to 0

This smells of homework!

Without seeing the query it’s not easy to determine what will happen because I don’t know where the parameter goes and I don’t know what expression/condition is used. But, if you’re posting here you need help, so I’ll do my best to guide you.

You have to look at the query and see where the parameter goes. Queries are sets, so what will be returned or allowed through the filter is the set of data that matches the filter (meaning all conditions are true). So, substitute the conditions listed to see what will be filtered. If the query is into a financial database and the parameter is for Company, for instance, and your database has Company values 1, 2, 3 but your parameter wants to select Company 4 – you’re going to get nothing because no Company matches the parameter you supplied.