Promote - Help us
Joomla Extensions
Extjs 5 Extensions
Extjs 3 Extensions
Sencha Touch 2 Extensions
Sencha Touch 1.* Extensions
Cordova/Phonegap Plugins
jQuery Plugins
Download/Buy Extensions
You have to login to Download/Buy extensions.

Ext-3 Grid Query Builder Example

This example shows how to use Query Builder.

You can also save queries as public and private for future use

You can add filter fields, where Conditions, additional fields from database table

Here is the fresh query used to load the grid at time of rendring

SELECT c.* DATE_FORMAT(created, '%b %e, %Y') as created_date, DATE_FORMAT(modified, '%b %e, %Y') as modified FROM com_extensiondemo_content c

Additional fields can be added dynamically to the grid (See example "News Section categories which are published", below is the resultant query )

SELECT c.* , cat.title as cattitle , DATE_FORMAT(created, '%b %e, %Y') as created_date, DATE_FORMAT(modified, '%b %e, %Y') as modified FROM com_extensiondemo_content c,com_extensiondemo_categories cat WHERE 1=1 AND ( c.id=cat.id and cat.section = 1 and cat.published = '1' )