Bug 36519

Summary: There should be a way to dismiss the suggestions in SQL report editor
Product: Koha Reporter: Nick Clemens (kidclamp) <nick>
Component: ReportsAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: anneli.osterman
Version: Main   
Hardware: All   
OS: All   
GIT URL: Change sponsored?: ---
Patch complexity: --- Documentation contact:
Documentation submission: Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Nick Clemens (kidclamp) 2024-04-04 12:24:40 UTC
When writing reports it can be helpful to insert newlines in order to make the report more readable, e.g.:

SELECT
  title,
  author
FROM biblo
WHERE
  author LIKE CONCAT('%',<<Author partial name>>,'%')

Trying to do so with suggestions requires a mouse click to close the suggestions window.

Type 'SELECT' and press enter - it just keeps suggesting 'SELECT'
insert a space and it begins suggesting new things and won't clear until you click with the mouse

I would expect something like ESC to clear the suggestions window
Comment 1 Anneli Österman 2024-04-11 10:49:28 UTC
It would be great to dissmiss the suggestion without clicking with mouse. ESC button sounds logical.