JP CS Data Query - Summary
Article Index
- JP CS Data Query
- Key Features
- Installation
- Configuration and Usage
- Main Table
- Left Join 1
- Left Join 2
- Ordering and Quantity
- Dynamic Field Mapping
- Join Field Aliases
- Compatibility Fields
- Example - Articles with Categories and Authors
- Example - E-Commerce Products
- JP CS Global Pagination Integration
- Download Key and Updates
- Troubleshooting
- Best Practices
- Summary
- All Pages
Page 18 of 18
Summary
JP CS DataQuery provides a flexible way to use Joomla database records as YOOtheme Pro Dynamic Content without manually writing SQL or PHP.
It can query Joomla core tables, third-party extension tables, and custom database tables while providing automatic schema discovery, searchable table and column selection, sorting, limits, offsets, dynamic field mapping, and up to two chained LEFT OUTER JOINs.
With intelligent compatibility fields and integration with JP CS Global Pagination, JP CS DataQuery can be used to build article listings, directories, product catalogs, custom component layouts, database-driven pages, and other advanced YOOtheme Pro websites using data already stored in Joomla.
