Issue 51143

Summary: Query on Query
Product: Base Reporter: hflees <lx3hf>
Component: codeAssignee: marc.neumann
Status: CLOSED FIXED QA Contact: issues@dba <issues>
Severity: Trivial    
Priority: P3 CC: issues, yoshimit
Version: 680m109   
Target Milestone: OOo 2.0.4   
Hardware: All   
OS: All   
URL: http://dba.openoffice.org/specifications/Queries_in_Queries_.odt
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

Description hflees 2005-06-23 07:59:39 UTC
The competiting product allows queries to be created based on existing queries. 
However, OpenOffice.orgBase only allows queries on tables.
Comment 1 marc.neumann 2005-06-23 08:43:14 UTC
Hi,

I reassign it to the User Experience Team for evaluating.

Bye Marc
Comment 2 drewjensen.inbox 2006-04-20 10:29:34 UTC
IMO, this is a duplicate issue to 48116, simply stated in other words.
Comment 3 Frank Schönheit 2006-04-20 14:01:44 UTC
I don't think that this is the same as issue 48116. While both sub selects and
"queries on queries" can address the same user problem, they can be implemented
separately, and none of the two automatically gives us the other one if implemented.

Grabbing, will work on this for at least the HSQLDB engine (OOo's integrated
default engine). Targeting to 3.0 for the moment, which is just a placeholder
here for "whenever it's ready".
Comment 4 Frank Schönheit 2006-04-20 14:13:43 UTC
starting
Comment 5 Frank Schönheit 2006-06-16 12:41:26 UTC
targeting to 2.x, which is the depot for issues ot be fixed for one of the next
releases
Comment 6 Frank Schönheit 2006-07-04 14:17:01 UTC
fixed in CWS qiq

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=SRC680%2Fqiq
Comment 7 Frank Schönheit 2006-07-06 08:25:03 UTC
fs-> msc: please verify in CWS qiq
Comment 8 Frank Schönheit 2006-07-06 08:29:50 UTC
adding specification link as URL
Comment 9 Frank Schönheit 2006-07-06 08:32:37 UTC
targeting to 2.0.4
Comment 10 hflees 2006-07-07 01:21:20 UTC
I would like to comment on Query Designer, page 6 of the specification 
documentation (http://dba.openoffice.org/specifications/Queries_in_Queries_.odt.
Is it possible to have an option to display both the table and query, instead 
of just radio buttons to display either one of them at one time? To display 
both table and query together, there is a need to differentiate them by using 
different icon. Thanks.
Comment 11 Frank Schönheit 2006-07-07 08:22:16 UTC
The different icons are there nowadays, so this would not be a problem. Yet, the
team designing the feature decided to not have this combined list, as it would
be difficult to present when the tables are hierarchical, i.e. when you connect
to a database which supports schemas and/or catalogs.
Comment 12 marc.neumann 2006-07-07 09:23:53 UTC
verified in CWS qiq

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=SRC680%2Fqiq
Comment 13 hflees 2006-07-14 05:59:47 UTC
Tested it on m176 -> looks good. Thanks for the great work.
Comment 14 Frank Schönheit 2006-07-14 07:05:05 UTC
thanks for the positive feedback, this is rare, but encouraging :)
Comment 15 marc.neumann 2006-07-14 14:36:15 UTC
Hi,

this is fixed in the current master. The current master is available at
http://download.openoffice.org/680/index.html

I close this issue now.

Bye Marc