It's all about the answers!

Ask a question

How to create query checking if description contains certain text?


Malaya Sethi (113552) | asked Aug 09 '13, 7:30 a.m.
edited Aug 26 '15, 10:16 a.m. by Krzysztof Kaźmierczyk (7.5k480103)
Is there any way to create own query where description field could be used as search condition like

where description like '%some text%

3 answers



permanent link
Shubjit Naik (1.5k1613) | answered 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.



permanent link
Donald Nong (14.5k614) | answered 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

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

Comments
Malaya Sethi commented 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 commented 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 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.