https://bugs.documentfoundation.org/show_bug.cgi?id=148096
Bug ID: 148096
Summary: EDITING: Aliases ignored in form with SQL command as
data source in embedded Firebird
Product: LibreOffice
Version: 7.2.5.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
When using functions with aliases in an SQL command to set the data source for
a new (sub)form, the alias won’t show in the list of applicable attributes when
assigning data to a field / column. Instead the used function is shown.
Steps to Reproduce:
1. Create new form in Design View
2. Create new form in Form Navigator
3. At Data > Content Type in Form Properties choose SQL command
4. Use any function with an alias in the select statement
5. Create a Table Control or other field
6. Insert new column and assign data from list
Actual Results:
The list won’t show the alias but instead the used function, p.e. ADD /
CONCATENATION / CONCATENATION1 / SUM / etc.
Expected Results:
Show the aliases in the list
Additional Info:
There is a work around. First create a query with the same SQL command. Then
use this query as the data source instead of the SQL command
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Version: 7.2.5.2 (x64) / LibreOffice Community
Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: en-IE (en_IE); UI: en-GB
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
