JP CS Data Query - Join Field Aliases
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 10 of 18
Join Field Aliases
JP CS DataQuery automatically creates convenient normalized aliases for fields returned by joined tables.
Join 1 Aliases
join1_idjoin1_titlejoin1_aliasjoin1_descriptionjoin1_value
Join 2 Aliases
join2_idjoin2_titlejoin2_aliasjoin2_descriptionjoin2_value
These normalized fields can make it easier to build reusable YOOtheme Pro layouts when database table names differ between projects.