https://bugs.freedesktop.org/show_bug.cgi?id=58031
Priority: medium
Bug ID: 58031
Assignee: [email protected]
Summary: EDITING: grid control : filtering SQL drop-down lists
doesn't work
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 3.5.7.2 release
Component: Database
Product: LibreOffice
Created attachment 71216
--> https://bugs.freedesktop.org/attachment.cgi?id=71216&action=edit
buggy drop-down list in grid control
In the form, the grid controls allow to use various control, such as checkbox
or drop-down list. These drop-down lists can show the content of a table, or
the result of a SQL request. The grid controls also allow to filter the data
according to the values of some columns.
These filters work well with drop-down lists when they show the content of a
table, but not when it's the result of a SQL request :
- With AutoFilter, it shows only the line of the selected cell,
- With formulary filter, it shows only the first line passing the filter.
See the attachment to reproduce this behaviour :
- Open the form "Buggy drop-down list"
- The "Good drop down list" column works with a table. Filtering with "Angie",
"Bob" or "Charles" gives the expected result.
- The "Buggy drop-down list" works with a SQL request. Filtering with
"Chocolate", "Apple pie" or "Berries" gives one result instead of two.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
