Bug 82323 - query builder should provide visual representation of relationships one to many
Summary: query builder should provide visual representation of relationships one to many
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Queries
  Show dependency treegraph
 
Reported: 2014-08-08 04:19 UTC by Doug
Modified: 2017-11-05 23:27 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Doug 2014-08-08 04:19:36 UTC
Query builder supports one-to-many relationships, but it does not visually display them in builder.  It only draws a line with no other markings that show direction of one-to-many, or that it is other than 1:1.  

Should extend display from Relationships display -- adding identifiers would be more apt here anyway.  Left join should be 1:[infinity]; inner join 1:1, etc.
Comment 1 Robert Großkopf 2014-08-12 16:00:20 UTC
It doesen't work yet in all LO-versions. It's an ask for an enhancement.
So I will switch this to "New" and "Inherited From OOo".

Could be a good Idea to show the differences of "Left Join", "Join" etc.
Comment 2 Alex Thurgood 2015-01-03 17:41:24 UTC Comment hidden (no-value)