It's all about the answers!

Ask a question

Searching content of large string custom attributes


Willy Dhondt (5821018) | asked Aug 21 '15, 10:29 a.m.
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

Accepted answer


permanent link
Donald Nong (14.4k314) | answered Aug 23 '15, 10:10 p.m.
edited Aug 23 '15, 10:11 p.m.
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

Your answer


Register or to post your answer.