Channel Query
Developer
3rd Party (Free)
366 downloads (last 90 days)
EE Version Support
- ExpressionEngine 2
Compatibility
If an item is crossed out, it might be untested, not applicable or incompatible. Contact the developer to be sure.
- Updater
- Multi Site Manager
- Stand Alone Entry Form
- Low Variables
- Content Elements
- Better Workflow
- Matrix
- Grid
- Webservice
- Publisher
Requirements
- jQuery for the Control Panel
Add-On Type(s)
Plugin
Tags
This plugin lets you display channel entries using a custom SQL query. It brings you the benefits of combining the {exp:query} tag with the {exp:channel:entries} tag, without having to worry about GROUP_CONCAT or parse order.
Usage
{exp:channel_query sql="SELECT entry_id FROM exp_channel_titles"}
The sql parameter specifies the custom SQL query. Only SELECT statements can be used,
INSERT, UPDATE and DELETE are not supported for security reasons.
All other parameters and variables are exactly the same as the standard EE
Channel Entries Tag.
If an orderby parameter is specified, that will take precendence. Otherwise, entries will be
displayed in the order returned by your SQL query.
Download Channel Query
EE Support | Downloads | Add-On Version | Release Date |
---|---|---|---|
Not Specified | Download | 1.0 | Apr 11, 2013 |
Channel Query Links
This entry was created April 11, 2013, 9:34 am.
This entry was last updated April 11, 2013, 9:40 am.
Disclaimer: Information about ExpressionEngine add-ons is provided as a service to you, the user, and every member of the ExpressionEngine community. devot:ee is not responsible if you hose, mangle, wreck, or otherwise destroy your EE website by installing an add-on that you found out about at this site, regardless of its rating, Favorites status, commercial or free status, or general popularity. Caveat EEmptor!
Returns: devot:ee has a 30-day return policy on all commercial add-ons sold through devot-ee.com. If you need to return an add-on, do not go to the developer or the developer's site, but rather visit our returns page at https://devot-ee.com/returns to initiate your return. If you have questions, email support@devot-ee.com.
1 Review:
Alex Kendrick 01.30.14
Very useful for those times when you can’t get quite the right result set from channel:entries, but the query module would be too basic. You can get exactly the results you want, and in the just the right order—with all the benefits of the channel:entries tag.