Bug 152523 - MailMerge prints every other record
Summary: MailMerge prints every other record
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
7.3.3.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Mail-Merge
  Show dependency treegraph
 
Reported: 2022-12-15 15:57 UTC by Rev. LeRoy Cressy
Modified: 2023-08-15 03:15 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
The Condition defaults to "TRUE" and should be blank (42.24 KB, image/png)
2022-12-15 15:57 UTC, Rev. LeRoy Cressy
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Rev. LeRoy Cressy 2022-12-15 15:57:47 UTC
Created attachment 184160 [details]
The Condition defaults to "TRUE" and should be blank

When creating a mail merge document or label the Next record field at the end of the document or label the Condition defaults to "TRUE"  With older versions of LibreOffice this was fine.  With this version only every other record is printed.  When I removed the "TRUE" condition it worked as before.

The Database I'm using is PostgreSQL which works fine.  Earlier this month before doing several Full System Upgrades on my Arch Linux System it worked fine.

I tested this with several older files which merged correctly previously, but now just merge with every other record.

Since I'm using PostgreSQL it might only concern the SQL database I'm using.  I have not tested this against the internal Database in LibreOffice.

I would suggest that if this is only a problem with SQL Databases like PostgreSQL, MySQL, or others, then please including a warning message about the Next record field condition.
Comment 1 Robert Großkopf 2023-01-15 08:21:15 UTC
Have tested with different LO versions: LO 7.4.4, LO 7.1.5 and also 6.4.7.2. When creating a mail merge document and starting to add "Next record" it always will add with condition = True. 
Why should this be wrong? You wish to load next record after setting this field type.

Tested with
Version: 7.4.4.2 / LibreOffice Community
Build ID: 85569322deea74ec9134968a29af2df5663baa21
CPU threads: 6; OS: Linux 5.3; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded

(and older versions)

Please add a little internal database and a Writer document. There shouldn't be a difference if using PostgreSQL or any other database, so an internal database will produce the same behavior.
Comment 2 QA Administrators 2023-07-15 03:13:24 UTC Comment hidden (obsolete)
Comment 3 QA Administrators 2023-08-15 03:15:21 UTC
Dear Rev. LeRoy Cressy,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-FollowUp