It's all about the answers!

Ask a question

How do query workitem by text of comments


Claudio Francisco Rodrigues Martins (212) | asked Nov 18 '14, 5:29 a.m.
I  will like create one query for consult work items by comments of workitem. How i do this query.

Thanks

2 answers



permanent link
Ralph Schoon (63.6k33646) | answered Nov 18 '14, 5:32 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Claudio, there is no specific search for the comments content available. The only option I see is to create a full-text query.

Comments
Claudio Francisco Rodrigues Martins commented Nov 18 '14, 5:49 a.m.

Thank for help me. More this no solution my probleman. Because the query for "Full Text" no verify text the comment. More thanks for help


Ralph Schoon commented Nov 18 '14, 5:55 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

In my test environment fulltext search finds content in comments.


Claudio Francisco Rodrigues Martins commented Nov 18 '14, 5:58 a.m.

What your version? My version is 4.0.
I go retry test


Ralph Schoon commented Nov 18 '14, 6:00 a.m. | edited Nov 18 '14, 6:00 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

I used 5.0 but I doubt that this has changed.
The result set for full text queries is limited to 100.


Ralph Schoon commented Nov 18 '14, 6:03 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

One last thought, I have seen indexes being corrupted and not finding all stuff in full-text because of this.


Claudio Francisco Rodrigues Martins commented Nov 18 '14, 6:14 a.m.

In my environment, no return in the query. More exists work item with data the query. I go continue try.

showing 5 of 6 show 1 more comments

permanent link
Claudio Francisco Rodrigues Martins (212) | answered Nov 18 '14, 6:16 a.m.
I'm not getting'm putting a very small text.

Comments
Ralph Schoon commented Nov 18 '14, 6:36 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

Definitely works for me. It also works on the 4.x internal environment we are using.

I would suggest to look into the repotools for the CCM server and consider run a reindex of the text and workitem indexes.


Claudio Francisco Rodrigues Martins commented Nov 18 '14, 7:10 a.m.

OK! thanks i go try

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.