Apache OpenOffice (AOO) Bugzilla – Issue 79240
Datapilot with datasource query and named or unnamed parameters malfunctions
Last modified: 2009-11-24 13:25:43 UTC
When the datapilot is setup to connect to a datasource of type query that contains a named parameter (WHERE column = :criterium) of unnamed (WHERE column = ?) it fails with a message like unknown parameter or so. The expected behavior is to pop up the parameter dialog box. This occurs with the databases mentioned in the url above, as well as postgresql using the JDBC driver (my project). Ferry
@ sweigel add to CC Can you have a look at it?
fs, pse have a look! Seems to me, that this is not related to Datapilot and not related to Calc. So: Wrong component? Rather: Component = Database access? OOo seems not to be able to get data from a query with a paramater in the database backend. So: Wrong issue type? Rather: Issue type = Feature?
Hmm, is this issue still valid? It was reported for 2.2.1, and trying the data pilot in OOo 3.1, which a query containing an anonymous parameter, pops up the usual parameter dialog asking for user input. (The dialog opens two times, which is once to often of course.) Don't know too little about how the data pilot is expected to work to judge whether the result is correct, though.
Base uses named parameters and they do work with data pilots. SELECT * FROM "Table" WHERE "Field"=:param
Yes I can confirm this issue has been fixed. I do not know in which version. Thanks all, for fixing the unconfirmed(!) issue . Ferry
so I set to fixed
-> closed