It's all about the answers!

Ask a question

Finding Null custom attributes


Nigel Hopper (1032625) | asked Aug 28 '09, 9:23 a.m.
Hi

We have created a new customer attribute of type Long HTML. Is it possible to create a query on a custom attribute that will find all WIs that have not got anything in it (e.g. NULL)?

Thanks, Nigel.

One answer



permanent link
Patrick Streule (4.9k21) | answered Aug 29 '09, 2:59 a.m.
JAZZ DEVELOPER
We have created a new customer attribute of type Long HTML. Is it
possible to create a query on a custom attribute that will find all
WIs that have not got anything in it (e.g. NULL)?

The Long types (Long String, Long HTML) are CLOBs that are not queryable
in the database, so this query is unfortunately not possible.

--
Regards,
Patrick
Jazz Work Item Team

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.