https://bugs.documentfoundation.org/show_bug.cgi?id=44954
--- Comment #19 from Adlair Cerecedo-Mendez <[email protected]> --- I’ve been looking into this behavior and prepared a possible fix for the issue described here, where Record Search in forms does not actually respect the “Where to search → Single field” option. The underlying problem seems to be that the dialog never delegated the search to the form’s RowSet in a way that properly constrained the query to the selected field. As a result, searches behaved like “All fields”, and the UI didn’t reliably reflect the user’s chosen search scope — which matches the reports across this thread and the observations in earlier comments. I’ve implemented SQL-based delegation when “Single field” is selected, so the search is now correctly restricted to that field. The filtering logic is applied directly to the RowSet using the appropriate LIKE expression depending on the chosen match mode (anywhere / begins with / ends with / whole). If the delegated search finds records, the cursor is positioned accordingly; if not, the dialog handles the “no matches” situation in a consistent way. The patch is available here for review: https://gerrit.libreoffice.org/c/core/+/194663 Marking this as a possible solution, as additional review and testing are welcome. -- You are receiving this mail because: You are the assignee for the bug.
