Apache OpenOffice (AOO) Bugzilla – Issue 86169
Allow tables to be aliased in GUI query designer
Last modified: 2013-02-07 22:40:13 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.
Added keyword - usability
achnowledge and send further to the requirements team
.