Ask Your Question

How to acquire "FileMaker-like" query in LibreOffice Base?

asked 2019-11-02 15:14:10 +0100

Ivo_B gravatar image

updated 2019-11-02 20:17:37 +0100

Hi, Apart from building a few databases with FileMaker(Claris) a long time ago, I don't have any programming or SQL-skills. Thanks to the answer of @Ratslinger to my previous question, I have been able to create a working LibreOffice Base which displays now all the 1635 recipe records. (with 3 CLOB [ BLOB ] fields because of lots of text and pictures in a BLOB [ BLOB ] field) I thought my job was finished, but I was disappointed when I noticed that the looking glass icon in the form did not do what I expected it to do. I've been reading in the LibreOffice 6.3 Help Query Design section, but being an SQL-illiterate I don't understand much of it. Is it possible to query a form in LibreOffice on all fields simultaneously with user input? (Like "Cmd-F in FileMaker) If so, how complicated is it for me as an SQL illiterate? (but absolutely wanting to learn)

edit retag flag offensive close merge delete



Although I may have at some time used FileMaker, I have no real recollection of its' operation. You should not guess that others are familiar with the process either. Rather be specific with the request. It appears you want to search through ALL fields in a table looking for some value. This can be costly with large BLOB fields. Can you be more specific on this process you want to accomplish? SQL is a must know when working with databases. It can alleviate many situations. Here is one site (there are many) which may help -> SQL Tutorial

Ratslinger gravatar imageRatslinger ( 2019-11-02 18:22:44 +0100 )edit

Hello @Ratslinger, Thanks for the link, I will surely look into that. You 're right, I want to give the user ((1.) my wife and (.2) myself) the opportunity to search through fields in the base table looking for user defined wildcard value for one CLOB [ BLOB ] field - if needed in combination with user defined wildcard value in another CLOB [ BLOB ] field and/or Text [ VARCHAR ] field and/or Check Box field. The "Wildcard" element is important here, I need %. I now understand that this might be way too ambitious for me and that it would be better to start creating a query which already does the job for one CLOB [ BLOB ] field (with user input), so that I can copy it to use it for other CLOB [ BLOB ] field queries. Do I need to create a specific "query form" for that, or can in I implement the query in ...(more)

Ivo_B gravatar imageIvo_B ( 2019-11-02 20:48:29 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-11-02 21:22:15 +0100

Ratslinger gravatar image


What you are asking is a fairly broad subject. There are popular methods for searching data - using LIKE in SQL and table filtering or a combination of both. Have posted many, many samples on this site related to table filtering and using wild cards in SQL. Here are a couple of related links:

Need to Filter a table with two fields for key words

how to put a search box into a LO Base form

These posts contain samples and links to further posts which will take some time to absorb. Included is using SQL wildcards and table filtering. Method used depends on actual needs.

As for 'costly' comment, with multiple BLOB fields (can be a large amount of data in each) and a number of records, this can be time consuming searching through all this only to find, depending on the search method, results not wanted. Then you start over.

edit flag offensive delete link more


@Ratslinger: Thanks! I got a few challenges in front of me. :-)

Ivo_B gravatar imageIvo_B ( 2019-11-03 01:54:57 +0100 )edit


If you run into trouble, ask a new question with some specifics on what the problem is and what you are trying to accomplish. Always include OS, specific LO version and database being used. Samples are always helpful. Screenshots not so much.

Questions always welcome.

Ratslinger gravatar imageRatslinger ( 2019-11-03 02:47:04 +0100 )edit

@Ratslinger Thanks! I'm calculating some time to absorb, I hope the Mrs. will be able to do the same. ;-) I'll be back with specifics on problems I encounter, including OS, LO version and DB being used.

Ivo_B gravatar imageIvo_B ( 2019-11-04 00:06:00 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-11-02 15:14:10 +0100

Seen: 39 times

Last updated: Nov 02