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

Searching content of large string custom attributes

Hi,

Migrating a highly customized ClearQuest schema to Rational Team Concert resulted in a custom work item type which has has 6 large string custom attributes to store text that was previously in corresponding ClearQuest fields.
Medium string attributes are not an option because the size of the ClearQuest fields is well over 1000 characters.
Many of the ClearQuest queries that have to be migrated have filters based on the content of one or more of the mentioned fields.
When implementing the queries is RTC it turns out that the content of long string attributes can't be queried.
The web client query editor does not list long string attributes.
The eclipse query editor lists long string attributes but it does not allow to surch the content, it just indicates to use Full Text Search.
The Full Text Search condition box accepts a string with wildcards but does provide an option to indicate which attribute(s) should be searched.

Question:
Can Full Text Search be instructed to search the content of a specific long string custom attribute for the occurrence of a text string,in addition any occurrence of the text string in any other attribute should be ignored ?
The text string and the attribute content may contain any printable character.

Cheers,

Willy Dhondt

0 votes


Accepted answer

Permanent link
Unfortunately you can't. The way full text search is implemented in RTC is quite different from which is done in ClearQuest. You can read the below article to learn more about the RTC full text search implementation - notice that RTC always searches all the categories (which are pre-defined and generic).
https://jazz.net/library/article/824
Willy Dhondt selected this answer as the correct answer

1 vote

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.

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

Question asked: Aug 21 '15, 10:29 a.m.

Question was seen: 2,419 times

Last updated: Aug 23 '15, 10:11 p.m.

Confirmation Cancel Confirm