[Libreoffice-bugs] [Bug 118233] ReportBuilder does not know aliases for Firebird views

[bugzilla-daemon at bugs.documentfoundation.org]

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

Drew Jensen <drewjensen.inbox at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |drewjensen.inbox at gmail.com

--- Comment #4 from Drew Jensen <drewjensen.inbox at gmail.com> ---
Created attachment 142941
  --> https://bugs.documentfoundation.org/attachment.cgi?id=142941&action=edit
screen shot showing issue

Got it:
Two QueryDefinitions; MitgliederVerbandExcelvorlage and Abfrage1. 

MitgliederVerbandExcelvorlage uses table MitgliederVerband

Abfrage1 uses MitgliederVerbandExcelvorlage and creates one alias, VereinID

Report is based on Abfrage1 and in the set filter dialog references
Abfrage1.VereinID

But the filter SQL snippet references "MitgliederVerbandExcelvorlage"."Verien"
instead of ( "Abfrage1"."VereinID" = '0' ) 

As far as I can tell it doesn't change the result set (didn't after I added
some records and ran the report with both variations), but it seems it should
the later and the not the former. 

Put it all in pictures(why not? ;) see attachment

-- 
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/20180619/7f58cace/attachment-0001.html>