Why does the query builder remove the "empty" token from a query condition on a text field?
Hi,
on a RTC 4.0.2 installation, I was just working on a work item query with a condition on a text-type custom attribute. The condition should use "is" as predicate and compare against multiple tokens, separated by comma.
Something like this:
Custom Attribute is "xyz,abc"
Now, if you replace "abc" in the above example by a space, the query will effectively return those records matching either xyz or empty - which is exactly what I need.
Everything is fine until I save my query and re-open it later in the query builder. You would expect that the query builder displays what was entered and saved previously (i.e. "xyz, "), but what is displayed is "xyz". Interesting enough that the query result actually reflects what was saved (i.e. "xyz, ")...
This looks like a bug in the query builder to me... Any other thoughts on this?
Thanks,
Markus
on a RTC 4.0.2 installation, I was just working on a work item query with a condition on a text-type custom attribute. The condition should use "is" as predicate and compare against multiple tokens, separated by comma.
Something like this:
Custom Attribute is "xyz,abc"
Now, if you replace "abc" in the above example by a space, the query will effectively return those records matching either xyz or empty - which is exactly what I need.
Everything is fine until I save my query and re-open it later in the query builder. You would expect that the query builder displays what was entered and saved previously (i.e. "xyz, "), but what is displayed is "xyz". Interesting enough that the query result actually reflects what was saved (i.e. "xyz, ")...
This looks like a bug in the query builder to me... Any other thoughts on this?
Thanks,
Markus