[Libreoffice-bugs] [Bug 82372] Base: Query builder deletes columns not visible that do not have constraint (unexpected loss of data)

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=82372

Alex Thurgood <iplaw67 at tuta.io> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|enhancement                 |normal

--- Comment #8 from Alex Thurgood <iplaw67 at tuta.io> ---
Bug still present in 

Version: 7.0.3.1
Build ID: d7547858d014d4cf69878db179d326fc3483e082
CPU threads: 8; OS: Mac OS X 10.15.7; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: threaded

Came across this yesterday when teaching my assistant to build a query using
the UI designer and adding a field for filtering purposes that didn't need to
appear in the query results (for mailmerge purposes).

Here is a practical busines example of the issue.
We need to merge data from our in-house database into a Writer document using
the TextToTable function from a filtered query resultset.

You can't currently filter a query using a field that isn't present in the
query definition. 

The logical apparent solution to this, when using the Query Designer UI, is
therefore to include a field that will be used for filtering the data set of
the returned query, and that field will be marked "invisible" in the UI. The
Query Designer lets you do this and seemingly save the query, but that setting
isn't actually saved in the ODB file.

Of course, one can simply add the field to be used as a filter into the Query
Designer UI and make it visible, save the query design, and the resultset
produced when executing the query will also include the filter field. However,
when using such a query for mailmerge, you can't then exclude that column from
the resultset and its content gets copied over, for example, when using the
DataToText function of the mailmerge taskbar. 


I don't consider this an enhancement, rather this is a bug. 
The query designer UI offers a feature, the invisible flag, which isn't
respected on saving the query design. If the feature doesn't work as designed
despite seemingly allowing the user to make use of that feature, it is a bug
that should be fixed.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201110/40f5aa77/attachment.htm>