Five years ago, I created a query in an OO database and used that query to populate some documents in Writer. Now I have to do the same thing again with updated data. The only problem is, I don’t remember how to get the source to be the query I set up in Base. Here is the detail.
- I have a database set up in MySQL in 3rd normal form
- I created some views to select the correct data
- I created a query to access the views to retrieve the data
- I created a Writer template as my merge document
- I defined the query as my source (I cannot remember how I did this step)
- I successfully ran the merge
I have tried opening an existing database as a source, but that does not give me access to the LO queries. I have tried connecting to an existing MySQL database, but I have the same problem; no accesss to the LO queries.
Perhaps there is someone out there who can tell me how to accomplish this, i.e., use the query output directly as my merge source.