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

How to create query checking if description contains certain text?

Questions
Tags
Users
Badges
Malaya Sethi
(11●35●52) edited
Aug 26 '15, 10:16 a.m.
Is there any way to create own query where description field could be used as search condition like

where description like '%some text%

0 votes

3 answers
6,033 views
0 votes

3 answers

Permanent link
Shubjit Naik
(1.5k●1●6●13) Aug 09 '13, 10:14 a.m.
Found that Large string/HTML attributes are not queriable (repository restriction), and therefore do not show up.
https://jazz.net/forum/questions/77851/unable-to-query-on-large-html-attributes

When I checked it was a custom attribute and Medium HTML for me.


1 vote

Permanent link
Donald Nong
(14.5k●6●14) Aug 27 '15, 12:12 a.m.
The attribute "description" is of type "Large HTML", which can be queried by using the "full text" query condition only. Unfortunately when using the full text search, you cannot restrict the search into a certain attribute. This is similar to what we have discussed in this post.
https://jazz.net/forum/questions/205039/searching-content-of-large-string-custom-attributes

0 votes

Permanent link
Shubjit Naik
(1.5k●1●6●13) edited
Aug 09 '13, 7:35 a.m.
Yes you can.
- Click on Work Items > New Query,
- Add Condition Attribute "Description" Contains "Some-text"

-1 votes

Comments
Malaya Sethi
Aug 09 '13, 8:03 a.m.

I don't have description field in add condition. I am using RTC 4.0.,3 and doing this activity from /ccm/web and eclipse client as well . please help

Shubjit Naik
Aug 09 '13, 8:46 a.m.

I did a quick check on a 4.0.3 setup and Attributes of type Large HTML are not listed in queries in 4.0.3. Will check further

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
× 12,019
× 369

Question asked: Aug 09 '13, 7:30 a.m.

Question was seen: 6,033 times

Last updated: Aug 27 '15, 12:12 a.m.

Confirmation Cancel Confirm