#6081: Add new field in model->find to handle "having" --------------------------+------------------------------------------------- Reporter: ebadedude | Type: Enhancement Status: new | Priority: Medium Milestone: 1.2.x.x | Component: General Version: 1.2 Final | Severity: Normal Keywords: | Php_version: n/a Cake_version: | --------------------------+------------------------------------------------- I was going through the docs trying to find how to handle my SQL query. The query is as follows:[[BR]]
{{{ SELECT DISTINCT POH.Job, POH.PO, POH.Date, POH.Author, POH.Vendor, POH.Paid FROM PO_PO_HEADER POH WHERE POH.Approved=1 GROUP BY POH.Job, POH.PO, POH.Date, POH.Author, POH.Vendor, POH.Paid HAVING POH.PO < 100000 ORDER BY POH.Job, POH.PO }}} There is not a "having" field in the find syntax. -- Ticket URL: <https://trac.cakephp.org/ticket/6081> CakePHP : The Rapid Development Framework for PHP <https://trac.cakephp.org/> Cake is a rapid development framework for PHP which uses commonly known design patterns like ActiveRecord, Association Data Mapping, Front Controller and MVC. Our primary goal is to provide a structured framework that enables PHP users at all levels to rapidly develop robust web applications, without any loss to flexibility. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "tickets cakephp" group. To post to this group, send email to tickets-cakephp@googlegroups.com To unsubscribe from this group, send email to tickets-cakephp+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/tickets-cakephp?hl=en -~----------~----~----~----~------~----~------~--~---