JP CS Data Query - Key Features
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 2 of 18
Key Features
- Query Joomla core, third-party extension, and custom database tables.
- Use database records directly as YOOtheme Pro Dynamic Content.
- Automatic database table and column discovery.
- Searchable table and column selectors inside the YOOtheme Pro Customizer.
- Supports up to two chained LEFT OUTER JOINs.
- Join the second table from either the Main Table or the first joined table.
- Dynamic field filtering based on the selected database tables.
- Automatic field aliases for joined database tables.
- Built-in compatibility fields and intelligent field fallbacks.
- Sort database results in ascending or descending order.
- Configure record Quantity / Limit and Start / Offset.
- Integration with JP CS Global Pagination.
- Joomla Update Sites and JPro Studio Download ID support.
- No manual SQL or PHP required for normal configuration.
