REST - Search API - Perform search on obscure document name

Hi,

In our test environment we have a document with arguably the most obscure name of '!£$^&(){}[]-=¬`@#~,_..pdf'
The point of this document is to test special characters and make sure things are escaped when they need to be escaped.

The challenge at the moment is we are able to search for this document name via Advanced Search in Content Server by putting the entire name in double quotes:

"!£$^&(){}[]-=¬`@#~,_..pdf"

However we are unable to perform the same search via the REST Search API and the API returns an error.
We also tried using the Search API (?func=search, with LookFor1=ComplexQuery...) to no avail.

I should add that we have tried lots of permutations of encoding and escaping, substituting characters etc.

This is not a show stopper by all means but our thinking is if Content Server allows you to set a document name to such a value we should be able to search for it so we would like to work how how we need to parse/pass/escape/encode such a value to the REST API to perform a search.

Nick

Find more posts tagged with

Comments

John Simon

Nick, if you turn search logs on (wantSearchLogs=TRUE in the [options] section of opentext.ini) it will capture the results, including the query that actually gets submitted to the search federator. You might want to check the logs after running the search using the different methods you describe to see what (if any) differences are shown.
Cheers...

Nick_Furness

Hi,

I have done this and i can see how the search was done:

SELECT "OTDisplayKeys", "OTCreatedBy", "OTDComment", "OTHotWords", "OTLocation", "OTMIMEType", "OTName", "OTObject", "OTObjectDate", "OTObjectSize", "OTSummary", "Position", "OTScore" FACETS "OTCreateDate"[20], "OTSubType"[20], "OTObjectSize"[20], "OTFileType"[20], "OTClassificationTree"[20], "OTParentID"[20], "Author"[20] WITH ALL ATTRIBUTES WITH HIT LOCATIONS WHERE ( ( [ region "OTCurrentVersion" ] != "FALSE" ) and ( [ region "OTSubType" ] != "147" ) ) AND ( stem "!£$^&(){}[]-=¬`@#~,_..pdf" ) ORDEREDBY Score[100] ( [region "OTCreatedBy"] "1000" OR [region "OTUserID"] "1000" OR [region "OTVerCreatedBy"] "1000" ) BOOST[+10] [region "OTOwnerID"] "-2004" BOOST[+5] [region "OTParentID"] in ( 305787, 2004, 2000, 306887, 307547 ) BOOST[+10]

However via the REST API i want to be able to say OTName exactly the obscure name it has been given. A stem search performs a search on variations of the value you set.

I am using advanced search with the complex query set to try and get content server to search how i want and return expected results so i can use the logs to reverse engineer the search BUT i can't get Content Server to perform the search.

Any other suggestions?

Nick_Furness

@John Simon
This seems to have resolved the issue:

(("OTLocation" : "2000" )) OR("OTSubType" : "144") OR("OTSubType" : "736")) AND ([qlregion OTName] = "!£$^&(){}[]-=¬`@#~,_..pdf")

However this does exact match, how do i change the = to a conditions where it covers contains as well??

Greg Griffiths

take a look in the KC for OTSQL or LQL references, there is a summary in the Search Doc (v 16.2) https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objId=68745132&objAction=Open&nexturl=/knowledge/cs.dll?func=srch.SearchCache&cacheId=? but you should be able to find the right one for your version.

Nick_Furness

That was exactly what i needed!

Changing the complex query to the following gave me the results i wanted:

[region "OTName"] any (term, "!£$^&_(){}[]-=¬`__@#~,____")

This matched the obscure name with the value even though it ended with ".pdf" as well so it does exact match and basically a contains too.