Ask Your Question

does base support text filters?

asked 2016-09-16 14:37:12 +0100

Susanne gravatar image

I have an MS Access database (flat file) for craft projects. it simply has a variable length text field (memo) to hold some keywords I use to filter the records, a link to a PDF or Word file and a link to an image of the project. I use mainly one form so that I can actually see the image and page through the selected records. I am thinking of giving up on windows and going to Linux, using LibreOffice. I have seen I can link to files and images, and also build forms. My question is on the searching/filtering : access lets my match a word anywhere in this memo field by using the "Text filter" "contains" way of filtering. I can do so for several levels (refining down my search results). For instance I look for all records containing the word "child" in the memo field, then use the word "knitting" within those search results, then the word "sweater" to narrow it down even more.

it makes for a smaller database by being able to put keywords into one memo field instead of having 25 extra columns with possible descriptors and drop down lists.

Does LibreOffice Base support these "text filters" ? Thanks, Susanne

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-09-16 17:46:48 +0100

pierre-yves samyn gravatar image

Hi @Susanne

Yes, LibreOffice suports "text filters". Filter can be used "by example" in a form (you type the criteria directly in the form) or filter via the toolbar. I have grouped the two dialogs in the screenshot below.


However, by default, LibreOffice does not allow successive filtering. As you can see from the screenshot, use the AND and OR operators


edit flag offensive delete link more


Awesome, thank you.

Susanne gravatar imageSusanne ( 2016-09-16 19:28:46 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-09-16 14:37:12 +0100

Seen: 110 times

Last updated: Sep 16 '16