(Solved) : Marklogic Database 1000 S Xml Documents Querying Doc Nested Near Queries Getting Irrelevan Q30690089 . . . .

I have a Marklogic database, which has 1000’s of XML documents,i am querying for a doc with a nested near queries, but i amgetting irrelevant document when i am executing a query inunfiltered mode, but while executing it in a filtered mode thedocument which i am getting in unfiltered query is notretrieved.

What is the alternate solution for this issue. Note: Shouldn’tuse filtered query which slows down my execution and overallperformance.

Please Answer if are very sure about MARKLOGIC Xquery.

I also tried with re-indexing the database; So don’t ask me tore-index which is not working.

My Query:

cts:search(doc(),

cts:near-query(

(cts:word-query(“Mostly “),

cts:search(//p,

cts:near-query(

( cts:search(//p,

cts:near-query(

(cts:word-query(“Mostly “),

cts:word-query(“Shady”)),

3)),

cts:search(//p,

cts:near-query(

(cts:word-query(“Shady”),

cts:search(//p,

cts:near-query(

(cts:word-query(“Americana”),

cts:search(//p,

cts:near-query(

( cts:search(//p,

cts:near-query(

(cts:word-query(“Mostly”),

cts:word-query(“Shady”)),

3)),

cts:search(//p,

cts:near-query(

(cts:word-query(“Hepatica”),

cts:search(//p,

cts:near-query(

(cts:word-query(“Shady”),

cts:word-query(“Mostly”)),

1))),

2))),

3))),

7))),

8))),

9))),

5))

I am getting