JP CS Data Query - Example - E-Commerce Products
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 13 of 18
Example: Custom Extension or E-Commerce Products
JP CS DataQuery can also retrieve records from third-party Joomla extensions and custom database tables.
For example, product information can be joined with a separate product description table.
Configuration
- Main Table:
eshop_products - Enable Left Join 1: Yes
- Join Table 1:
eshop_product_descriptions - Main Table Column:
id - Table 1 - Right Column:
product_id - Order By:
ordering - Order Direction: ASC
- Quantity: 20
The resulting records can contain product information together with localized title and description fields and can then be mapped directly to YOOtheme Pro elements.
