joomla/joomla-cms — pull request #3476 by fastslack (2014-04-19 04:32:29+00:00)
Title: Update JFormFieldSQL to use JDatabaseQuery

### Use JDatabaseQuery
This PR update the JFormFieldSQL input field to use JDatabaseQuery with separated query elements.
Into your form xml file you can set the query using this way:
```

```
This example will recreate this query:
```
SELECT e.* FROM #__example AS e GROUP BY name ORDER e.id ASC
```
### Filters
One posibility that offer use JDatabaseQuery instead the old way is to have a way to get "inline" filters. That mean that if you have multiple dropdowns as filter in your list view, its posible that you need to connect it togheter.

For example, we have 2 dropdowns that filter our list, one called "groups", another called "subgroups":

```

```
And the second:
```

```
Note that we added **sql_filter="groups"**, that search for groups changes and set the condition if its founded. So we can have a 'inline' filter on our lists.