search engine doesn't search in tables - codebeamer 22.04

[Amaury]

Hi,

In a tracker of requirements, the filter doesn't work with wildcard:

1. for a key like this "XC%":
   1. The engine find "XCSIMU" (ok), but it doesn't find "XC_DEBUG_SRC" (NOK)
   2. 
2. If we do the same thing with "description" field, the result doesn't contain results with de keyword inside a table (same key):
   1. 
   2. I don't see the requirement wich contains this table with "XC IMU POSTPRO":
      1. 
   3. the warning message is not true: 

      MySQL however supports the % character at the start of an occurrence:

      https://www.w3schools.com/mysql/mysql_wildcards.asp:
      1. (WHERE CustomerName LIKE '%a', Finds any values that ends with "a")
   4. Moreover search for a full title works witk "like" operator, but search for a work in a title doesn't work:
      1. 
      2. 

         Doesn't find "Firware restriction"

[Amaury]

support request opened: #17325810

[AndrasJ_hu · Accepted solution]

This issue does not appear in Codebeamer 2.1 any more. Filters are working as expected in Codebeamer 2.1.
See article: https://www.ptc.com/en/support/article/CS416833

[Amaury]

Hi,

the filter works with version 2.1.0.3 (mysql). But the warning message below seems to be useless because "%keyword" works:

1. the warning message is not true: 

   MySQL however supports the % character at the start of an occurrence:

   https://www.w3schools.com/mysql/mysql_wildcards.asp:
   1. (WHERE CustomerName LIKE '%a', Finds any values that ends with "a")