Download it now!
Bug 122167 - "List" Field from FireBird query doesn't show up at mail merging
Summary: "List" Field from FireBird query doesn't show up at mail merging
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Mail-Merge
  Show dependency treegraph
Reported: 2018-12-18 07:31 UTC by Alex Ander
Modified: 2020-10-07 16:14 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Database, document for mailmerging and its result (16.61 KB, application/zip)
2018-12-18 07:31 UTC, Alex Ander

Note You need to log in before you can comment on or make changes to this bug.
Description Alex Ander 2018-12-18 07:31:28 UTC
Created attachment 147642 [details]
Database, document for mailmerging and its result

I prepared an embedded Firebird database in LO Base. There I've made a query with "LIST()" function, which concatenates strings at grouping by. I can see results of this query. 
The problem is in the LO Writer, when I make a Mail Merging from the query results. The whole line with the field made from "LIST()" disappears.
I made files to demonstrate this bug.
Comment 1 Alex Ander 2018-12-20 01:21:26 UTC
I found, what was the problem:
LIST() returns CLOB data. After I have converted it to VARCHAR, I've got the needed result.
So, my suggestion is to make such conversion automatically.
Comment 2 Drew Jensen 2018-12-20 14:04:46 UTC
Ah, yes CLOB fields and reportbuilder, already an open issue on that.

*** This bug has been marked as a duplicate of bug 115893 ***
Comment 3 Drew Jensen 2018-12-20 15:40:51 UTC
After talking with folks on the QA channel and testing HSQL memo fields with the text ODT file linked against an HSQL embedded ODB, verifying the MEMO field there does  work properly with Mailmerge setting this as NEW instead of a duplicate.

Leaving the Reportbuilder issue under the see also property.