Issue 60950 - Conditional text fails with DB-field condition based on queries
Summary: Conditional text fails with DB-field condition based on queries
Status: ACCEPTED
Alias: None
Product: Writer
Classification: Application
Component: ui (show other issues)
Version: OOo 2.0.1
Hardware: All All
: P4 Trivial with 9 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa, regression
Depends on:
Blocks:
 
Reported: 2006-01-21 18:28 UTC by andreschnabel
Modified: 2017-05-20 11:20 UTC (History)
7 users (show)

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

Attachments
database for testing (3.68 KB, application/octet-stream)
2006-01-21 18:29 UTC, andreschnabel 		no flags Details
writer file for testing the fields (6.35 KB, application/vnd.oasis.opendocument.text)
2006-01-21 18:30 UTC, andreschnabel 		no flags Details
test-document related to the database testdb.odb where the problem is reproducable with OpenOffice 2.0 (7.13 KB, application/vnd.sun.xml.writer)
2006-03-28 00:08 UTC, laura36 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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".