Summary: | Add syntax to reference form input boxes from queries (pass values) | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | edonkey2001-libreoffice |
Component: | Base | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | enhancement | CC: | lionel, robert |
Priority: | low | ||
Version: | unspecified | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 108440, 108443 |
Description
edonkey2001-libreoffice
2016-10-28 13:34:55 UTC
At this moment you could 1. Create a table "filter" only for one row with ID - BOOLEAN, primarykey date_start - DATE date_end - DATE 2. Put in the first value for ID: TRUE 3. Create a form for this table with date_start date_end (there you could choose the dropdown you wish) 4. Set this form by the filter to show only the values for ID = TRUE 5. Set the cycle of the form "only this row" (don't know how it is called in English GUI) 6. Add the query to a form beneath this one - mustn't be a subform. 7. Add a button to this form, which should refresh the query. That's the way to get what you want. You might get the same result with macros - but this one works without and you could also get the content of the last input when only opening the query, because the values of your table would be read out of "filter" ( ... WHERE "start_date" = IFNULL(SELECT "date_start" FROM "filter" WHERE "ID" = TRUE), "start_date") AND "end_date" = ...) @edonkey2001 : forms and queries are separate objects in the MVC paradigm of LibreOffice - queries via the GUI have only a limited number of interactions and a date control is not one of them, however that is not what you are requesting here if I've undersood correctly. What you want if I've understood correctly is for the values of date controls in a form, to be passed to a query, although you don't specify where that query might be - currently that is only possible by the workaround suggested by Robert, or else via macro using the UNO API. I shall confirm your RFE but I have no idea whether in the current scheme of things what you are asking for is remotely possible or even desirable. For that, a developer would be required to give their input. |