what is "Full Text Merge Limit" in Advanced properties of RTC?
RTC3013 used.
In RTC's advanced properties > workitem queries, there is " 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
In RTC's advanced properties > workitem queries, there is " 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
One answer
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
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