Issue 65437 - wildcard substitution in parameter dialog doesn't work
Summary: wildcard substitution in parameter dialog doesn't work
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: recent-trunk
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2006-05-16 12:38 UTC by Frank Schönheit
Modified: 2017-05-20 10:45 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description Frank Schönheit 2006-05-16 12:38:11 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.
Comment 1 Frank Schönheit 2006-05-16 12:38:52 UTC
Comment 2 Frank Schönheit 2006-07-19 15:22:42 UTC
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.
Comment 3 Marcus 2017-05-20 10:45:31 UTC
Reset the assignee to the default "".