It's all about the answers!

Ask a question

How do you filter for text in DNG that contains an underscore "_"?


David Clark (12618) | asked Jan 15 '18, 1:55 p.m.

 This also does not seem to work in the search box. If you try and filter on an underscore, nothing will be found.

e.g. filter on Full text for "appinfo_work" - this will not be found or filtered... What is up with that???

DNG 6.0.4

Accepted answer


permanent link
Diana Kraaijeveld (36227) | answered Jan 16 '18, 4:15 a.m.
JAZZ DEVELOPER

In fact starting version 6.0.4, searches containing an underscore should work again.

But you may need to run a reindex first as outlined below.

See section 'Searches that contain an underscore character might not return the correct results' in article 'Workarounds and Limitations: Known issues in DNG 6.0.4':

https://jazz.net/library/article/89437#38

There is a workaround described in this article that resolves the problem:
==============
Workaround
Starting in version 6.0.4, searches that contain the underscore character should work properly. However, if you upgrade or migrate data from a release earlier than 6.0.4, an administrator must reindex the text indexes. This operation can take a significant amount of time depending on the repository size.

For details about reindexing only the text store indexes, see Repository tools command to regenerate indexes. For a quick summary of reindexing only the text store indexes, see the following examples.

Windows
Open a command prompt and enter the following command:
cd C:\Program Files\IBM\JazzTeamServer\server\
repotools-rm.bat -reindex teamserver.properties=conf\rm\teamserver.properties scope=search


Note: Remember to include scope=search; otherwise, the Jena triplestore will be indexed and the process will take much longer.

UNIX
Open a command prompt and enter the following command:
cd opt/IBM/JazzTeamServer/server/
./repotools-jts.sh -reindex teamserver.properties=conf/jts/teamserver.properties scope=search


Note: Remember to include scope=search; otherwise, the Jena triplestore will be indexed and the process will take much longer.
==============



David Clark selected this answer as the correct answer

Comments
David Clark commented Jan 16 '18, 10:08 a.m.

 Yes, I found this yesterday. We ran the re-index and all is well with the world.

Thanks,

One other answer



permanent link
Donald Nong (14.3k213) | answered Jan 15 '18, 6:23 p.m.

The full text search feature in CLM utilizes Apache Lucene, which does not store underscore (_) as a "term" in its database in most configurations. See the "Tokenizing" section of the below article for more details.
https://jazz.net/library/article/824

Text is also broken up at non-letter non-numerical characters (e.g. ‘.’, ‘?’, ‘!’ and /’), capital characters (e.g. CamelCase is broken into Camel Case)

Your answer


Register or to post your answer.