-
Bug
-
Resolution: Fixed
-
Medium
-
Mindville - Pre Bundled
-
None
-
3
-
Severity 2 - Major
-
38
-
Issue Summary
Insight IQL search gives wrong result when using "!=" and "NOT IN" operators.
This happens when using an attribute name of type "Text", and that same attribute name is defined as a Boolean type somewhere else (e.g. on another schema).
Steps to Reproduce
- In Schema A, create an attribute called "Inactive" (Type: Default, Type Value: Boolean)
- Create several objects in Schema A, assign some values to "Inactive" attribute.
- In Schema B:
- Create an attribute "Inactive" (Type: Default, Type Value: Text)
- Create 3 new objects, assign value "Yes" to "Inactive" attribute to 2 objects
- Switch to Objects view > Advanced search > enter one of the following two IQL searches and perform the search:
"Inactive" NOT IN ("Yes")
"Inactive" != Yes
Expected Results
The IQL query should return objects that do not have the attribute value set to "Yes", example for "Test" attribute:
Actual Results
The IQL query returns objects having attribute value equal to "Yes" and all other values:
Workaround
If possible:
- Rename one of the attributes (e.g. "User Inactive", if the object type is "User")
- Rename the attribute to being with lower-case letter (i.e. "inactive")
- Use other IQL operators to find what you are looking for (i.e. "Inactive" IN ("value1", "value2",...)