https://bugs.documentfoundation.org/show_bug.cgi?id=97338
Bug ID: 97338
Summary: Date Criterion in Query fails in GUI criterion when
using DATEADD function fails, but runs in SQLView.
Query can then only be edited and run in Sqlview
Product: LibreOffice
Version: 5.0.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Using >= DATEADD( 'dd', - 180, CURRENT_DATE ) in GUI gives a Syntax error when
trying to add directly into GUI. Workaround is to add it in SQLVIEW AND TO SAVE
IN SQLVIEW. Do not try run Query or SAVE in GUI as you will need to start all
over, by deleting criterion , switching to SQLVIEW and re-editing. Query will
run normally if saved and closed in SQLVIEW.
GUI rules of syntax table a little fussy it seems.
Sample SQL Below.
SELECT
"ItemMaster"."ItemNo",
"ItemSOHMonthly"."MonthEnd",
"ItemSalesMonthly"."SalesQty",
"ItemSOHMonthly"."SOHQty"
FROM
"ItemSOHMonthly" "ItemSOHMonthly",
"ItemMaster" "ItemMaster",
"ItemSalesMonthly" "ItemSalesMonthly"
WHERE
"ItemSOHMonthly"."ItemNo" = "ItemMaster"."ItemNo"
AND
"ItemSalesMonthly"."ItemNo" = "ItemMaster"."ItemNo"
AND
"ItemSalesMonthly"."MonthEnd" = "ItemSOHMonthly"."MonthEnd"
AND
"ItemMaster"."ItemNo" = :ItemNo
AND
"ItemSOHMonthly"."MonthEnd" >= DATEADD( 'dd', - 180, CURRENT_DATE )
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
