Apache OpenOffice (AOO) Bugzilla – Issue 56293
it translation: cannot use aggregate functions from wizard
Last modified: 2013-02-07 22:34:18 UTC
OOO 2.0 rc3 Italian translation - base file connected to MsAccess table (TABLE1). I use the query wizard to create a query like: SELECT FIELD1, MIN(FIELD2) FROM TABLE1 GROUP BY FIELD1 FIELD1 and FIELD2 are text fields. I select the table and FIELD1 and FIELD2 (Step 1), and only Steps from 1 to 3 appairs selectable; to have the possibility to select step 4 I have to add to FIELD1 and FIELD2 a third field which has to be a numeric field. If I select only text fields in step 1 (two fields or more), I can't goto step 4 to select aggregate functions.
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