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

1. 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.
2. 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",...)