Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Datapilot with datasource query and named or unnamed parameters malfunctions | ||
---|---|---|---|
Product: | Calc | Reporter: | ftoth <ftoth> |
Component: | viewing | Assignee: | spreadsheet <spreadsheet> |
Status: | CLOSED FIXED | QA Contact: | issues@sc <issues> |
Severity: | Trivial | ||
Priority: | P3 | CC: | frank.schoenheit, issues, mechtilde, pagalmes.lists, weigel |
Version: | OOo 2.2.1 | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | Windows XP | ||
URL: | http://www.oooforum.org/forum/viewtopic.phtml?p=2549 | ||
Issue Type: | DEFECT | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
ftoth
2007-07-04 21:56:24 UTC
@ 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 |