Posted Wed, 27 Feb 2019 18:45:55 GMT by John DeLaat

Running version 7 cloud - I am trying to find a "value" in a string with fulltext and cannot get any results returned.  I tried "*xxxxx*" and no results.  I am searching for the 23032 in the string below, what would be the syntax in fulltext to find that?


Posted Thu, 28 Feb 2019 05:42:45 GMT by Gilles Sauvagnat Altexence Président


Do you search with only the full text index, or do you also search with an other index ?

If yes, is wildcard actived for the other index. ?

If yes, does the value searched  in the index contain a space ?

If yes to all the questions above, too bad for you (and other users) you found a bug (under investigation)

Best regards


Posted Thu, 28 Feb 2019 11:07:34 GMT by John DeLaat

Only searching using full text, no other filelds.

Posted Thu, 28 Feb 2019 11:45:00 GMT by Gilles Sauvagnat Altexence Président

*23032* should work 

Except if 0 (number) is misinterpreted and OCRed as O (letter O) 0, 8, B, i, l for instance are good candisates for misinterpretation with OCR engine

Try different value without 0

If nothing is found,  sounds like a problem with fulltext on your DW organization, you should open a SR, fulltext might be broken on your organization.



You must be signed in to post in this forum.