Issue 60950

Summary: Conditional text fails with DB-field condition based on queries
Product: Writer Reporter: andreschnabel <andre.schnabel>
Component: uiAssignee: AOO issues mailing list <issues>
Status: ACCEPTED --- QA Contact:
Severity: Trivial    
Priority: P4 CC: gckoehler, helge.kraak, holgerbruenjes, issues, josef.latt, jr, openoffice
Version: OOo 2.0.1Keywords: oooqa, regression
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
database for testing
none
writer file for testing the fields
none
test-document related to the database testdb.odb where the problem is reproducable with OpenOffice 2.0 none

Description andreschnabel 2006-01-21 18:28:31 UTC 
If a conditional text (or hidden text / hidden character) is defined and the
condition is based on a database field, this will not work, if the source is a view.

It's ok with tables or views.

see attached examples:
- use testdb.odb as data source
- use doctestdb.odt for testing the fields

as long as you use Abfrage1 as Datsource, condtional and hidden texts are not
updated. If you use "Tabelle1" or "View1", the fields are ok (use Edit -
Exchange Datebase to use the table or view).

This has been reported for OOo 2.0.1 and is still reproducable in m150
Comment 1 andreschnabel 2006-01-21 18:29:24 UTC 
Created attachment 33438 [details]
database for testing
Comment 2 andreschnabel 2006-01-21 18:30:10 UTC 
Created attachment 33439 [details]
writer file for testing the fields
Comment 3 michael.ruess 2006-01-23 08:34:18 UTC 
Reassigned to ES.
Comment 4 p9w.vu.31122010 2006-01-23 13:51:18 UTC 
Works for me with OOo 2.0.0 (680m3).
Comment 5 eric.savary 2006-02-08 15:08:21 UTC 
ES->OS: Broken since OOo 2.0.1.
Comment 6 laura36 2006-03-28 00:00:01 UTC 
Already in 2.0 there where several Problems. Hidden paragraphs worked fine in
normal mail merge but did not in documents in which is set an field "next
record" like in labels-documents. While the view on the screen which "data to
fields" works fine, the hidden paragraphs are empty if you print them via the
dialog -> print -> print form letter. After proceeding also the fields on the
screen are now empty.
In OpenOffice.org 2.0.1 and 2.0.2 even the view on the screen works anymore. I
tried this whith an mysql-database an several querys. Whith tables it workes
fine. Due to the mysql-database I can't attach an example.
Comment 7 laura36 2006-03-28 00:08:41 UTC 
Created attachment 35295 [details]
test-document related to the database testdb.odb where the problem is reproducable with OpenOffice 2.0
Comment 8 Oliver Specht 2006-05-18 12:48:22 UTC 
Target changed to 2.x
Comment 9 helgekraak 2007-02-12 00:06:57 UTC 
This issue can be closed I think.
Comment 10 Mathias_Bauer 2007-12-04 13:28:09 UTC 
target 3.x

helgekraak: why do you think that this issue can be closed?!
Comment 11 helgekraak 2007-12-04 17:34:13 UTC 
Sorry, I was probably wrong. I thought of conditional text fields based on
queries. I had an issue with this which was solved. Sorry again!
Comment 12 Marcus 2017-05-20 11:20:06 UTC 
Reset assigne to the default "issues@openoffice.apache.org".