[KEXI] [Bug 408852] New: SQL query - filter that use values from secondary tables

[Albrecht Will]

https://bugs.kde.org/show_bug.cgi?id=408852

            Bug ID: 408852
           Summary: SQL query - filter that use values from secondary
                    tables
           Product: KEXI
           Version: unspecified
          Platform: Other
                OS: Linux
            Status: REPORTED
          Severity: critical
          Priority: NOR
         Component: Queries
          Assignee: kexi-bugs at kde.org
          Reporter: albrecht.will at online.de
                CC: adam at piggz.co.uk, inksi at fables.co.za
  Target Milestone: ---

SUMMARY
In a database I use secondary tables. One column of the main-table is named
"land", using a secondary table "z_bundesland". See attachment
Screenshot_table-design.png.

If I use a form, the graph works well and shows the value "land". Here see
attachments Hueselitz.png and sentences_with_Column_given_by_form.png.

If I use the filter with a value from "z_land" as part of the secondary table
"land", (SQL-land.png) then then the result is shown in attachment
result_of_SQL.png. The column "land" is empty.

Searching for a reason, I found an early csv that I used as an ex- or import in
or out of kexi. Could this be an invisible rudiment? Attachment
Sentences_in_csv_2016.png. Currently these sentences have the invisible value
"Sachsen-Anhalt".
Confused!

OBSERVED RESULT


EXPECTED RESULT


SOFTWARE/OS VERSIONS

Linux/KDE Plasma: 
(available in About System)
KDE Plasma Version: 5.15.5
KDE Frameworks Version: 5.59.0
Qt Version: 5.12.3

ADDITIONAL INFORMATION

Attachments are privatly sent to Jaroslaw Staniek.

-- 
You are receiving this mail because:
You are the assignee for the bug.