[Libreoffice-bugs] [Bug 42120] Form based filters not functional in database

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=42120

Lionel Elie Mamane <lionel at mamane.lu> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |NOTABUG

--- Comment #5 from Lionel Elie Mamane <lionel at mamane.lu> 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.