FULLTEXT INDEX on Filenames with Underscores and Hyphens Doesn't Work as Expected

[marcus-at-localhost]

The search for partial strings in assets doesn't work as expected, since FULLTEXT treats filenames with underscores or hyphens as one word. Therefore, it matches the beginning of a string but not parts of it, as illustrated below:

See also: https://stackoverflow.com/questions/71016653/mysql-match-against-not-find-results-if-an-underscore-is-attached-to-the-search

Edit: after reading about the search (https://help.atrocore.com/#/atropim/user-guide/search-and-filtering?id=search) and using modifiers like % it kind of works but is not obvious to the average user. A note that modifiers are possible (depending if FULLTEXT INDEX is used or not) next to the search field or would be nice.

[rratsun]

We created an internal issue for this. We will solve it soon.