Issue 114273 - Query wizard: cannot set more than one conditions at "3.Serach conditions"
Summary: Query wizard: cannot set more than one conditions at "3.Serach conditions"
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOO330m6
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: OOo 3.3
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords: regression
Depends on:
Blocks: 111112
  Show dependency tree
 
Reported: 2010-09-02 13:26 UTC by kamataki
Modified: 2017-05-20 10:21 UTC (History)
3 users (show)

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

Attachments
sample odb file (3.61 KB, application/vnd.sun.xml.base)
2010-09-02 13:28 UTC, kamataki 		no flags Details
ref. Issue_QueryWiz01.jpg (35.76 KB, image/jpeg)
2010-09-02 13:28 UTC, kamataki 		no flags Details
ref. Issue_QueryWiz02.jpg (39.48 KB, image/jpeg)
2010-09-02 13:29 UTC, kamataki 		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 kamataki 2010-09-02 13:26:42 UTC 
Please use attached Issue_QueryWiz_en.odb.

I set more than 2 conditions at "3.Serach conditions". ref. Issue_QueryWiz01.jpg

However query wizard view "No conditions were assigned" at "8.overview". ref.
Issue_QueryWiz02.jpg

When data type appoints a field of "VARCHAR", this problem happens. When data
type appoints a field of "INTEGER", this problem does not happen.

I confirmed with OOO330m6 and Windows XP.  OpenOffice.org 3.2.1 works.
Comment 1 kamataki 2010-09-02 13:28:02 UTC 
Created attachment 71530 [details]
sample odb file
Comment 2 kamataki 2010-09-02 13:28:42 UTC 
Created attachment 71531 [details]
ref. Issue_QueryWiz01.jpg
Comment 3 kamataki 2010-09-02 13:29:11 UTC 
Created attachment 71532 [details]
ref. Issue_QueryWiz02.jpg
Comment 4 drewjensen.inbox 2010-09-03 02:04:20 UTC 
Confirmed w/ OOO330m_5, Lucid 10.04

If you use the wizard and set one selection criteria then all is correct.

If you try to set a second or more selection criteria then, in some cases, all
the criteria settings are lost.

Case 1 - Set a single selection criteria. Use the NEXT button to move through
the wizard and verify the criteria was accepted. It is, now if you use the BACK
button to go back and add additional criteria, the additional entries will be
lost but the initial entry will be retained and will be part of the SQL
generated when you execute the wizard.

Case 2 - Set more then one selection criteria initially. Use the Next button to
move through the wizard and you will see that now criteria is set. If you finish
and save at this point the SQL generated does not include any criteria.

Case 3 - Set more then one selection criteria initially. Immediately finis and
save the query. The SQL generated includes the first selection criteria
selected, but none others.
Comment 5 drewjensen.inbox 2010-09-03 02:08:19 UTC 
Sorry to be clear. In Case two - when you move forward in the wizard you see
that NO criteria is set. (not now criteria)
Comment 6 kamataki 2010-09-03 03:18:25 UTC 
Yes! cannot more than one.

Thnks.
Comment 7 ocke.janssen 2010-09-03 06:32:34 UTC 
I target it for 3.4. If it is a regression to an earlier version please write a
mail to releases@openoffice.org to nominate it. Thanks.
Comment 8 Olaf Felka 2010-09-06 11:02:52 UTC 
Proposed to be fixed in 3.3
Comment 9 Frank Schönheit 2010-09-17 09:49:17 UTC 
fs->msc: please verify in CWS dba33j
Comment 10 Frank Schönheit 2010-09-17 09:57:39 UTC 
oops, wrong script, again. Grabbing back.
Comment 11 Frank Schönheit 2010-09-17 09:58:07 UTC 
fixed in CWS dba33j

find more information about this CWS, like when it is available in the master
builds, in EIS, the Environment Information System:
http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300/dba33j
Comment 12 Frank Schönheit 2010-09-17 09:58:41 UTC 
note: follow-up issue: issue 114566
Comment 13 ocke.janssen 2010-09-20 07:14:47 UTC 
*** Issue 114566 has been marked as a duplicate of this issue. ***
Comment 14 Frank Schönheit 2010-09-20 09:26:45 UTC 
both this issue here and issue 114566 seem to be a regression of the fix for
issue 108548
Comment 15 Frank Schönheit 2010-09-23 08:34:31 UTC 
fs->msc: please verify in CWS dba33j
Comment 16 marc.neumann 2010-09-27 08:53:27 UTC 
verified in CWS dba33j

find more information about this CWS, like when it is available in the master
builds, in EIS, the Environment Information System:
http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300/dba33j