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' )

You have to login to Download/Buy extensions.
Create an account

Or