Search Issue using % wildcard

Hi,

We have CAD drawings where we have to perform a content search of Content Server based on the values within multiple attributes of a CAD block. So on a CAD drawing one example looks like “LC-0393” however as “LC” and “0393” are separate attributes they are indexed as separate entities as shown below.

Using the example above:

- If we perform a search in Content Server using the search box at the top right of the GUI using the string “LC%0393” we receive the correct result (2 documents found).

- If we conduct a search through the CWS service using our own software, which generates a search string using “LC%0393”, we get no results returned.

I believe the issue may possibly be down to the ‘%’ symbol being interpreted as “percent-encoding” however I’m not sure the issue is related to the CWS service.

How should a “contains” be declared within the search string? Can a space be used?

Many thanks

Paul

Find more posts tagged with

Comments

Shruti Talwar

Hi Paul,

We are facing the same issue. Could you please let us know how did achieve the search using wild card via CWS?
Any leads would be appreciated.

Regards,
Shruti

sıɹɥɔ

Hi Paul,

The percent character is not a wildcard for Content Server search. You may be thinking of SQL; it's wildcard characters are unrelated to those of LQL - the language used for searching in Content Server.

The documentation for wildcard characters may be found in the online help, on the "Understanding LQL Conventions" page. It is also here:

https://knowledge.opentext.com/knowledge/piroot/lleswbb/v160211/lleswbb-ugd/en/html/jsframe.htm?sr-lqlconv

Regarding the difference in results between those from a search bar and those programmatically, note that search bars have a configuration to them that are not immediately apparent. Your sysadmin can set this however the default, for example, is that the "Related To" option is enabled. In any event you can click the Advanced Search link on the search results page to see what options were used for the search. If your program uses the same options you should get the same results.

Hope this helps,

-chris

RayTsui

Hi Paul,

The text string "LC-0393" is indexed as one token. Type the string in the search box, without any query modifier, should find what you described.

Ray

RayTsui

My mistake, "LC-0393" is tokenized as two tokens: "LC" and "-0393".