Kexi/Assistants/Lookup Column Assistant: Difference between revisions

From KDE Community Wiki
No edit summary
No edit summary
Line 8: Line 8:


{{Note|Original wiki page: [http://web.archive.org/web/20060924174001/http://www.kexi-project.org/wiki/wikiview/index.php?LookupColumnWizardDocs]}}
{{Note|Original wiki page: [http://web.archive.org/web/20060924174001/http://www.kexi-project.org/wiki/wikiview/index.php?LookupColumnWizardDocs]}}
== Pages ==
=== Page: WELCOME. Select lookup type ===
There are two types of definition for the "many" side of this relation:
* type#1: Picking an existing table or query, so their rows will be displayed for selection
* type#2: Simple version: Entering rows by hand, what creates a simple dictionary.
The 1st type is more generic, and allows to reuse once defined data schemas.
<pre>
Sequence Diagram
WELCOME:SelectLookupType ->
    (type#1)-> TableOrQueryDataSource Page -> FieldsSelection Page -> SortOrder Page ->
            ColWidth Page -> SelectBindingColumn Page -> EnterColumnName Page -> END Page
    (type#2)->EnteringDataByHand Page -> SelectBindingColumn Page ->
          EnterColumnName Page -> END Page
</pre>
Notes:
* SelectBindingColumn and EnterColumnName pages are identical for either 1st and 2nd type.
[[File:Lookup Column Assistant2.jpg.jpg]]
=== TableOrQueryDataSource Page (type #1) ===
* For tables/queries list, general-purpose Kexi widget should be used (not yet implemented). Only one item can be selected here.
* Unlike presented on the screenshot, do not add "tables/queries/Both" radio buttons, but tables and queries should be displayed on the list (2 columns), eg:
<pre>
Type    Name
----    ----
Table  [icon]Table1
Table  [icon]Table2
Query  [icon]Query1
</pre>

Revision as of 18:36, 5 April 2023

Objectives

The Lookup Column Assistant allows you to add a database relation for a single column. Once such relation is defined (one-to-many), it allows user to select one of many values for a given field using some sort of combo box. The task is to deliver intelligent GUI for this wizard. This task doesn't include a code for creation the column itself.

Note

Original wiki page: [1]


Pages

Page: WELCOME. Select lookup type

There are two types of definition for the "many" side of this relation:

  • type#1: Picking an existing table or query, so their rows will be displayed for selection
  • type#2: Simple version: Entering rows by hand, what creates a simple dictionary.

The 1st type is more generic, and allows to reuse once defined data schemas. 

Sequence Diagram
 WELCOME:SelectLookupType ->
    (type#1)-> TableOrQueryDataSource Page -> FieldsSelection Page -> SortOrder Page ->
            ColWidth Page -> SelectBindingColumn Page -> EnterColumnName Page -> END Page
    (type#2)->EnteringDataByHand Page -> SelectBindingColumn Page ->
           EnterColumnName Page -> END Page

Notes:

  • SelectBindingColumn and EnterColumnName pages are identical for either 1st and 2nd type.

TableOrQueryDataSource Page (type #1)

  • For tables/queries list, general-purpose Kexi widget should be used (not yet implemented). Only one item can be selected here.
  • Unlike presented on the screenshot, do not add "tables/queries/Both" radio buttons, but tables and queries should be displayed on the list (2 columns), eg:
 Type    Name
 ----    ----
 Table   [icon]Table1
 Table   [icon]Table2
 Query   [icon]Query1
Retrieved from "https://community.kde.org/index.php?title=Kexi/Assistants/Lookup_Column_Assistant&oldid=96114"