Because `WITH ROLLUP` is a `GROUP BY` modifier, it cannot be solved with a custom function. You'll have to use native SQL for this.
-- Jasper N. Brouwer (@jaspernbrouwer) On 12 Feb 2014, at 14:31, Nima Sadjadi <[email protected]> wrote: > Thanks for advice. Now understood everything the example to make a custom DQL > function on wiki is for floor command. I did not understand how i can write > the custom function for " with rollup". As sample can you kindly do a favor > and write this rollup function then i'd get idea how to write other functions > on my own? I appreciate it. Thanks. > > در 2014 2 12 14:07، "Jasper N. Brouwer" <[email protected]> نوشت: >> Doctrine Query Language (DQL) is an "object query language", which means you >> are not querying tables and columns, but php objects (Entities) and >> properties. Think about it as a query language for your object model, not >> for your relational schema. >> >> NativeQuery is a tool to perform raw SQL queries. It's _not_ limited to >> MySQL, it works with any vendor that Doctrine support. >> >> But the actual SQL queries _you_ write can be limited to the vendor you >> wrote the queries for. Not all vendors support the exact same SQL syntax. So >> if you write SQL queries for MySQL, and switch to sqlite later on, you might >> encounter problems. >> >> Usually you only use NativeQuery when the query you want to perform cannot >> be written in DQL. A common example is if you need to use vendor-specific >> statements. >> >> My advise on when to use what: Try DQL first. If your missing support for >> something, try to write a custom function [1]. If that fails, use >> NativeQuery. >> >> >> [1]: >> http://docs.doctrine-project.org/en/latest/reference/dql-doctrine-query-language.html#adding-your-own-functions-to-the-dql-language -- You received this message because you are subscribed to the Google Groups "doctrine-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/doctrine-user. For more options, visit https://groups.google.com/groups/opt_out.
