Description: In a Base form record search, in the text selection, the drop down selection box shows suggestions from previous searches from any other database used which may be completely irrelevant to the current database being searched. Need a way to clear previous search terms - such as a right click context action. Steps to Reproduce: 1.Open a Base form 2.Select Record Search 3.Select Search for - Text 4.Select drop down Actual Results: Suggestions show all previous Base form searches Expected Results: Allow clearing of the drop down list suggestions. Reproducible: Always User Profile Reset: No Additional Info: Version: 7.6.0.3 (X86_64) / LibreOffice Community Build ID: 69edd8b8ebc41d00b4de3915dc82f8f0fc3b6265 CPU threads: 12; OS: Windows 10.0 Build 22621; UI render: default; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
That's a good point. I can confirm that I can see previous searches from a different database in a form's Record Search dialog. Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 2902ab24ecc5ffbf4907ea83b2028508b9de6364 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: es-MX (en_AU.UTF-8); UI: en-US Calc: threaded As a comparison, the Find and Replace dialog in Calc and Writer only saves searches per session. Close and reopen LO, the list is cleared. Maybe instead of adding a way to clear the search, it should just do like Calc and Writer and not save anything between sessions? Although there is a request to go the opposite way and make Find and Replace _remember_ searched terms between sessions: Bug 122311 So a design decision should be consistent across these dialogs. In my opinion, if search terms as saved, there should absolutely be an option to clear the list. And possibly, a setting to opt into it. (Thinking of shared computers on which one user might not like discovering that another user is able to see logged search terms they have used previously.)
The context menu solution sounds clunky to me. I can agree with Stephane's idea to remember only within the session. Storing per document could be a privacy issue since we need to save the data. JD, what do you think about just having a clean search when you restart the program?
(In reply to Heiko Tietze from comment #2) > JD, what do you think about > just having a clean search when you restart the program? I think this is a good smaller, first solution to have some consistency and privacy-respecting default, before moving onto solving what bug 122311 requests in a thought-out way.
(In reply to Stéphane Guillou (stragu) from comment #3) > I think this is a good smaller, first solution... As long it doesn't break some workflow. If you think of internet browsers, for example, loosing the history would be very unpleasant.
Search dialog should only show relevant results in a selection. I would prefer to remember the results inside the database file. Another, not so good, solution will be to delete the results at the end of the session. By the way: I don't use this kind of dialog for searching through a form. Too slow, too complicated and only results in one form, not in subforms …
We discussed the topic in the design meeting. The implementation should either store the search terms in the database, or in case of too much effort clear after the session ends.
My original thought and suggestion was kind of based on the way Firefox handles the search field - past searches will appear as suggestions while typing in the search terms. And, in addition there is a right click option to clear the search history. History is kept between sessions. I personally like the option to clear or keep but for consistency purposes a clean history at the start of each session - like calc & writer would be acceptable also. Thanks for considering this.