base: query by example

Is there a way in LibreOffice Base to query by example? In other words, perhaps have a form that includes a field for vendors, and you want to enter the query LIKE JOHN in the field to find all vendors that have JOHN in the name. I want to be able to find the one I’m looking for in the list of found records and immediately edit any of the data that appears in that record. Ideally, this would work with numeric fields as well, where you could enter >100 in such a field to find all amounts greater than one hundred.


This is simply form filtering.

Please see my answer in this link → how to put a search box into a LO Base form

It contains links to other answers which may also have further links.

This appears to be exactly what I needed to understand. Thank you.