Issue 96330 - creating left/right queries user experience
Summary: creating left/right queries user experience
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 3.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2008-11-19 03:17 UTC by drewjensen.inbox
Modified: 2013-02-07 22:39 UTC (History)
1 user (show)

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

database with example queries (5.09 KB, application/vnd.sun.xml.base)
2008-11-19 03:18 UTC, drewjensen.inbox
no flags Details
Screen shot showing 2 queries and possible confusion (179.58 KB, application/
2008-11-19 03:19 UTC, drewjensen.inbox
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description drewjensen.inbox 2008-11-19 03:17:03 UTC
The result set produced by Left or Right joins is influenced by which direction
one moves the mouse during the selection of columns to join on.
IMO this leads to confusion on the part of some users, particularly less
experienced users that are not confident in their knowledge of SQL.

Open the attached odb file - run the 4 queries and look at each in the query
designer. The queries have names that designated both the type of JOIN and which
direction the mouse was dragged when the join was created.
ie. qry_left_join_L2R = a left join created by dragging the linked column from
the table on the left to the table on the right with the mouse.

Open the attached odg file for the pretty pictures..

Honestly I think this is actually a usability defect, but RFE is good also.

Possible changes:

1) None - it works just fine the way it is.

2) The drag direction should make no difference - Which table is on which side
of the join should be based solely on the placement of the table objects in the
query designer.

3) Some change to the UI, when the "Join Properties" dialog is not displayed so
that the user both knows which table is on the which 'side' of the join and what
type of join is being represented. ( perhaps I am mixing something new in the
last section of this option? )

Others ??
Comment 1 drewjensen.inbox 2008-11-19 03:18:16 UTC
Created attachment 58103 [details]
database with example queries
Comment 2 drewjensen.inbox 2008-11-19 03:19:31 UTC
Created attachment 58104 [details]
Screen shot showing 2 queries and possible confusion
Comment 3 christoph.lukasiak 2009-01-20 11:22:03 UTC
send further to the requirements taem
Comment 4 christoph.lukasiak 2009-01-20 11:22:52 UTC
set to new