Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hello,

Your question is a bit conflicting. Your TAGS state 'base' but your details show '.ods' (Calc).

In order to see your data in 'Data Sources' it must be registered. For a Calc DB (most likely what you are discussing) see answer in this post for detailed info.

Hello,

Your question is a bit conflicting. Your TAGS state 'base' but your details show '.ods' (Calc).

In order to see your data in 'Data Sources' it must be registered. For a Calc DB (most likely what you are discussing) see answer in this post for detailed info.

Edit 11/15/2017:

In response to your secondary question, you can create a Query (SQL selection of information from table) which will then become available in the Data Sources under Queries instead of Tables. Information on creating queries can be found in the LO Base documentation, Chapter 5 - click here. Databases bases upon spreadsheets can only use SQL in a limited fashion. However yours is simple enough for this. Your statement will be something like:

SELECT * FROM "YOUR_TABLE_NAME" WHERE "CHRISTMAS LABEL" = 'Y'

Now this is direct SQL code but the documentation also shows how to use the IDE to generate. It's not as hard as it may sound.

If this answers your question please click on the ✔ (upper left area of answer).