Issue 86169 - Allow tables to be aliased in GUI query designer
Summary: Allow tables to be aliased in GUI query designer
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: recent-trunk
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa, usability
Depends on:
Reported: 2008-02-18 05:17 UTC by drewjensen.inbox
Modified: 2013-02-07 22:40 UTC (History)
1 user (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 drewjensen.inbox 2008-02-18 05:17:46 UTC
Open the the bugdoc attached to Issue #: 73627

Open any of the queries

Now ask yourself "How would I create these using the Query Designer?"

The situation is that you can not - if you added the persons table twice the
designer would create "persons" and "persons_1". There is no support for
actually setting the alias for the tables as there is for columns,

You could switch the designer off and then in the SQL view change the table
aliases, but by the time the query is complicated enough that it is a problem,
this becomes a problem.

There seems three obvious ways to add this enhacnement:

One support a Find & Replace function when in SQL view mode.
Two add a popup menu for the table objects with "Rename" or "Alias"
Three support in-place editing of the table object name.

Of course a combination of One and Three would be real nice.
Comment 1 drewjensen.inbox 2008-02-18 05:18:26 UTC
Added keyword - usability
Comment 2 christoph.lukasiak 2008-05-06 11:16:30 UTC
achnowledge and send further to the requirements team
Comment 3 christoph.lukasiak 2008-06-18 14:51:42 UTC