JP CS Data Query - Troubleshooting
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 16 of 18
Troubleshooting
JP CS DataQuery does not appear in Dynamic Content
- Confirm that System - JP CS DataQuery is installed and enabled.
- Confirm that you are configuring Dynamic Content inside YOOtheme Pro.
- Look under Custom -> JPro Studio -> JP CS DataQuery.
- Clear Joomla and YOOtheme Pro caches before testing again.
The required database table does not appear
- Confirm that the table exists in the Joomla database.
- Reload the YOOtheme Pro Customizer.
- Search using the clean table name without the Joomla database prefix.
Joined data is empty
- Confirm that the correct Join Table has been selected.
- Verify the Main Table Column and matching Right Column.
- Confirm that both columns contain matching relationship values.
- For Left Join 2, verify that the correct Join 2 Source Table is selected.
Expected fields do not appear in YOOtheme Pro
- Confirm that the correct Main Table is selected.
- Confirm that the required Join table is enabled.
- Reload the Dynamic Content configuration after changing tables.
- Look for table-prefixed fields such as
content_title,categories_title, orusers_name. - Check whether one of the standard compatibility fields can be used instead.
Only a limited number of records are displayed
- Check the Quantity / Limit setting.
- Increase the limit when more records should be available.
- Check the Start / Offset value.
- When using JP CS Global Pagination, ensure the DataQuery limit is large enough for the complete dataset you want to paginate.
