We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question
0

does base support text filters? [closed]

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

Susanne gravatar image

updated 2021-06-02 19:40:47 +0200

Alex Kemp 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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-12 13:32:28.590146

1 Answer

Sort by » oldest newest most voted
0

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

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.

screenshot

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

Regards

edit flag offensive delete link more

Comments

Awesome, thank you.

Susanne gravatar imageSusanne ( 2016-09-16 19:28:46 +0200 )edit

Question Tools

1 follower

Stats

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

Seen: 253 times

Last updated: Sep 16 '16