JP CS Data Query - Example - Articles with Categories and Authors
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 12 of 18
Example: Joomla Articles with Categories and Authors
A common use case is retrieving Joomla articles together with their category titles and author names.
Configuration
- Main Table:
content - Enable Left Join 1: Yes
- Join Table 1:
categories - Main Table Column:
catid - Table 1 - Right Column:
id - Enable Left Join 2: Yes
- Join Table 2:
users - Join 2 Source Table: Main Table
- Source Table Column:
created_by - Table 2 - Right Column:
id - Order By:
created - Order Direction: DESC
- Quantity: 10
Field Mapping
Example YOOtheme Pro field mappings:
- Title:
content_titleortitle - Meta / Category:
categories_title - Meta / Author:
users_name - Content:
content_introtext
The result provides article records together with their related category titles and author names, ready to display in a YOOtheme Pro layout.
