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.
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.
Ah, yes CLOB fields and reportbuilder, already an open issue on that.
*** This bug has been marked as a duplicate of bug 115893 ***
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.