Issue 51143 - Query on Query
Summary: Query on Query
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 680m109
Hardware: All All
: P3 Trivial with 2 votes (vote)
Target Milestone: OOo 2.0.4
Assignee: marc.neumann
QA Contact: issues@dba
Depends on:
Reported: 2005-06-23 07:59 UTC by hflees
Modified: 2006-07-14 14:36 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


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

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
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
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:
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 (
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:
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

this is fixed in the current master. The current master is available at

I close this issue now.

Bye Marc