Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Finding Null custom attributes

Questions
Tags
Users
Badges
Nigel Hopper
(103●26●25) 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.

0 votes

1 answer
4,385 views
0 votes

One answer

Permanent link
Patrick Streule
JAZZ DEVELOPER (4.9k●2●1) Aug 29 '09, 2:59 a.m.
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

0 votes

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Aug 28 '09, 9:23 a.m.

Question was seen: 4,385 times

Last updated: Aug 28 '09, 9:23 a.m.

Confirmation Cancel Confirm