IsNull AutoQuery Convention

Hi - just a feature suggestion for others and not sure if possible for other providers, but having the following EndsWith Convention built-in would have saved me a bit of time.

autoQuery.EndsWithConventions.Add("IsNull", new QueryDbFieldAttribute {
    Template = "IIF ({Field} IS NULL,'true','false') = {Value}", ValueFormat = "{0}"

That’s SQL Server specific so it’s not portable, but you can specify the field name without a value to query for null records, e.g:

Yes saw that but it’s the “Not Null” capability that I was missing. Oh well hopefully someone may find useful.

1 Like

Yep definitely, thx for sharing!