Issue 57967 - Mail Merge not working with database queries
Summary: Mail Merge not working with database queries
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 3.0 Beta
Hardware: All All
: P3 Trivial (vote)
Target Milestone: 4.0.0
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2005-11-15 22:55 UTC by safway
Modified: 2013-02-12 22:33 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Actual HSQL database (108.81 KB, application/vnd.sun.xml.base)
2005-11-15 22:57 UTC, safway
no flags Details
Actual Document (8.91 KB, application/vnd.sun.xml.writer)
2005-11-15 22:58 UTC, safway
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description safway 2005-11-15 22:55:31 UTC
After having created a Query with a parameter in the HSQL database, the Query
runs fine within the database.  When I create a document (odt or ott) and insert
database fields from this Query, run the mail merge, I get no output.

I will attach both the odb and odt files.

Note: It doesn't matter if I create the odt file by click-n-drag the database
headers from the navigator or if I create the odt file by Insert | Fields |
Other | Database | Mail Merge Fields | Insert.  The result is the same.
Comment 1 safway 2005-11-15 22:57:45 UTC
Created attachment 31532 [details]
Actual HSQL database
Comment 2 safway 2005-11-15 22:58:27 UTC
Created attachment 31533 [details]
Actual Document
Comment 3 safway 2005-11-15 22:59:38 UTC
The Query that links the ott to the odb is called SalesInvoices_Writer
Comment 4 marc.neumann 2005-11-16 11:25:26 UTC

I can reproduce this. 

A Mail Merge with a parameter query doesn't work, because no parameter input
dialog appear.

Set target and send to the right developer.

Bye Marc
Comment 5 helgekraak 2006-12-12 22:48:43 UTC
I think this issue can be closed.
Comment 6 safway 2008-05-16 22:00:40 UTC
I don't know why helgekraak said this issue can be closed.  We still have no
parameter input dialog appearing.  Can we resubmit this for another look?  I
tested again with OO.o Beta 3.0 and it still is an open issue.

Let me know if I need to include more information.  Thanks.