https://bugs.documentfoundation.org/show_bug.cgi?id=103557
Bug ID: 103557
Summary: Add syntax to reference form input boxes from queries
(pass values)
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
There's currently no way I know of of directly passing the value one can input
in, for instance, a calendar date picker in a form, to a query.
Suppose I have a series of events, each one having a Date field.
Now I want to query for all events happened between 2016-01-01 and 2016-12-31.
I can write a query with :parameters so, when I run it, a dialog window appears
to ask me to write the values I want to use as parameters.
But I want the user to supply the start date and end date in a calendar picker,
like the one you can have in Forms, where you select Dropdown Yes and get a
calendar-like interface.
So I don't want to use :parameters anymore, because doing so would bring up the
window asking to enter dates in a text field.
What I want to do is to write a query where I say to select all the events
where the Date is between the two values I specify in the form calendar field.
But currently I see no way of directly referencing the value of a form input
box in a SQL query (the fact that you can't do it in the GUI is probably
another separate enhancement request).
>From what I've read, MS Access should have a similar feature which syntax is
[Forms]![Form1].[field]
I'm proposing to add this, or a similar syntax, in Base.
There should be another solution, from what I've read, involving a filter table
and so, but I find this method to be simpler from a user perspective.
This way, ideally, I select all the events happened between
[Forms]![Form1].[startdate] and [Forms]![Form1].[enddate] in my query, then
create a form based on this query, and finally simply add 2 calendar dropdowns
called startdate and enddate. When I open the form, I fill in the dates and
somehow update the underlying query.
--
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
