Bug 164328 - Standard Filter is not working in Queries with Alias Fields
Summary: Standard Filter is not working in Queries with Alias Fields
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
24.2.7.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Queries
  Show dependency tree / graph
 
Reported: 2024-12-15 08:02 UTC by Pit Zaclade
Modified: 2024-12-20 05:59 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
database includes the query1 with do working standard filter for field NAME (4.17 KB, application/vnd.sun.xml.base)
2024-12-15 08:05 UTC, Pit Zaclade 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Pit Zaclade 2024-12-15 08:02:26 UTC 
Description:
In database you produce an "query1" with SQL e.g.
SELECT … "name" AS "NAME" … from "table1" .
Than you can not Standard Filter with Field name NAME = ...


Actual Results:
Standard Filter is no working

Expected Results:
Standard Filter selects the data


Reproducible: Always


User Profile Reset: No

Additional Info:
Standard Filter selects the data
Comment 1 Pit Zaclade 2024-12-15 08:05:49 UTC 
Created attachment 198112 [details]
database includes the query1 with do working standard filter for field NAME
Comment 2 Robert Großkopf 2024-12-15 20:16:51 UTC 
Tested with attached database. Could confirm the Standard Filter won't work with field with alias.
Autofilter will work well with alias.

Version: 24.8.4.1 (X86_64) / LibreOffice Community
Build ID: 1be9007f5d86a3741c366527d13e2970cbeef057
CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded