Some of you already know that if you want to get something from database via Symfony you should build a query with help of Criteria() object.

Here is the link to the Symfony book and you can get familiar with this there.
Symfony Criteria()

BUT there are only simple queries samples.

What if you need something like this:

SELECT
Table1.field1, Table1.field2, Table2.field1
FROM
Table1, Table2
WHERE
((Table1.field3=1 OR Table1.field4=1) AND
Table1.field5 < 400000) AND
Table2.field1=Table1.field1

or smth. like that.

I’ve found useful tool that help you to build such queries :)

Symfony Criteria code builder tool

Add to Del.cio.us RSS Feed Add to Technorati Favorites Stumble It! Digg It!
    www.sajithmr.com