Valid types for operators
Summary
Currently, some values in Property-Operator-Value filters are interpreted as types that might not be expected by the user and could thus lead to unexpected behavior
Expected Behavior
Queries are interpreted in a nonsurprising way.
Actual Behavior
I expect that floats and integers are also interpreted as dates and date times and entity ids.
Problematic cases
- Smaller or greater when using integers is compared to entity IDs (I.e. an entity is included if it reference an entity that is a child of the given ID (and not a child of an entity with ID smaller/greater the given value))
- Text data is used (always?). " > 519" is translated to "... value>519" on text data (what ever that is).
- 519 is interpreted as a datetime (-45757440000). Is that meaningful???
Specifications
- Version: Which version of this software?
- Platform: Which operating system, which other relevant software versions?
Possible fixes
Do you have ideas how the issue can be resolved?