nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to execute a full text search for a phrase that includes an asterisk

kristopher.kees@fmr.com

I have a requirement to search for all documents which contain the word Fidelity* (including the asterisk.) Since this is interpreted as a wild card in the SEARCH DOCUMENT CONTAINS clause, how can I escape the asterisk or tell DQL to see it as a character rather than a wild card?

Find more posts tagged with

Comments

PanfilovAB

Fidelity\*

kristopher.kees@fmr.com

Unfortunately, that produces an error.

[DM_FULLTEXT_E_SEARCH_NEW_FAIL]error: "dmFTSearchNew failed with error: ESS_DMSearch::ExecuteSearch. Query Execution Error (100) : org.apache.lucene.search.BooleanQuery$TooManyClauses: maxClauseCount is set to 65536,Error from QRServer, error code: -2"