Bug 408852 - SQL query - filter that use values from secondary tables
Summary: SQL query - filter that use values from secondary tables
Status: REPORTED
Alias: None
Product: KEXI
Classification: Applications
Component: Queries (show other bugs)
Version: unspecified
Platform: Other Linux
: NOR normal
Target Milestone: ---
Assignee: Kexi Bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-06-17 21:01 UTC by Albrecht Will
Modified: 2019-06-21 19:48 UTC (History)
3 users (show)

See Also:
Latest Commit:
Version Fixed In:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description Albrecht Will 2019-06-17 21:01:22 UTC 
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.