Introduction: LibreOffice Base Tutorial (Making a Filter Inside a Form)

In this Tutorial, I make a new database using LibreOffice Base and I try to make a filter form using an external SQL Query.

Using text box, or combo box as parameter for searching for items in records, is not easy in LibreOffice. In this tutorial I show you how to do it.

In LibreOffice Base, you cannot copy or paste data from table-object inside a form if the data-input for the objects comes from an embedded SQL query inside the form itself.

So, to solve this problem, you need to make an external SQL.

This tutorial is based on the original tutorial that you find it here

https://www.youtube.com/user/TheFrugalComputerGuy (Video 55,56,57)

Comments

author
Fyon (author)2014-12-05

Thank you for your tutorial, good to learn from it. I have a question. I am working on a database with materials. So I made check boxes for the materials. And I want to check multiple materials for one search, and I want those materials to end up in the table material with a comma in-between. So be clear: I check cotton, hemp and soy. Then I want the table material to say: cotton, hemp, soy and I want all the factories that have one of these 3 materials to be listed (so it could also be that it only says cotton). I added all the data in a table as you can see in the second picture per material. So factory 1 has none of those materials as they are all false. (the list goes further on then silk, with other materials) but the 16th Factory has Nettle. Do you know how I can do this?

Screen Shot 2014-12-05 at 11.36.42.pngScreen Shot 2014-12-05 at 11.39.18.png
author
mjm2008 (author)Fyon2014-12-07

Hi, thank you for your comment.

As I did, you make the filter using a separate table for search purpose only. and if you look at all videos I have on Youtube, you will understand how to combine several items together. You can add several columns and make them to be collected and summed in one column in the SQL Query.

The result will not be a table, it will be a SQL query. From that you can show your data in a table-object.

Please try to see the videos I have and download the database files, I hope you understand how I did them.

author
seamster (author)2014-09-01

Interesting, thanks for sharing.