Issue 86169

Summary: Allow tables to be aliased in GUI query designer
Product: Base Reporter: drewjensen.inbox
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: recent-trunkKeywords: oooqa, usability
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

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
.