| Summary: | Add support for grouping and aggregation functions like sum(), count() in queries | ||
|---|---|---|---|
| Product: | [Applications] KEXI | Reporter: | keyro90 |
| Component: | Queries | Assignee: | Kexi Bugs <kexi-bugs> |
| Status: | CONFIRMED --- | ||
| Severity: | wishlist | CC: | adam, ptijoz, staniek |
| Priority: | NOR | Keywords: | bounty |
| Version: | 3.1.0 | ||
| Target Milestone: | --- | ||
| Platform: | unspecified | ||
| OS: | All | ||
| URL: | https://invent.kde.org/office/kexi/-/issues/90 | ||
| Latest Commit: | Version Fixed In: | ||
| Sentry Crash Report: | |||
Kexi parses the SQL itself and so don't pass the SQL commands directly, but rebuild them (needed for scripts portability and for bindings with the GUI). Currently the Kexi parser does not support groupping and aggregation. This is planned for 2.x. I am sorry for the delay. By the way I have marked the report as a wish for 2.x. It won't be implemented (by the core team) for 1.x series. Added "grouping" to the title since it is inseparable from aggregation. Founding possible at https://github.com/staniek/kexi/issues/3 (click Post a bounty on it) Out of interest, there are several supported aggregate functions in KReport/Kexi Reports. Yes, that's good note. Ultimate though is that, when aggregations feature come to KEXI queries (and forms), they can be harmonized the Reports' aggregations. |
Version: (using KDE 3.5.10) OS: Linux Installed from: Debian stable Packages Hi! I use Kexi to interact with MySQL server and its databases. I love it, however in Kexi it's impossible creating queries with operators SUM() COUNT() etc. like : SELECT SUM(hour) FROM table; Because the program warns me with a message : "Syntax error before ")"" and the same query in mysql-server functions perfectly. How can solve this problem? Thanks. Andrea G.