It's all about the answers!

Ask a question

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


David Clark (2341150) | 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 (56227) | 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.5k414) | 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.


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.