Bug 7655 - Runtime parameters: Allow for making free text and date fields optional without the need for users to enter %
Summary: Runtime parameters: Allow for making free text and date fields optional witho...
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Reports (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Galen Charlton
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-03-06 17:00 UTC by Shane Sammons
Modified: 2023-01-08 00:04 UTC (History)
1 user (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Shane Sammons 2012-03-06 17:00:28 UTC
Add a second field tag (placeholder / runtime argument) similar to <<>>, but it would user a logical check for no value and would either omit the argument (harder would require something like a regex removal) or put in the "%" for the end user. I was thinking something like <{}>, <[]>, <()>.
Comment 1 Katrin Fischer 2019-04-28 21:25:45 UTC
Something you can do as a work around:

WHERE xxx LIKE CONCAT('%',<<search term>>,'%')

This way the users don't have to add the %.
Comment 2 Katrin Fischer 2023-01-08 00:03:33 UTC
We also have :all now, that works on drop down lists and adds an entry with % that is pre-selected.

Having a % for date or free text is probably not as easy to resolve.