[Libreoffice-bugs] [Bug 113884] New: Report editor Add Fields bug when Report is based on select all query from an Alias field

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 113884
           Summary: Report editor Add Fields bug when Report is based on
                    select all query from an Alias field
           Product: LibreOffice
           Version: 5.3.3.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: BridgeportContractor at gmail.com

Created attachment 137814
  --> https://bugs.documentfoundation.org/attachment.cgi?id=137814&action=edit
Add Fields not working when Report based on a select all query from an Alias

Report editor does not always correctly find list of field names when Data
Content is a query using "*" (select all fields) and based on an underlying
query which declares a field name alias.

1) Open the attached demonstration data base,

2) Open Report then Edit 'A report',

3) Open Add Field,

Bug: Notice that the available fields are: ID and Txt.

Expected them to be: ID and Txt-Alias.

(The Data Content of 'A report' is Query_Query_Table1.  Query_Query_Table1 is
just a "*" select of Query_Table1.)

If you edit this report and change the Data Content to Query_Table1, then Add
Field correctly shows the available fields as: ID and Txt-Alias.

Workaround: If you Copy Query_Query_Table1 to Query_Query_Table2, then Edit the
report, and change the Data Content to Query_Query_Table2, then Add Field
correctly shows the list of fields as ID and Txt-Alias.

-- 
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/20171116/3d2f4965/attachment-0001.html>