say I have a table with two fields ID and value where value is datatype decimal
some of the data I have been given just leaves the value field blank (so null i guess) I’m not exactly sure how backendless treats a decimal field with no value.
I need to search on the value field ( valueXX ) but need to exclude any value that is blank ( null? ) from the query. I thought about just changing it to -1 but queries can be value< XX which would include values of -1 so that’s not a good solution.
this is a general question I’m not quite to the point where I’m ready to code(less) this, but wanted to get some advice so I’ll know how to tackle this issue when I get there.