JP CS Data Query - Main Table
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 5 of 18
Main Table
The Main Table setting determines the primary Joomla database table queried by JP CS DataQuery.
The searchable selector automatically displays available database tables using clean table names. Joomla database prefixes are handled automatically, so you do not need to enter the #__ prefix manually.
Examples of possible Main Tables include:
content– Joomla articlescategories– Joomla categoriesusers– Joomla users- Third-party component tables
- E-commerce product tables
- Custom Joomla component tables
- Other custom database tables
After selecting the Main Table, JP CS DataQuery automatically discovers its available columns and makes them available for query configuration and Dynamic Content field mapping.
