Apache OpenOffice (AOO) Bugzilla – Issue 65437
wildcard substitution in parameter dialog doesn't work
Last modified: 2017-05-20 10:45:31 UTC
- open the attached database - open the query "All Orders" by double-clicking it => a dialog opens which asks for a paramter - enter *i* and dismiss the dialog with OK => the query data is displayed, but no records are shown Entering %i% instead of *i* shows two records, as expected. However, % is SQL dialog, and usually, OOo hides this SQL dialog from the UI in all places: keywords are localized (e.g. "WIE" instead of "LIKE" in an german installation), and placeholdes % and _ are substituted with the more wide-spread ones * and ?. This substitution, for instance, takes place when filtering a table with (you can enter criterions such as "LIKE *i*" in the filter dialog). For consistency reasons, we should do this substitution also in the parameters dialog.
accepting
This is more complex than I thought .. for properly allowing '*' instead of '%', we would need to know that the parameter results from a LIKE predicate. This is because we want to continue to disallow '*' (more precise: treat it as non-wildcard) when the paramteter results from e.g. a comparison. However, there's no infrastructure at all currently which would tell us where a paramater results from. This could be introduced, but it would be quite some work, so 2.x is not justified for this enhancement.
Reset the assignee to the default "issues@openoffice.apache.org".