https://bugs.freedesktop.org/show_bug.cgi?id=42120
Lionel Elie Mamane <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |NOTABUG --- Comment #5 from Lionel Elie Mamane <[email protected]> 2012-04-17 02:04:55 PDT --- The "form by filter" works exactly like the "condition" lines of the query designer. That is, the default operator is "="; if you type a string like "T*" in field "fname" it means you are filtering for records that have exactly "T*" in fname, and not "anything that begins with T". If you want to use a pattern, you need to write "LIKE 'T*'" (without the surrounding double quotes, but with the internal single quotes). You may argue that both should automagically recognise patterns (I'm not sure I would agree), but that is at most an enhancement request, not a bug. In my opinion, this should be consistent between the query designer (condition column) and "filter by form". So if we change one, we should change both. (In reply to comment #4) > What is interesting, "Auto filter" adds this LIKE '' to search string, I would consider this a bug. It should definitely use equality (or IS NULL for NULL values). Auto Filter asks for records with the same value in the specified field. This way of doing it mixes up the notion of pattern and of value: the field contains a *value*, not a pattern! -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
