Hey all code heroes!
I want to feature request a new query type.
.isNullOrEmpty("fieldKey", true)
and
.isNullOrEmpty("fieldKey", false)
Just some equivalent to the C# String.isNullOrEmpty when doing queries would help. It would be really nice if all filters possible to set in the Data Collection Data View (Excel view) would be possible to set in code with ease.
Hello! And where it can come in handy? In which cases?
If I want to get all rows where a certain isNull or is Empty or make sure I only get records where a certain field is not empty or null. I use it a lot in c#.
It would not be bad to see this in the example.
I double this. I need to verify this additional condition very often in sql compare, java, js. With SQL you can do ISNULL(collumn, value) or NVL(column, value) depending on the source, but that doesn’t work in the query options of WIX. With filters, when someone uses a droplist, and e.g. any they expect anything when using hasSome or contains with the hasSome(column, “”) or contains(column, “”) but empty is not shown then, you only get records where the column has data. I as programmer understand why, but users don’t.