Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | it translation: cannot use aggregate functions from wizard | ||
---|---|---|---|
Product: | Base | Reporter: | dtinazzi <dtinazzi> |
Component: | code | Assignee: | AOO issues mailing list <issues> |
Status: | UNCONFIRMED --- | QA Contact: | |
Severity: | Trivial | ||
Priority: | P3 | CC: | issues |
Version: | OOO 2.0 Beta2 | ||
Target Milestone: | --- | ||
Hardware: | All | ||
OS: | All | ||
Issue Type: | FEATURE | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
dtinazzi
2005-10-19 18:42:24 UTC
Hi, This is because aggregate functions are not possible with text fields, so if you only have text fields there are no aggregate functions possible. I close t his issue as INVALID. Bye Marc close Hi Marc, I use some db servers and I can, in certain circumstances, use aggregate functions with text fields; for example, if I have a table like this: ----------------- Field1 | Field2 | ----------------- John | aaa | John | bbb | Jim | ccc | Jim | ddd | ----------------- And I run the query: SELECT FIELD1, COUNT(FIELD2) AS NUM FROM TABLE1 GROUP BY FIELD1 I obtain: ----------------- Field1 | NUM | ----------------- John | 2 | Jim | 2 | ----------------- Another: SELECT FIELD1, MIN(FIELD2) AS MINDESC FROM TABLE1 GROUP BY FIELD1 The result is: ------------------ Field1 | MINDESC | ------------------ John | aaa | Jim | ccc | ------------------ The results you see don't change if I attach those databases to OpenOffice Base; I can write directly the queries you see, and when I run I obtain the results above. So, I think it would be useful to have the possibility to build that queries via wizard... What do you think about that? OOOps, I forgot the name! Hi Marc, I'm Dario. i can acknowledge that (should go with databases, that support this function with text fields) -> send further to: requirements |