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

--- Comment #2 from Robert Großkopf <[email protected]> ---
Created attachment 208583
  --> https://bugs.documentfoundation.org/attachment.cgi?id=208583&action=edit
Internal HSQLDB - only one table with Date and Time

Click on the Date filed in the table. Set AutoFilter. Will works.

Closed the database and found this in Content.xml:

<db:table-representation db:name="tbl_DateTime" db:apply-filter="true">
<db:columns>
<db:column db:name="ID" db:style-name="co1" db:default-cell-style-name="ce1"/>
<db:column db:name="DateValue" db:style-name="co2"
db:default-cell-style-name="ce1"/>
<db:column db:name="TimeValue" db:style-name="co3"
db:default-cell-style-name="ce1"/>
</db:columns>
<db:filter-statement db:command=""tbl_DateTime"."DateValue" = {d '2026-02-07'
}"/>
</db:table-representation>

Tested the same with TimeValue, but there isn't shown any filter-statement.
Changed the filter-statement to a time filter statement. Could see this
statement when opening the database file, open the table and look at filter
properties - but isn't executed at all.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to