https://bugs.kde.org/show_bug.cgi?id=430147
Bug ID: 430147
Summary: Search and escaping of database wildcard characters in
filenames
Product: digikam
Version: 7.1.0
Platform: Microsoft Windows
OS: Microsoft Windows
Status: REPORTED
Severity: normal
Priority: NOR
Component: Searches-Advanced
Assignee: digikam-bugs-n...@kde.org
Reporter: bbc.qui...@gmx.de
Target Milestone: ---
I have filenames with underscores "_" in them separating information encoded in
them e.g. "56_1607099331_270_3.tif" where the information is an id, a
timestamp, a rotation angle and a camera id.
To tag those files properly I wanted to use the (mighty) search tool, but there
are several things working differently than expected:
Using the "keyword search" (not the "advanced search") with "_270_" also yields
results with filenames containing e.g. "12709". Obviously this field does not
use usual wildcards for file managers ("*" and "?") but the database (in my
case SQLite) ones for a "LIKE" query which are "_" and "%". This is not
documented on
https://docs.kde.org/trunk5/en/extragear-graphics/digikam/using-digikam.html#using-mainwindow-searchesview,
instead it is stated that special characters are ignored.
It is not possible (or I did not find how) to escape those characters to search
for a "real" underscore e.g. escaping with "\" (even multiple ones) does not
work.
The same applies for the advanced search with the "File name" field.
Thanks in advance for having a look into that issue and the great work on this
software.
--
You are receiving this mail because:
You are watching all bug changes.
