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

what is "Full Text Merge Limit" in Advanced properties of RTC?

RTC3013 used.

In RTC's advanced properties > workitem queries, there is "Full Text Merge Limit" and it says:
The number of full text results that will be merged with a structured query part. Technically, this is the size of an IN clause. Setting this parameter to a high value may have a severe impact on performance.

"The number of full text results that will be merged with a structured query part" does not make much sense. What does that mean here?

The background why we notice this setting is that we have a problem in query a Chinese word and it returns nothing, but adding one more character will return the expected results.
Then if we adjust the "Full Text Merge Limit", and the same problematic query against a full text(without adding extra characters) will now work.
What does this limit mean and how does it work in full text query? Thanks a lot.

0 votes



One answer

Permanent link
I cannot give you a complete answer but maybe contribute.
As described here in the section Query Services, JTS supports both structured queries and full text queries. Full text search in Jazz is done via Lucene. Structured queries are done via SPARQL. This technote describes how RTC interacts with Lucene in more detail for quick search. I imagine that in a regular work item query when you use the "full text" attribute, the result of the Lucene search result is then filtered by / merged with the structured query. This might explain "the number of full text results merged with a structured query part".

Do you get the same results when executing a query against work items using just "full text" attribute and when using QuickSearch in RTC (just entering full text in the quick search text field in e.g. Web)?

- Arne

0 votes

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
× 369

Question asked: Jun 11 '12, 4:22 a.m.

Question was seen: 4,569 times

Last updated: Jun 11 '12, 3:47 p.m.

Confirmation Cancel Confirm