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

Hi,

Should we make it as a paid service, if you are not agree please help us to raise funds for our survival.

We are raising funds for joomla component creator, will really appreciate you if you can share this campaign in your circle.

JCC campaign

It will help our team to build the funds for Joomla component creator which is free service for Joomla developers to create a nice backend featured component in just few minutes.

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

Or