ColdBox/coldbox-platform — pull request #111 by existdissolve (2012-10-26 03:18:27+00:00)
Title: Development

Luis, I merged in the most recent from development and resolved the conflict. This should hopefully be a clean pull request. Please let me know if there's anything else you need from me.

Thanks!

-------------------------------

Previous message:
RE: https://groups.google.com/d/msg/coldbox/Do_PfxCkzhU/J55UfmXn-VMJ

A while back, I posted a suggestion in a thread seeking feature requests for CB 4. I suggested support for DetachedCriteria/Subqueries/etc., and I finally got around to putting together some ideas about this.

In general, the changes I've added allow more or less two things:

Create a true subquery criteria via DetachedCriteria
Create a sqlProjection CriteriaBuilder-style via DetachedCriteria
I've also added in sqlProjection and sqlGroupProjection to withProjections(), and tests should be in the pull request as well.

If you're interested, I put together a mini-website that explains my motivation for pursuing this, as well as live examples of the additions in action: http://cfgloss.com/subqueries. The code for the site is here: https://github.com/existdissolve/ColdBox-CriteriaBuilder-Subqueries-Examples