https://bugs.documentfoundation.org/show_bug.cgi?id=134049
Bug ID: 134049
Summary: EDITING In the base query designer I would like to be
able to request it to parse down the criterion of a
column
Product: LibreOffice
Version: 6.0.7.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
I would like to be able to generate a query like the following :-
SELECT * FROM "Table1"
WHERE ( "FieldA" = :AskA OR "FieldA" IS NULL) AND
("FieldB" = :AskB OR "FieldB" IS NULL )
This could be by the use of brackets (as in the SQL)or some marker in the
column
Steps to Reproduce:
1.Click on Query
2.Click on Query in Design View
3.Enter as per attached screen shot
4.Click on switch design view on/off
Actual Results:
It's an enhancement request.
Expected Results:
SELECT * FROM "Table1"
WHERE ( "FieldA" = :AskA OR "FieldA" IS NULL) AND
("FieldB" = :AskB OR "FieldB" IS NULL )
Reproducible: Always
User Profile Reset: No
Additional Info:
After encountering the end bracket continue parsing at the row of the open
bracket and the column to the right of it.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
