Issue 65437

Summary: wildcard substitution in parameter dialog doesn't work
Product: Base Reporter: Frank Schönheit <frank.schoenheit>
Component: codeAssignee: AOO issues mailing list <issues>
Status: ACCEPTED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: recent-trunk   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

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 
accepting
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 "issues@openoffice.apache.org".